CONNECT problem w/ Personal Oracle Lite

From: Charles Cummings <charles.s.cummings_at_citicorp.com>
Date: Wed, 08 Apr 1998 10:23:16 -0400
Message-ID: <352B8854.4794@citicorp.com>

Please help with an Oracle Lite question - I'm trying to do an ESQL CONNECT in a c program (Windows 95, MS C compiler). ESQL complains about the following:

EXEC SQL BEGIN DECLARE SECTION;

char cUser[20] = "OOT_SCH";
char cPassword = "foobar";
char cDatabase = "ODBC:POLITE";

EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT :cUser IDENTIFIED BY :cPassword USING cDatabase;

I get "syntax error at CONNECT". Does Oracle Lite support this? I get the impression from their documentation that it does. If not, how can I specify the database that I'm connecting to? The example ESQL programs all build and run with no problem, but don't specify a database - is everything working off the default database? Is this a limitation of the demo version?

Any thoughts on this will be greatly appreciated.

Thanks! Received on Wed Apr 08 1998 - 09:23:16 CDT