FreeTDS Development Group

[jklowden AT schemamania.org]

On Wed, Mar 09, 2011 at 01:26:53PM -0500, Ken Collins wrote:
> 
> 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? 

In src/apps/tsql.c, look for opt_default_db.  

The TDS 7+ login packet has a default database field, cf. doc/tds.html.  

The db-lib dbuse() function just sends "USE dbname" to the server.  

HTH.

--jkl