Sep 18, 2020 
Support Center » Knowledgebase » VisNetic MailServer » Creating An ODBC Database With Microsoft SQL For Mailing Lists In VisNetic MailServer
 Creating An ODBC Database With Microsoft SQL For Mailing Lists In VisNetic MailServer
Solution VisNetic MailServer

This article explains how to create an ODBC database with Microsofts SQL 7.0 or SQL 2000. ODBC allows you to store users/domains in database tables to easily modify/maintain large user bases. Another advantage is if you have a website powered by ASP or PHP or other, you can create/maintain users by modifying data in the ODBC tables.

To configure an ODBC database, you will first need to install Microsoft SQL (others can be used, such as Access or MySql. This article uses the Microsoft SQL server). The following article shows the steps for Microsoft SQL 7 sp3 with Windows 2000.

  1. Click Start
  2. Highlight Programs
  3. Highlight Microsoft SQL Server
  4. Click Enterprise Manager
  5. Expand Microsoft SQL Servers in the left-hand column
  6. Expand SQL Server Group
  7. Expand the server
  8. Right-click on Databases
  9. Select New Database
  10. Enter a name for the database in the Name field. (e.g.; VisNetic)
  11. Click OK
  12. Expand Security in the left-hand column
  13. Right-click Logins
  14. Select New Login
  15. Enter a username in the Name field. (e.g.; VisNeticUser) Note: Remember this username for step 37
  16. Click the SQL Server Authentication radio-button
  17. Enter a password in the Password field. (e.g.; 1234) Note: Remember this password for step 38
  18. Select the newly created database for the Database entry using the drop-down arrow. (e.g.; VisNetic)
  19. Select the Database Access tab at the top of the window
  20. Click the box next to the newly created database. (e.g.; VisNetic)
  21. Enable the following check boxes in the bottom Database roles window: Public, db_owner, db_accessadmin, db_securityadmin, db_datareader, db_datawriter
  22. Click Ok, you will be asked to confirm the password you just setup
  23. Click Start
  24. Highlight Settings
  25. Click Control Panel
  26. Double Click Administrative tools
  27. Open Data Sources (ODBC)
  28. Select the System DSN tab
  29. Click Add
  30. Select SQL Server from the bottom of the list
  31. Click Finish
  32. Enter the DSN name in the Name field. (e.g.; VisNeticODBC)
  33. In the Description field, enter a descriptive name for the database. (e.g.; ODBC source for VisNetic database)
  34. Select (Local) for the Server field with the drop-down arrow
  35. Click Next
  36. Enable the radio-button option With SQL Server authentication using a login ID and password entered by the user
  37. Enter the username from step 15 for the Login ID. (e.g.; VisNeticUser)
  38. Enter the password for the user from step 17. (e.g. 1234)
  39. Click Next
  40. Click Next again
  41. Click Finish
  42. Click Test Data Source
  43. If it completes successfully Click OK
  44. Click OK to close the SQL Server Setup window
  45. Click OK to close the ODBC Data Source Administrator
  46. From the VisNetic Mailserver configuration window select the Accounts tab
  47. Expand the Domain the list is associated with from the left-hand column
  48. Expand Mailing Lists and select the particular list
  49. From the General tab under source select Users From ODBC
  50. In the ODBC Settings button for version 8.x enter the DSN;username;password. (e.g.; VisNeticODBC;visneticuser;1234) for version 9.x select the ODBC connection from the pull down for Primary DSN and enter the username and password and set the Syntax to MS SQL and the driver to ODBC.

    Note: You must use semicolon (;) to separate the DSN, Username, and password. Use SQL query commands to identify the column and table from the database. See the SQL help for more information.
  51. Click Save
Now you can compose a message to the list and the VisNetic MailServer will use the entries from the ODBC database to generate the individual listmail messages.

Article Details
Article ID: 94
Created On: Aug 13, 2004 02:10 PM

 This answer was helpful  This answer was not helpful

 Login [Lost Password] 
Remember Me:
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | News | Downloads