🚀 go-pugleaf

Thanks for the reply.

I actually found the answer i another newsgroup.

This link provides good information about connection strings for ODBC and
ADO on serveral database systems.
http://www.able-consulting.com\ADO_Conn.htm

Jens

"Bill Rampey" <brampey@flsg.follett.com> wrote in message
news:3c7ba6a3$1_1@dnews...
> Hi Jens,
>
> I had to figure this out by wadeing through these groups.  Here is a
snipet
> of code that should help you out.  Read the comments below for your
answer.
>
>        _connection = new TADOConnection(Application->MainForm);
>
>        assertSTOP(_connection!=NULL);
>
>        try
>        {
>          String cs;
>
>          // This connection string specifies the "type"
>          // of connection that should be used to talk with
>          // the SQL Server.  "Network Library=DBMSSOCN" means
>          // use TCP/IP as the protocol.  The default if nothing
>          // is specified appears to be "Named Pipes" which won't
>          // work on Windows 9x machines without requireing.
>          // a user account to exist on the server.
>          // Other options are available but TCP/IP should work
>          // fine.
>
>          cs = "Provider=SQLOLEDB.1;Network Library=DBMSSOCN;Password=";
>          cs += _SQLPassword;
>          cs += ";User ID=";
>          cs += _SQLUser;
>          cs += ";Initial Catalog=";
>          cs += database;
>          cs += ";Data Source=";
>
>          if(_liveData)
>            cs += getLiveServerName();
>          else
>            cs += getTestServerName();
>
>          _connection->ConnectionString = cs;
>          _connection->KeepConnection = true;
>          _connection->LoginPrompt = false;
>          _connection->Mode = cmReadWrite;
>          _connection->IsolationLevel = ilCursorStability;
>          _connection->Connected = true;
>          established = true;
>        }
>        catch(...)
>        {
>          delete _connection;
>          _connection = NULL;
>          SHOW_ERROR("Exception thrown activateing ADO connection.");
>        }
>
> -Bill
>
>
>