dsnless
Sven Köhler
skoehler at upb.de
Mon Oct 14 02:33:04 EDT 2002
>>Do i need a freetds.conf when using ODBC?
>
> Yes. Stay tuned for further developments. :)
i'll surely do :-)
>>Any option which applies to a server should be abled to be within the
>>ODBC-DSN.
>
> I don't understand, sorry.
this thread is about DSNless connecting.
what i was looking for was also freetds.conf'less connecting.
Example 3-1. A freetds.conf file example
[global]
tds version = 4.2
[myserver]
host = ntbox.mydomain.com
port = 1433
[myserver2]
host = unixbox.mydomain.com
port = 4000
tds version = 5.0
this is from you online-manual.
what about an odbc-dsn looking like this:
[myserver]
Description=A DSN working without the freetds.conf
Host=ntbox.foo.com
Port=1433
TDS_Version=7.0
Database=testdb
UID=test
PWD=test
when i understood everything right, the Servername-parameter in an
ODBC-DSN only points at the entry within the freetds.conf - why???
why aren't you using the above to make the odbc-interface independent
from freetds.conf (because ODBC already partly does what the
freetds.conf does: offer a central point for databse-config)
More information about the FreeTDS
mailing list