Skip to Content.
Sympa Menu

freetds - Re: [freetds] Using DBLIB With Azure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: jklowden AT schemamania.org
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Using DBLIB With Azure
  • Date: Thu, 10 Mar 2011 17:41:35 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page