Yes, the DSN was created with SQL Server authentication, using the username and password described below. Another thing that I didn't mention, though I don't think it would have any bearing on the issue, is that the DSN Client Configuration is set up to use Named Pipes rather than TCP/IP, but the IMAIL system (at least for this test) is on the same system as the SQL Server.
Robert A. Jones II Senior Web Engineer (760) 727-5100 x132 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron Hornbaker Sent: Monday, February 04, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: RE: [imail] External Database Robert, Did you create a system DSN with SQL Server authentication (not Windows NT authentication)? That seems to be the only necessary thing you didn't mention. More info here: http://support.answertrack.com/Default.asp?kb=799 Ron > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > Robert Jones > Sent: Monday, February 04, 2002 12:59 PM > To: [EMAIL PROTECTED] > Subject: [imail] External Database > > > We're working (on a test system) to set up an external database > using SQL 7. > Here's the setup: > > Datasource: IMAILSECDB > dB Name: IMAILSECDB > Table Name: IMAILSECDB > Username: imail > Password: password > > The configuration in IMail is as follows: > External Database Implementation DLL: > d:\IMail\odbcuser.dll > > ODBC System Data Source Name: > IMAILSECDB; UID=imail; PWD=password (as instructed by the manual) > > Table Name: > IMAILSECDB > > The problem is that whenever I try to add a user, the program adds the > username to the list, but I cannot log in using that username > nor does it > show up in the database. If I do a refresh, the user > disappears. Also, if > I add a user to the database manually and restart the IMAIL > Administrator it > does not show up and I cannot log in under any of these circumstances. > > Any ideas on why this doesn't work? Let me know if you need further > information to diagnose. > > Robert A. Jones II > Senior Web Engineer > (760) 727-5100 x132 ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive... http://www.tallylist.com/archives/index.cfm/mlist.4 To Manage your Subscription......... http://humankindsystems.com/lists ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive... http://www.tallylist.com/archives/index.cfm/mlist.4 To Manage your Subscription......... http://humankindsystems.com/lists
