sql server odbc:

Problem: I came in this morning, and our SQL server's IP address was
changed from a static to dynamic IP. I changed it back, but not sure if
that is the cause of the problem I am having.

Running some reports in Access 2000 that queries through ODBC to our SQL
Server 2k. We are getting an error when attempting to run the report.

*start error message
Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] Invalid connection string attribute
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionOpen(connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] General Network
Error
*end of error message

What is going on? How do I resolve it? Thanks in advance


*** Sent via Developersdex http://www.developersdex.com ***

Something was up with the network side of accessing the SQL Server.
Rebooting the server cleared up the connection issues.


*** Sent via Developersdex http://www.developersdex.com ***

Hi! Good Day!

I have problem with my ODBC Data Source(32bit) which cannot
add,configure existing database because it will come up system erro
code 31 (Microsoft Access Driver (*.mdb)) was missing or unable to loa
the setup or translator library as well as another Micorosoft Offic
database.

I'm asking for ur help.

Thank you


-
jc
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message519054.htm