OK. I don't profess to be the best C++ programmer in the world but if your
feeling lucky here is the source code. The way I've structured this to work
is to use 1 SQL database named Imail and then every host becomes a table in
that database. The only information I look at from the External Database
setup is the hostname since with ADO you do not need DSN's. I've only done
minimal testing with this and I'm running ADO v2.1. All of the information
required to create the ADO connection is hard coded in the PooledConnection
Class and initialized when the class is created. You will need to at the
very least change the following values in the constructor for the
PooledConnection Class.
m_bstrConnect = "Provider=SQLOLEDB; Data Source=Your.DBSystem.com; Initial
Catalog=YourDataBase; User Id=YourUID; Password=YourPWD";
m_bstrUserID = "YourUID";
m_bstrPassword = "YourPWD";
I would appreciate hearing about any bugs or improvements you make to the
code.
Thank you,
Jeff Madison
Chief Technology Officer
SISNA, Inc
(801)924-0900 x 101
http://www.sisna.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Dan Nguyen
Sent: Tuesday, July 06, 1999 4:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Installation problem - Adding new users to
SQLserver
Jeff, can you pls send me the copy also if you don't mind. I was having the
same problem and I quitted using SQL.
thanks in advance,
Dan
-----Original Message-----
From: Jeff Madison <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, July 06, 1999 3:36 PM
Subject: RE: [IMail Forum] Installation problem - Adding new users to
SQLserver
>The DLL that comes with Imail only works with Access. I read that they
made
>chages so it would work with SQL server but it only crashed with me too. I
>wrote my own DLL that uses ADO to SQL server. If you know C++ and are
>interested I can send you the source code.
>
>Thank you,
>
>Jeff Madison
>Chief Technology Officer
>SISNA, Inc
>(801)924-0900 x 101
>http://www.sisna.com
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]] On Behalf Of ajay gullapalli
>Sent: Tuesday, July 06, 1999 4:25 PM
>To: [EMAIL PROTECTED]
>Subject: [IMail Forum] Installation problem - Adding new users to SQLserver
>
>I just installed the trail version of Imail 5.0. I selected the
>external database option while installing and made sure there is a
>system DSN called "IMAILSECDB" created prior to selecting this option,
>which is a SQLServer 6.5 database. The product installs fine, but when
>I try to create a new user, it causes an Application Error and crashes.
>
>Am I doing something wrong? I hope someone can answer this question.
>
>Thank you.
>Ajay Gullapalli
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>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.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
ADOuser.zip
