driver version 3.10.8.0 with MSSQL 2005 Express edition not working ?

QwiqBart · Post by **QwiqBart** » Tue 11 Dec 2007 21:30

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

Antaeus · Post by **Antaeus** » Wed 12 Dec 2007 09:07

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.

QwiqBart · Post by **QwiqBart** » Thu 13 Dec 2007 18:33

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

Antaeus · Post by **Antaeus** » Fri 14 Dec 2007 08:33

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?

QwiqBart · Post by **QwiqBart** » Fri 14 Dec 2007 09:05

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

Antaeus · Post by **Antaeus** » Mon 17 Dec 2007 15:05

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.