🚀 go-pugleaf

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