Forum

Hello, How do I make oracle connection string .

Hello, BURAK UYANIK.

If you are trying to create an infobase having a database on Oracle DBMS, here is an example:

Hello Timofey Bugaevsky,
Oracle data from t want to get in the way. But it does not make a connection.

"Open()" gives an error in the code line.

ConnectionString = "Driver={Microsoft ODBC for Oracle};
|Server=192.168.1.120; 
|DataBase = myData; 
|Uid=1C;
|Pwd=1234"; 
        
Connection = new COMObject("ADODB.Connection"); Connection.ConnectionString = ConnectionString;
Connection.ConnectionTimeout = 50;
Connection.CommandTimeout = 1000;
Connection.Open();

Hello!
Try to use another provider. For example, this connection string:

ConnectionString = "Provider=MSDAORA;Password="
    + Password + ";User ID=" + UserName + ";Data Source=" + DatabaseName 
    + ";Persist Security Info=True;CharSet=american_america.al32utf8;"

I am soryy it did not work

Do you have MSDAORA provider registered on your machine?

Yes I do

Then maybe you do not have an Oracle client on your machine.

Please, copy the entire error message.

Also found that Microsoft suggests using Oracle's OLE DB provider.

{Document.personel.form.documentform_y.form (1556)}: An error occurred in the process of content method call (Open)
                               adoconnection.op the ();
therefore:
Exceptions occurred (Microsoft OLE DB Provider for Oracle): Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle 7.3.3 or later installation of client software.

These components are loaded, the provider will not work.

So, this is the reason:

"Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle 7.3.3 or later installation of client software."

You need to install Oracle client and networking components 7.3.3 or later.