>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement