>>Here's the code I'm using:
>>
>>nconn=sqlconn('odbcName')
>>? SQLexec(nconn, 's_get_tpv')
>>
>>nconn is 1
>>I know that s_get_tpv is the name of the stored procedure. I even tried it in VB 5.0 with a User Connection and it recognizes the stored procudure. However, when I execute the SQLexec statement, it consistantly returns a -1. Is there something specific to the syntax in SQL 6.5 that I'm missing in calling a stored procedure? Also, there are 2 parameters that I need to pass to the procedure. Any help would be appreciated!
>>
>>Tom
>>
>>
>>>Hi John
>>>
>>>Thanks!
>>>
>>>>Hi Tom ---
>>>>
>>>>You're going to want to use SQL passthrough techniques such as:
>>>>
>>>>nConn=SQLCONNECT('DataSourceName') && DataaSourceName given the ODBC driver
>>>>=SQLEXEC(nConn,'sp_MyStoredProc')
>>>>
>>>>>I have established an ODBC connection to a SQL 6.5 Server over a dialup connection. I need to call two stored procedures in the SQL Database. I haven't been able to figure out how.
>>>>>
>
>
>lcProcedure = "Exec SP_ProcedureName ?Parameter1, ?Parameter2"
>lnResult = sqlexec(nSqlHandle, lcProcedure, "MyCursor")
I'll see if it works...
Thanks.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only