manuel_buelow
12 years agoNew Contributor
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.
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.