Newbie ODBC Q: How to connect to MY database

From: Jeff <MissingLink_at_n2mail.com>
Date: 2000/05/24
Message-ID: <8gh2ca$lk2$1@news5.svr.pol.co.uk>#1/1

Hi,

I've created my own database under POLITE ie I log in via sqlplus as ODBC:POLITE:MYDATABASE

and the ODBC examples work on the sample database with:

       #define DSN  "POLITE"
       char *DataSource = DSN;
       char *UserId = "", *Password = "";

        rc=SQLAllocEnv(&Henv
        rc=SQLAllocConnect(Henv, &Hdbc
        rc = SQLConnect(Hdbc, (unsigned char *)DataSource, SQL_NTS,


               (unsigned char *)UserId, SQL_NTS,

               (unsigned char *)Password, SQL_NTS);

but how do I connect to my own database thru ODBC ?

#define DSN "POLITE:MYDATABASE" doesn't work.

Thanks: Received on Wed May 24 2000 - 00:00:00 CDT