Re: Using DBLIB With Azure

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