Incomplete connection string
Having problems with connection string in Test Complete
Get the following error:
Parameter object is improperly defined. Inconsistent or incomplete information was provided
Tried the following connection strings
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=TESTDB"
'SProc.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=tcp:192.168.48.246,1433"
'SProc.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=False;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=TESTDB"
'SProc.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=False;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=tcp:192.168.48.246,1433"
'SProc.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=True;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=192.168.48.246,1433"
SProc.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=autotest_sa;Password=testing123;Initial Catalog=AUTOTEST;Data Source=192.168.48.246,1433"