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!