| Author |
|
deigsler
Newbie
Joined: 14 September 2007
Online Status: Offline
Posts: 1
|
| Posted: 14 September 2007 at 1:47pm | IP Logged
|
|
|
I am trying to use SQL Express. I have chosen the connection string option in the WebMail Admin with the following:
Data Source=(local)\SQLEXPRESS;Initial Catalog=mydatabasename;Integrated Security=SSPI
Receiving the following error:
Connect unsuccessful!
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
All other fields in the Admin I have left blank and have MS SQL Server selected.
Thanks in advance for your help!
|
| Back to Top |
|
| |
Andrew
AfterLogic Support
Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
|
| Posted: 15 September 2007 at 12:03am | IP Logged
|
|
|
Most probably, "(local)\SQLEXPRESS" is not a valid data source name. Usually, it looks like HOSTNAME\\SQLEXPRESS, i.e. if the hostname is MY_MAIN_SERVER, then the DSN will be MY_MAIN_SERVER\\SQLEXPRESS.
There are lots of variations of SQL connection strings. For instance: "Server=HOST\\SQLEXPRESS;Database=webmail;Uid=USER_NAME;Pwd= PASSWORD;"
To learn more about connection strings, please refer to www.connectionstrings.com.
Best regards,
Andrew
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: SQL Express connection
Privacy policy |
Refund policy