wybin
10-16-02, 00:28
| I need to connect to Sybase DB in ASP,transaction is also needed. This is my ASP file: Test.ASP <%@ LANGUAGE=VBSCript TRANSACTION=Required%> <Script Language=VBScript RUNAT=Server> Dim gADODBConnString gADODBConnString = "Provider=Sybase.ASEOLEDBProvider;User ID=sa;Password=;Data Source=unierp" On Error Resume Next Err.Clear Set pObjConn = Server.CreateObject("ADODB.Connection") pObjConn.ConnectionString = gADODBConnString pObjConn.ConnectionTimeout = 180 pObjConn.Open If Err.Number <> 0 Then response.write "OpenDB Error" & Err.Number response.end End If If the first line is deleted , the connection is OK,but if the first line is exist,the error will occur. Can you help me how to deal it? Thanks lot! |