Are you trying to connect to a DBC or free table in VFP?
Which ODBC VFP driver are you using? (6.01.8629.01)
Create your ODBC DSN connection just as follows.
(Note: You may have to create a table in the database container
instead of IMail creating one for you.)
Select Database Type = VFP DBC
Enter the correct path for the database container.
Select Options, make sure Collating Sequence is Machine.
Now in IMail Administrator | <domain> | External Database
Configurations |
imail_vfp is the ODBC DSN below.
virtual001 is the table name that I created in the VFP database
container.
ODBC System Data Source Name:
imail_vfp
Table name:
virtual001
Stop and Start all of the IMail services after do the modification.
Refresh the screen (You may have to close the IMail Administrator and
re-open) Also please note don't have the DBC opened exclusively in VFP
or it will not be able to access the DBC or tables.
--
Best regards,
Joseph Mann
TLF> I think your orignial post indicated you were using Visual FoxPro.
TLF> I don't have any experience with FoxPro and Imail. (I do have some
TLF> experience with FoxPro but I do it so rarely that I always have a hard time
TLF> even making the connection string work.)
TLF> However, my system works great on Sql7.
TLF> The directions were quite accurate except that I had to make sure that I set
TLF> up my DSN string:
TLF> DSN;UID=myuid;PWD=mypwd;DB=my_imail_db
TLF> and I found it always worked best if I let IMAIL create the tables.
TLF> I switched to Mike Nice's odbc dll instead of the Imail supplied dll:
TLF> http://home.att.net/~niceman/
TLF> I suppose this should work about the same with vFP but I just have
TLF> insufficient experience with it to know the nuances.
TLF> Terry Fritts
TLF> -----Original Message-----
TLF> From: [EMAIL PROTECTED]
TLF> [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas L. Utley
TLF> Sent: Tuesday, June 27, 2000 8:45 AM
TLF> To: [EMAIL PROTECTED]
TLF> Subject: [IMail Forum] ODBC
TLF> Hard to believe that no one on this list is using an external database with
TLF> Imail :-((((
TLF> Come on people, someone has to be using ODBC on windows NT or 2000. I could
TLF> sure use some help here.
TLF> Thanks
TLF> Tom Utley
TLF> [EMAIL PROTECTED]
TLF> Please visit http://www.ipswitch.com/support/mailing-lists.html
TLF> to be removed from this list.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
