Bingo! With the addition of changing the table name from [default] to the
mailserver's name (replacing . with _) I am now eating pizza in your honor.
Thanks!
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 14, 2000 7:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] Idiot's Guide To ODBC Database?
> I have niceman's replacement DLL, have SQL Server 7 functioning properly,
> but trying what I find in the IPSwitch KB, I still can't get IMail to use
> an SQL database for users.
> When I setup the DSN then tell IMail to use it then try to expand
> the users
> tree nothing is ever returned.
> I test the DSN from the ODBC setup and the connection is
> established, it all
> actually works well with an Access database. But I need the performance of
> SQL 7 so I am turning to those who have it working for help. Any
> ideas will
> be tried, successful ideas will have a slice of pizza eaten in
> their honor.
In the IMail external database configuration panel, in your ODBC System Data
Source Name field, have you tried something like:
myDSN;uid=mySQL7username;pwd=mySQL7password
... and then make sure your SQL7 database and ODBC is set up to use SQL7's
security, not NT security?
I don't use SQL7 with IMail, but I do use SQL7 with ColdFusion and ASP, and
you always have to pass a username and password to connect correctly with
those languages.
hope this helps,
Ron
ron allen hornbaker humankind systems, inc. mailto:[EMAIL PROTECTED]
HKSI WebMail Templates for IMail v6x ~ Now 441 Installations Worldwide
Demo: http://mail.hksi.net Buy: http://humankindsystems.com/products
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
