Hi
Has OLEDB for SYBASE ?
thank you in advance
Printable View
Hi
Has OLEDB for SYBASE ?
thank you in advance
You could try using the SQL Server OLE DB Provider.
The Net libraries havn't changed much since SQL V 4.2 (which was Sybase 4.9.2 with 2 strored procedure changes)
------------
mutley at 2/23/01 8:26:01 AM
Hi
Has OLEDB for SYBASE ?
thank you in advance
I don't know. But, This can help you?
<%
Dim strSQL
Dim Conn
Dim rsSQL
'Write Query
strSQL = "Select * From xx"
'Connect to Sybase via ADODB
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={Sybase System 11}; Srvr=xxx; Db=xx; Uid=xx; Pwd=xx;"
'Execute Query
Set rsSQL = Server.CreateObject("ADODB.recordset")
rsSql.Open strSQL, Conn, 3
%>