-
iSQL Stored Procedure
OK.. This is not really C++, but... I'm using the answer to help me develop a C++ program (<G>)...
I'm using iSQL and am having difficulty executing a stored procedure with parameters. Some parameters have spaces (like time/date fields)..
I thought you did it like this:
sp <param 1> <param 2> <param 3>
go
StoredProcedure TestData 06/05/2002 07:00 PM MoreTestData
go
I've tried putting the dates in single quotes, double quotes, pound signs, brackets, etc.... It doesn't like anything I use to enclose the date.
Any ideas?
-
Have you tried # to enclose the dates?
-
Yep, that didn't work either...... I'm losing my mind.... aaaaaaaaaaa
-
Yep, that didn't work either...... I'm losing my mind.... aaaaaaaaaaa
-
OK... Here's the deal... This is ODBC pointing to SYBASE. In order to fix it, I had to go into the Initialization string on the Advanced settings tab of the ODBC driver and type "SET ANSINULL OFF".
That cleaned it up.