I just got it to work...
I had to put this line in the Imail Data Source box
< Database Name + UID= + PWD= > It needs to know what user name to use when
access the SQL Server.
webmail004;UID=test;PWD=test
And it works now..
----- Original Message -----
From: Dan Nguyen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 23, 1999 11:00 AM
Subject: Re: [IMail Forum] SQL 7 & DSN
> Brian,
>
> I have tried to user Imail 5.04 with SQL 7, but it gave me a lot of weird
> problems. I've also encountered your problem and therefore I've quitted
> using SQL 7.
>
> I hope someone else can help you and me to figure out the bug.
>
>
> ***************************************
> Dan Nguyen from Hotbiz.com,
> Your Online Office.
> ***************************************
> -----Original Message-----
> From: Brian Gallucci <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Wednesday, June 23, 1999 9:38 AM
> Subject: [IMail Forum] SQL 7 & DSN
>
>
> >Hi can someone help me out here I seem to be lost. I'm running IMail 5.04
> >and having it talk to a SQL 7 server. What's happen is when we add a user
> we
> >can see them inside the Database on the SQL server and they try to login
> via
> >the Web and they can't. SAYING LOGIN FAILED.
> >
> >Did I miss a step on the Auth ?
> >
> >I checked the acct and it has Web Access enabled. And the Flag in the
> >Database is 128.
> >
> >Now about the DSN setup. The only way I could get this thing to talk with
> >the SQL server was to set NT Auth instead SQL Auth inside the DSN. Could
> >this be the problem ? I have seen some people talking about putting a
user
> >name and pass in the DSN
> >
> ><i.e> datasetname;UID=^^;PWD=^^^
> >
> >Well I can't figure out where it goes.
> >
> >Thanks
> >-Brian
> >
> >
> >
>
>
