FreeTDS Development Group

[Ken Collins <ken AT metaskills.net>]

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