October 17, 2008 at 6:48 pm
Hi,
I'm using Access 2003 on client machines to access a SQL Server 2000 db on the Server. I've built stored procedures in the db which I execute in Access via SQL pass through queries.
I was using an ODBC connection via a System DSN. It was working fine on one machine then tried to duplicate the front end on another.
The following error was thrown:
Microsoft SQL Server Login
Connection failed:
sqlstate: '01000'
sql server error :10060
[microsoft][obdc sql server driver][tcp/ip sockets]connectionopen (connect()).
Connection failed:
sqlstate: '08001'
sql server error :17
[microsoft][obdc sql server driver][tcp/ip sockets]sql server does not exist or access denied.
Now I can't get connected to the db anywhere with the connection string that was working. Connection tests that were successful are now failing.
October 18, 2008 at 4:07 pm
Is the system dsn installed on the other machines with the same name?
How does your connectionstring looks like?
October 18, 2008 at 5:03 pm
And be sure the SQL Server is running.
I'd also try some pings/odbcpings from the new client to see if it can connect to the server.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply