Using DBLIB With Azure

Ken Collins <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
So I am testing TinyTDS with Azure and I am close. I have 0.83.dev installed with OpenSSL and can connect with tsql. 

$ tsql -S azure -U tinytds@abc -P password -D tinytdstest

But I am having an issue with figuring out a way to use a database setting. I know that Azure does not have a notion of "USE ..." or has a way to specify a default database with the user account, so I was let with reverse engineering how tsql accomplishes a connection using the -D option and I am left stumped as to how I can get TDSCONNECTION's database string in there. FYI, TinyTDS only uses sybdb.h and sqlfront.h, so some things that tsql is doing is not a public API. Perhaps there is something that can be done for this? 

I had hoped that putting a database in my freetds.conf would help. For instance.

[azure]
  host = abc.database.windows.net
  port = 1433
  tds version = 8.0
  database = tinytdstest

Since I assumed that this would populate the struct for me. It may just be doing that, but because of login.c (around line 430) never has db_selected to false for high TDS versions? Maybe this is not the right spot too since it ultimately does a "USE " too. I guess the question is, how does tsql work and how can I help make DBLIB work too?


 - Ken
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.