>> Creating ODBC DSN
Creating ODBC System DSN for Ban Man Pro SQL  Database.
  1. In Control Panel, under 32 ODBC Data Sources, Click ADD…

  2.  Select SQL Server Driver …

  3. Click Finish…

  4. Type Name = “banmanproSQL”

  5. Type Description=”SQL Database for BanManPro”

  6. Select the appropriate server.

  7. Select "With SQL Server authentication using a login ID and password entered by user".  Type “banmanproADMIN” as Login ID.  Type appropriate password.

  8. Click on Client Configuration.   Enter Server alias if other than local machine.  Select network library, if required to connect to another server.

  9. Select Change the default database to “banmanproSQL”

  10. Click Finish.

  11. Test Data Source.

  12. If connection works, you should see the following window.

 

Copyright 1999-2007 AdComplete.com, LLC     |    Privacy Policy