[freetds] Problem connecting to SQL server on linux
Frederik Teerlinck
largowww at gmail.com
Tue Sep 26 12:21:44 EDT 2006
Tried all that, but it didn't make a difference. However, meanwhile I did
find the solution. Once more I checked if I had the correct settings for my
datasource in freetds.conf and I noticed that I had a freetds.conf in
/usr/local/etc and one in /etc. I've copied one over the other and now it
seems to be working perfect.
Thanks for all the usefull help!
2006/9/26, Lowden, James K <james.k.lowden at alliancebernstein.com>:
>
> From: Frederik Teerlinck
> Sent: Tuesday, September 26, 2006 10:08 AM
>
> > tsql -S MYDBNAME -U MYUID -P MYPWD
> > This works perfect.
> ...
> > isql -v MYDBNAME MYUID MYPWD
> > [unixODBC]Client unable to establish connection
> > [ISQL]ERROR: Could not SQLConnect
> ...
> > ::::::::::::::
> > odbc.ini
> > ::::::::::::::
> > [MYDBNAME ]
> > Driver = TDS
> > Description = ODBC connection via FreeTDS
> > Trace = No
> > Servername = MYDBNAME
> > Database = MYDBNAME
> ^^^^^^^^ try removing this line
Removed this, but no that made no difference
> ::::::::::::::
> > odbcinst.ini
> > ::::::::::::::
> > [TDS]
> > Description = FreeTDS
> > Driver = /usr/lib/odbc/libtdsodbc.so
> > Setup = /usr/lib/odbc/libtdsS.so
> > FileUsage = 1
>
> These aren't needed:
>
> > CPTimeout =
> > CPReuse =
> > UsageCount = 1
Removed these also, but also no difference
Does your database have the same name as your server? This will display
> your default database:
>
> $ echo 'select db_name()' \
> | bsqldb -q -S MYDBNAME -U MYUID -P MYPWD
Yes this returns MYDBNAME as default database.
The IP-address of the server only needs to be specified in
-----------------------------------------
> The information contained in this transmission may be privileged and
> confidential and is intended only for the use of the person(s) named
> above. If you are not the intended recipient, or an employee or agent
> responsible
> for delivering this message to the intended recipient, any review,
> dissemination,
> distribution or duplication of this communication is strictly prohibited.
> If you are
> not the intended recipient, please contact the sender immediately by reply
> e-mail
> and destroy all copies of the original message. Please note that we do not
> accept
> account orders and/or instructions by e-mail, and therefore will not be
> responsible
> for carrying out such orders and/or instructions. If you, as the intended
> recipient
> of this message, the purpose of which is to inform and update our clients,
> prospects
> and consultants of developments relating to our services and products,
> would not
> like to receive further e-mail correspondence from the sender, please
> "reply" to the
> sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas,
> New York,
> NY 10105.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
More information about the FreeTDS
mailing list