|
-
October 13th, 1999, 01:05 PM
#1
Stored Procedures
I have created an ODBC connection 'conPubs',
and I have successfully managed to use the CreateQueryDef to use a SQL string to extract the info. It says in the documentation that you can substitute this SQL string with a Stored Procedure name. So I wrote a basic stored procedure in SQL Enterprise, added it to the Database, and tried to run this sp name instead of the SQL string from the client. I got an error message 3146 ODBC call failed.
The stored procedure name is 'pr_vb_test'
the code is:
strSQL = "pr_vb_test"
Set qdfTemp=conPubs.CreateQueryDef("",strSQL)
Set rsTemp=qdfTemp.Openrecordset
Can anyone help please?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
