Joe,
Thanks for the suggestion. I'm using TCP/IP in the network configuration.
I'll turn on trace for error messages, run through it again, and see if that
sheds some light on the trouble.
Paul Sinclair
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph Mann
> Sent: Tuesday, January 23, 2001 9:03 AM
> To: [EMAIL PROTECTED]
> Subject: [IMail Forum] ODBCUSER.dll problem with SQL 7.0
>
>
> 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/
>
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/
