Oracle via ADODB and ODBC

Question

Hi,I'm connecting to Oracle database using Oracle drivers via ODBCI'm using the following connection string:Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=MY_SOURCEI can succesfully bind adInteger&nbsp;&nbsp;input paramters to my SQL queries.How can I bind VARCHAR2&nbsp;input paramter?I've tried: &nbsp; var PrmMarket = sqlCmd.CreateParameter("MARKET", adVarChar, adParamInput,7); &nbsp; sqlCmd.Parameters.Append(PrmMarket); &nbsp; PrmMarket.Value = iDstMarket;  But when I call execute I get "Unspecified error" from a provider. I've also tried adVariant adChar  Could you please advise?  &nbsp;

tanyayatskovska · Answer

Hi Maurycy, &nbsp; I see that you've contacted the TestComplete Support Team. Let me quote their reply here: Try using the adBSTR type. &nbsp; Also, try connecting to your database directly using an Oracle database OLE DB provider (OraOLEDB.Oracle or msdaora). You can find sample connection strings here: http://www.connectionstrings.com/oracle/ &nbsp; According to the below article, the VarChar2 Oracle type corresponds to the adVariant ADO type: http://www.w3schools.com/ado/ado_datatypes.asp &nbsp; However, adVariant is not supported by ADO: http://msdn.microsoft.com/en-us/library/windows/desktop/ms675318.aspx &nbsp; So, it may be possible that you will be unable to use ADO to make requests to your database. As a possible solution, you can make use of the existing .NET or Java libraries for working with the Oracle database. Information on this possibility can be found in the following help topics: Calling Functions From .NET Assemblies&nbsp; Calling Functions From Java Classes

Forum Discussion

Oracle via ADODB and ODBC

1 Reply

Recent Discussions

SessionCreator : Failed to create the process. Unspecified error

OCR Checkpoint posting a warning

How to integrate Testcomplete results with Azure Dashboards.

Related Content

ADODB connection ..... Rows Affected count?

TestComplete x64 - ODBC Driver Connectivity Issue

Oracle 12.2 testing