Could not find Database parameter, SQLSTATE=08001

Brian Bruns camber at ais.org
Fri Nov 30 14:42:12 EST 2001


The Servername parameter (Servername = IVR2) is missing from your odbc.ini
file.  Unfortunately, the error message is a bit misleading (I didn't do
it!).  I'll see about fixing it.

Brian

> i have compiled freetds with these parameters:
> ./configure --prefix=/usr/local/freetds --with-iodbc=/usr/local/iodbc
> --with-dbmfix --with-tdsver=4.2
> 
> i have also tried without the dbmfix and tdsver but received the same
> results
> 
> the server is redhat7.1 connecting to mssql running on windows 2000. i can
> use iodbc drivers but they dont support unicode. so i decided to give
> freetds a try.
> 
> with iodbc's odbctest script i can see the dsn list and connect to the
> sample JDBC.. but for some reason neither of our mssql servers is
> responding, instead i get "Could not find Database parameter,
> SQLSTATE=08001"
> 
> freetds.conf looks like this:
> [IVR2]
> 	host = 192.168.11.8
> 	tds version = 7.0
> 	try server logins = yes
> 	port = 1433
> 
> the rest of the stuff is in odbc.ini:
> [IVR2]
> Driver          = /usr/local/freetds/lib/libtdsodbc.so
> #Host            = 192.168.11.8
> Database        =catalog
> FetchBufferSize = 99
> UID             = username
> PWD             = password
> Trace           = no
> 
> The question is, what am i doing wrong?
> 
> Paivi



More information about the FreeTDS mailing list