Forum Discussion

manuel_buelow's avatar
manuel_buelow
New Contributor
12 years ago

Can't connect to an Oracle 11g x64 Database

Hello there,



i want to connect on an oracle database per delphiscript in TestComplete 9.30.

It is an 64-Bit Database and I have installed an 64-Bit Oracle Client, so I can connect to the Server, where the Oracle Database takes place.

I've tested 2 Providers and both throwing different Exceptions:

The Provider "MSDAORA" throws an ORA-01019: "unable to allocate memory in the user side".

The Provider "OraOLEDB.Oracle" throws an absurd exception, which looks like a segmentation fault. It contains different characters on every call (f.e. "w¸?(").

My program code lookes like:

procedure EmptyTableOracle(Table: String);

var

  AConnection: OleVariant;

begin

  // Create a Connection object

  AConnection := ADO.CreateADOConnection();

  // Specify the connection string

  AConnection.ConnectionString := OracleConnectionString;

  // Suppress the login dialog box

  AConnection.LoginPrompt := false;

  AConnection.Open();

  // Delete all the content from the specified table

  AConnection.Execute_('DELETE FROM '+Table);

  // Close the connection

  AConnection.Close();

end;



The exceptions always appears on the line "AConnection.Open();".



I hope you can help me out.
No RepliesBe the first to reply