SQL: Microsoft SQL DetailsSQL: Microsoft SQL DetailsOmniRush uses ADO to connect to SQL Server. Make sure ADO is installed on the OmniRush PC, and test that it can connect to your SQL server using Query Analyzer.
MDAC versions 2.5 - 2.7 and higher are supported with all versions of OmniRush.
The OmniRush Database Connector will walk you through a connection string wizard, so once the connection parameters are at hand, getting connected is simple.
Connection string tips:
a) Do not route to an ODBC provider. Select the "Microsoft OLE DB Provider for SQL Server"
b) Here is an example connection string:
Provider=SQLOLEDB.1;Password="";Persist Security Info=True;User ID=sa;Initial Catalog=omnirush;Data Source=localhost
