How to fix error: ConnectionOpen (connect()) ?
Hi everybody !
I use Linux CentOS 4.4, SunOneChili!Soft 4.2, Apache 2.0x
When I creat DSN (use ASP) connnect to SQL server 2000, i get error :
Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: 0 Native Error Code: 11 [DataDirect][ODBC SQL Server Driver][libssclient20] SQLState: 01000 Native Error Code: 111 [DataDirect][ODBC SQL Server Driver][libssclient20]ConnectionOpen (connect()).
Include/inc_DataConn.asp, line 11
Here are source code to connect:
ConnStr = "Driver={SQL Server};DSN=thuvien; Address=127.0.0.1,1433;Connect Timeout=60;Pooling=False;Max Pool Size=5;UID=sa; PWD="
set adoConn = server.CreateObject("ADODB.connection")
adoConn.ConnectionString = ConnStr
adoConn.CursorLocation = 3
'Error here
adoConn.Open ConnStr
I created DSN thuvien
Please help me to fix this error
Thank's everybody
