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.