DAO 3.5 ODBCDirect and stored procs help 
Author Message
 DAO 3.5 ODBCDirect and stored procs help

you're right.. if the sql statement can't be parsed, for whatever reason, then
the parameters collection will be empty.  if you're calling a stored procedure,
make sure the stored procedure is there, and executable.  if it's a
parameterized query, make sure it's syntax is correct.  try a simple 'SELECT *
FROM table WHERE column = ?' parameterized query to see if it gets parsed
correctly.
--
..........................................................
Fred Woolard
a4 Health Systems



Mon, 17 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. DAO 3.5 ODBCDirect and stored procs help

2. Q: DAO 3.5 w/ODBCDirect call Oracle SP w/Output Params

3. VB 4 and DAO 3.5/ODBCDirect

4. US/UK Date corruption: Jet 3.5 stored procs via Jet 4

5. Moving from DAO 3.5 to DAO 3.6

6. DAO 3.5 & DAO 3.51 work differently

7. Convert DAO 3.5 to DAO 3.6 Jet Engine 4.0

8. DAO 3.5 vs DAO 3.51

9. DAO 3.5 object library vs. DAO 3.51

10. DAO 3.6 vs DAO 3.5 (VB6.0 sp3)

11. VB4 is DAO 3.5 safe, or DAO 3.0 better

12. VB4 is DAO 3.5 safe, or DAO 3.0 better

 

 
Powered by phpBB® Forum Software