Devart Forums

I'm running Embarc CBuilder 2010...dropped an oracle seesion on form and need a connectioin string -- can some one provide me with a sample of what it should look like...or point me to a sample??Thanks.

May be this helps you (code snippet from Delphi):

OraSession1.Options.Direct := true; // true=direkt Mode;
OraSession1.Options.ConnectionTimeout := 60000; // 60 seconds
OraSession1.LoginPrompt := false;
OraSession1.Username := 'TEST';
OraSession1.Password := 'test';
OraSession1.Server := '194.76.125.47:1521:NEW'; // adjust your IP
try // e2
OraSession1.Ping; // in case of failure raises an exception
// or immediately do the connect:
// OraSession1.Connect;
except // e2
on E: exception do
begin
memo1.lines.add (' Ping-OraSession Exception '+E.Message );
exit;
end;
end; //e2
end;

So, there is no connection string when one chooses directconnect????

In my example the connectstring is something like:

Login Prompt=False;Data Source=194.76.125.47:1521:NEW;User ID=TEST; Password=test;Schema=NEW;Connection Timeout=60000;Direct=True

Hello,

The ConnectionString property can be set in several ways:
1) SQLPlus analogue 2) ADO analogue