ODBC Driver Error {UPDATE]

ODBC Driver Error {UPDATE]

Post by cnhzaW » Sat, 30 Apr 2005 09:40:02


{UPDATE}
Creating a system DSN on the new 2003 server works, if the "Named Pipes"
network libraries are choosen in the set up. If the TCP/IP network libraries
are choosen...the connection fails. Named pipes uses port(s) 445 & 139. The
TCP/IP libraries use port 1433.

Why would Named pipes work and not TCP/IP?
 
 
 

1. PN: ODBC Compliance of Data Direct ODBC drivers to SQL Server ODBC drivers

2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr fail

Hello;

I have an ASP application build with Dreamweaver that uses the ODBC
connections to a ms access db that was working until now (for at least 6 to 7
months) for what ever reason I was updating some data in one of the database
tables and once I decided to go to the site I am now getting this error

I have seen this error before and i know there is a fix. but I can't figure
it out

can anyone help

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/synthnet/verify.asp, line 7


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322;
InfoPath.1; .NET CLR 2.0.50727)

Page:
GET /synthnet/verify.asp

3. error 1918 excel driver odbc driver error

4. ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

5. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE

6. ODBC SQL Server Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()).

7. SQL Server ODBC Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()).

8. ODBC error : [Microsoft][ODBC SQL Server Driver]Communication link

9. ODBC Microsoft Access Driver] Could not update; currently locked Error

10. VFP8.0 ODBC driver not in the list of ODBC drivers

11. SV: VFP8.0 ODBC driver not in the list of ODBC drivers

12. SQL2K ODBC driver & Older ODBC Driver

13. Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] To

14. ODBC driver does not show up in driver list in ODBC data source administrator