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.
>>>
Précédent
Suivant
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