Trying to connect HDX using Database Integration Wizard we have SQL statement trouble.
Just SELECT SQL statements receive back data from the MS SQL 2000 server .
Procedures SQL statements i.e. EXECUTE …. are not able to read returned data.
Symposium Server rel. 5, MS SQL version driver on server installed is 3.70.11.46.
Are there just SELECT statements available with this new feature, or what we could do to make work EXECUTE SQL statements ?
Stored procedure used as a statement returns the same resultset like SELECT. The difference has been observed directly in Database Integration Wizard using "Test Execute" - first statement (SELECT... WHERE) resulted data visible in "Test Output", second statement (EXECUTE sp_myproc) didn't.
Any tips or ideas greatly appreciated,
jj
Just SELECT SQL statements receive back data from the MS SQL 2000 server .
Procedures SQL statements i.e. EXECUTE …. are not able to read returned data.
Symposium Server rel. 5, MS SQL version driver on server installed is 3.70.11.46.
Are there just SELECT statements available with this new feature, or what we could do to make work EXECUTE SQL statements ?
Stored procedure used as a statement returns the same resultset like SELECT. The difference has been observed directly in Database Integration Wizard using "Test Execute" - first statement (SELECT... WHERE) resulted data visible in "Test Output", second statement (EXECUTE sp_myproc) didn't.
Any tips or ideas greatly appreciated,
jj