Page 1 of 1
driver version 3.10.8.0 with MSSQL 2005 Express edition not working ?
Posted: Tue 11 Dec 2007 21:30
by QwiqBart
Hi,
I am using version 3.10.8.0 of the dll and try to logon to MSSQL 2005 Express edition, but the logon fails. Do I need to upgrade to version 4, or can I change some login parameters ?
Thx, Bart
Posted: Wed 12 Dec 2007 09:07
by Antaeus
If you try to connect to SQL Server Express from a remote host, please check whether your server lets remote connections. This option is disabled in SQL Server Express by default.
Posted: Thu 13 Dec 2007 18:33
by QwiqBart
Hi, thanks for your reply.
We are not trying to logon from a remote host, so that can't be the problem. Are there differences in login parameter settings compared to SQL2000 ?
Thanks,
Bart
Posted: Fri 14 Dec 2007 08:33
by Antaeus
Connection parameters are the same both for SQL Server 2000 and 2005.
Can you connect to your SQL Server Express using another client? What is the exact error message you get?
Posted: Fri 14 Dec 2007 09:05
by QwiqBart
Yes we are able to connect through ODBC from MS Access.
What I forgot to mention that we moved to Windows Vista. Could this have adverse effects ?
Thanks, Bart
Posted: Mon 17 Dec 2007 15:05
by Antaeus
It is likely that there is something wrong with MDAC/SQL Native client at your Vista. Please contact me by e-mail, I will send you a test application to check this.