Skip to Content.
Sympa Menu

freetds - [freetds] Using DBLIB With Azure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ken Collins <ken AT metaskills.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Using DBLIB With Azure
  • Date: Wed, 9 Mar 2011 13:26:53 -0500


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





Archive powered by MHonArc 2.6.24.

Top of Page