data environment - stored procedure - ms access 2000 db 
Author Message
 data environment - stored procedure - ms access 2000 db

Using vb6 pro with data environment designer.  I imported the queries from access
to data environment as stored procedures, which the data environment allows.

I attempt to run the query using the syntax

de.RunMyQuery

where RunMyQuery is one of the stored procedures imported from access.  

I get the following error message.  

Run Time error -214217900 (80040e14)

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT'
or 'UPDATE'

My queries are all DELETE, INSERT or UPDATE queries and when I cut the SQL from
access and paste it into the de command, it will run with no problem.  

However I have many queries and would like to separate the query activities to
the server not the client.

Any thoughts on what is going on here?

.



Mon, 02 Jun 2003 06:42:01 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Access 2000 db and stored procedures

2. Calling a SQL Server 2000 store procedure from MS-Access

3. Executing MS SQL Server 2000 stored procs via MS Access 2000

4. Please post a sample for accessing MS Access 2000 db

5. access 2000 vba and stored procedures

6. Access 2000 VBA - SQL stored procedure question

7. Stored Procedure limitation in Access 2000?

8. Can't add stored procedure in Data Environment

9. Trouble with stored procedures in data environment

10. Data Environments, Oracle and Stored Procedures

11. Access 2000 Stored Procedure

12. Oracle Stored Procedures and The Data Environment

 

 
Powered by phpBB® Forum Software