MS SQL Connectivity ?

[Dave Herndon]

Anyone know of a way to open a database connection with a MS SQL server database from within revolution ?  The same string that works for SQlight which includes the username, password, etc doesn't work for MS SQL Server.  I have however obtained success by entering my username and password in the ODBC settings in the Windows administrative tools control pannel.  Then the connection string works.  But I would rather not have to mess with this on every client computer.
  Any answers ?
  Dave