Author: zwztu
Http://search.9cbs.net/expert/topic/1612/1612693.xml?temp=.2369806
First, if you use OLEDB? If you use ASE's OLEDB provider, where is this provider?
Secondly, if you use MSDataShape, it can be, but the speed seems to be very slow. . .
If you use OLEDB for ODBC, it can be tested when it is created, but the invalid property is prompted after the establishment is completed.
Finally, using odbc.net is indeed, but how to call the stored procedure with parameters?
Some people say that in command.text is written as a call {. . . . . } I have tried it. I used to prompt the error provided by the parameters, but in exchange for other inexplicable errors, please talk about it in detail? Thank you
-------------------------------------------------- -------------
OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
Oconn.open "provider = Sybase ASE OLE DB Provider;" & _
"Data Source = MyaseServer"
'OR
Oconn.open "provider = Sybase.AseoledbProvider;" & _
"SRVR = MyaseServer, 5000;" & _
"Catalog = mydbname;" & _
"User ID = myusername;" & _
"Password = myuserpassword"
WHERE:
- The Sybase ASE OLE DB Provider from the Sybase 12.5 Client CD
- 5000 is The port number for sybase.
.
Note: with Open Client 12.5, The Server Port Number Feature Finally Works, Allowing Fully Qualified Network Connection Strings To Be.com Data Source Files.
http://my.sybase.com/search_advanced
