Go into the ODBC Manager. Turn on SQL trace and find out where it's
failing.
Are you using Named Pipes or TCP/IP in the network configuration?
--
Joe M.
Tuesday, January 23, 2001, 8:30:04 AM, you wrote:
CG> Try this:
CG> DSN;UID=databaseusername;PWD=databasepassword;DB=DBname
CG> Tablename:
CG> domain_com
CG> -----Original Message-----
CG> From: [EMAIL PROTECTED]
CG> [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Sinclair
CG> Sent: Monday, January 22, 2001 6:51 PM
CG> To: [EMAIL PROTECTED]
CG> Subject: [IMail Forum] ODBCUSER.dll problem with SQL 7.0
CG> I'm trying to set up a domain using an external database in SQL 7.0. I've
CG> gone through the Knowledge Base and pulled all the articles on the problems
CG> people have had. Still can't get it working. I've set up the datasource and
CG> configured iMail to use it with syntax as:
CG> imail;UID=paul;PWD=password
CG> As per many notes on this list and on the support site, I also tried this
CG> same syntax but with db name added:
CG> imail;UID=paul;PWD=password;DB=imaildb
CG> I've also downloaded Mike Nice's fixodbc.zip file, which includes his
CG> ODBCUSER.dll file dated 5/22/2000. Installed this in place of the existing
CG> odbcuser.dll file.
CG> Despite all this, I still get an error when trying to create a user in the
CG> domain. The error is something like "Cannot create user. Check external
CG> database settings."
CG> When I create an Access2000 database and set this up as the datasource and
CG> point iMail to it, that works fine. But I will need a SQL database for the
CG> domain in question.
CG> The iMail server (v 6.05) is on NT4.0, SP6a. I've seen references to going
CG> back to the odbcuser.dll file that was in v6.04 of iMail and have tried
CG> that, but that doesn't take care of it either.
CG> Anybody have any other thoughts on what I can look at? Thanks for your help.
CG> Paul Sinclair
CG> Please visit http://www.ipswitch.com/support/mailing-lists.html
CG> to be removed from this list.
CG> An Archive of this list is available at:
CG> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
CG> Please visit http://www.ipswitch.com/support/mailing-lists.html
CG> to be removed from this list.
CG> An Archive of this list is available at:
CG> 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/
