FreeTDS Development Group

[Konrad J Hambrick <konrad AT payplus.com>]

Ken Collins wrote, On 03/09/2011 12:26 PM:
> 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 --

Have you looked at sqsh ?

-- kjh