[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I assume I could get it running via a DSN (I resorted to that in the past) but I'd rather not because it's more difficult to maintain - I'd like my connection strings saved with the rest of my settings...
Currently my script looks like:
#VAR ADOConnection %comcreate( "ADODB.Connection" ) #CALL @ADOConnection.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=test;Password=123;Initial Catalog=RFQuery;Data Source=192.168.0.1"But I've tried other things like:
#VAR ADOConnection %comcreate( "ADODB.Connection" ) #NOOP %comset(ADOConnection,"ConnectionString","Driver={SQL Server};User ID=test;Password=123;Initial Catalog=RFQuery;Server=myserver" #CALL @ADOConnection.OpenAnd quite a few others.
Can you please provide an example for access SQL Server without a DSN? Perhaps I need to use different COM libraries, or a native TeSSH/Delphi provider?