Thanks for all the advice. The settings you all offered worked like a champ. I appreciate all the help.
Respectfully, Scott D Wilson EOC (Ret) NCF Enterprise Webmaster [EMAIL PROTECTED] Comm:805.982.3601 Mobile: 805.312.1864 Fax: 805.982.2659 DSN: 551 -----Original Message----- From: Franco Celli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:41 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [IMail Forum] SQL SERVER 2000 >I'm trying to configure my Imail server to use an external SQL 2000 server, >but so far, not having any luck. >Is anybody in the list using SQL 2000 and if so, what are the settings you >use in the Imail external database configuration? >I've tried the default dll, as well as, sqlsrv32.dll provided by Microsoft. >The System DSN is correctly configured and tests successfully. These are settings I use with SQL2k & Imail 7.x, also used with SQL7 & Imail 5.x during last 2 years. External DB DLL: X:\Imaildirectory\ODBCUSER.DLL ODBC Data Source name: YourDNSname; UID=YourUserName; PWD=YourPassword (Username & Password as from SQL) Table name: Your_table_in_SQL (Each domain a different table) Franco Celli [EMAIL PROTECTED] Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
