Re: Using DBLIB With Azure

Well, we store plenty of client properties in the freetds.conf.
textsize, timeouts, client charset, etc...

Certainly, if the .conf had a database property set, the program could
override it.  Like DBSETLPACKET() and "initial block size" options.

If and when I find the need to connect to Azure, you can look for a
patch from me, as sqsh and other clients will be hard pressed to act
correctly without.

Of course, with ODBC one can encode the username, password, and so on
both in the odbc.ini and set it programmatically as well, the
programmatic settings overriding the configuration file ones.

All that said, I have a couple other extensions to dblib and ctlib,
I'll get around to wrapping up and submitting someday soon, so perhaps
dblib is not dead, just the organization in charge of extending it has
changed.

Brian

2011/3/27 James K. Lowden <[email protected]>:
> On Sun, 27 Mar 2011 14:48:49 -0400
> Brian Bruns <[email protected]> wrote:
>
>> I would think the most natural place for this is the freetds.conf (and
>> odbc.ini, or DSN connection string).
> ...
>> Maybe I've misunderstood the issue, and besides I'm all talk and no
>> code. ;-)
>
> You're plenty code, Brian.  You get to opine.
>
> As illustrated by the DSN connection string, the key problem with
> putting the "initial database" in freetds.conf is that it precludes the
> program(mer) from setting the database name.  The API Ken is
> implementing allows the application to pass a databse name, and Azure
> prohibits changing databases after the initial connection.
>
> Server properties, kept in freetds.conf, describe the server to the
> client so that it can connect.  Client properties, kept in LOGINREC,
> describe the client to the server.  The initial database is not a
> server property; it is something the client requests of the server.
>
> Sybase and particularly Microsoft stopped updating db-lib a long time
> ago.  If they had -- if ODBC and ct-lib had never been invented --
> surely they would have provided a way for db-lib to set the database
> name in the login packet.
>
> Regards,
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>