Contributions
Test Complete 8.7 Connection String not working Windows 7 64bit
I need assistance with getting a connection string to work under Windows 7 64bit connecting to an Oracle 11g database. The following code used to work under Windows XP: // Create a query Qry = ADO.CreateADOQuery() // Specify the connection string Qry.ConnectionString = "Provider=MSDAORA;Data Source=" Qry.ConnectionString += Project.Variables.VariableByName('gsDBName') + ";" Qry.ConnectionString += "User ID=" + Project.Variables.VariableByName('gsDBUsername') + "; " Qry.ConnectionString += "Password=" + Project.Variables.VariableByName('gsDBPassword') + ";" // Specify the SQL expression Qry.SQL = "SELECT MAX(DEALING_NUMBER) AS DEALING_NUMBER " Qry.SQL += "FROM SMR.DEALING " Qry.SQL += "WHERE ((DEALING_PREFIX = '" + sPrefix + "') " Qry.SQL += "AND ((DEALING_NUMBER >= " + strMin + ") " Qry.SQL += "AND (DEALING_NUMBER <= " + strMax + "))) " // Execute the query Qry.Open() This is the error when executing line Qry.Open() An exception occurred in the "Script Name" unit at line xxx: Unspecified Error I have tried countless Connection string combinations which all give this same error. Please help. Gerard1.5KViews0likes2Comments