Problem with webservice connecting to SQL server

[Athley]

Hi!

I have a problem with a simple web service that is querying a SQL sever, if I use the service to connect to a SQL 2000 server it works fine, but if I connect to the 6.5 server that the 2000 server was upsized from I get the following error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

The 2 servers have the same security settings, in truth the security setting is lower on the 6.5 (all machines and users in the network can access it as "sa" with no password).

Anyone know what the problem might be....?

[nswan]

are you using:

imports system.data.sqlclient

?

if so i think this is only for sql 2000 servers. you will have to use system.data.oledb for sql server 7 and before.

[Athley]

nope I'm using Oledb....

I also tried to download the ODBC .NET sdk and tried to connect. Still works on 2000 but not on 6.5, and the same error but from the ODBC provider instead:

ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

[Athley]

new updates

My recent try was with classic ADO..... same error on 6.5, works on 2000.

Always works if I copy the code and put it in a Windows Application instead of Web service.....