var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedures using OLE DB driver for Sybase ASE 12.5 through ADO
I'm wondering if anyone got around running stored procedures directly through the ADO controls, withing the need of the explicit parameter append calls.
I have something like this.
Dim cmd as ADODB.Command, rs ad ADODB.RecordSet
cmd.ActiveConnection = GetConnectionString()
cmd.CommandType = adCmdText
cmd.CommandText = "sp_DoSomething 1,2,'varcharparam'"
cmd.Prepared = True
rs.CursorLocation = adUseClient
rs.Open cmd, , adOpenForwardOnly, adLockReadOnly
When this is run, it returns the following error
[Native Error code: 203]
[DataDirect ADO Sybase Provider] The name 'sp_DoSomething 1,2,'varcharparam'' is not a valid identifier.
The code was running fine on Sybase ASE 12.0, but the error appeared once I've upgraded to ASE 12.5.
Anyone know if there are any settings that gets this working, besides needing to resolve to
I faced the same problem too. I am not sure if what ever
I suggest is the solution to your problem. But it worked fine
for a C++ Client. Try calling the stored procedure as
cmd.CommandText = "sp_DoSomething (1,2,'varcharparam')"