Aug 05, 2020 
Support Center » Knowledgebase » [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Solution This article applies to VisNetic MailServer or IceWarp Mail Server

Scenario:

I have been trying to get the GroupWare/Calendering service set up but I can't seem to get past a ODBC error that keeps coming up. When I try to test the connection under ODBC settings for GroupWare I get a error saying "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.".

Solution:

Current versions of VisNetic MailServer and IceWarp Mail Server can use ODBC or direct database driver access for the following databases.

ODBC (32bit)
MS Access
MS SQL
My SQL
Firebird
SQLite

If the ODBC connection in Groupware's Primary DSN is not selected or the improper syntax and/or driver is selected you may receive this error. The default settings for the current versions of VisNetic MailServer and IceWarp Mail Server are SQLite. When using SQLite the default database is located in [install-dir]\calendar\groupware.db. The entire installation path to the database is not required when using SQLite, example,

Primary DSN: calendar\groupware.db
Username: [blank]
Password: [blank]
Server: [blank]

Syntax: SQLite
Driver: SQLite

[blank] = fields are do not contain entries

If you are using an older version of VisNetic MailServer 8.5 or lower you may be required to use ODBC. The default settings use MS Access database, example,

Primary DSN: VisNeticGroupware
Username: [blank]
Password: [blank]
Server: [blank]

Syntax: MS Access
Driver: ODBC

[blank] = fields are do not contain entries

The primary DSN is configured in Windows ODBC connection settings as a System DSN. The System DSN connection name by default is VisNeticGroupware. This System DSN may or may not already be created since you are receiving an ODBC driver error. The System DSN should be pointing to the default MS access database file [install-dir]\calendar\calendar.mdb.

Note: If you change the DSN settings or create a new database for use with Groupware you will need to test the connection then create the tables (DB Settings button). If you are using or switching to a database that is already used by Groupware you may need to first delete the tables. Deleting the tables will remove all data from the configured database. ALWAYS backup your database files before deleting tables.

How to create a System DSN:

Review the following Microsoft Knowledge base article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;208304


Article Details
Article ID: 301
Created On: Sep 09, 2004 01:33 PM

 This answer was helpful  This answer was not helpful

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