FreeTDS Development Group

["Rattan, Neeta S" <nsratta AT sandia.gov>]

Hi,

I am very new to using freetds and am still at the point of connecting
to the DB using the unixODBC libs from C.  I am using:
SQL Server version      8.0/Win2K
FreeTDS version 0.64    
Client is Suse Linux

I have been able to successfully run and connect using both tsql and
isql, although I need to specify the username and password at the
command line as I was not using the DSN-less connect, so setting the
UID/PWD fields in the .ini files wouldn't be fruitful.  Even if I set
them, and then leave out that info at the command line, it fails to
connect with error of "login failed for user ''"  (ie. it thinks user is
blank).

However, from my C code using the SqlDriverConnect() function, I keep
getting a failed to connect error.  I am specifying my connection string
to be "DSN=<dsnname>;UID=neeta;PWD=xxx" with no luck.  If there are
thoughts on why this might be happening, I would much appreciate it!

In the meantime I am going to try to compile some of the sample code in
src/ although briefly looking at it, it looks quite similar to mine.

Thanks in advance,
Neeta Rattan