you might want to look into linkedservers & openquery and/or DTS
in sql server, ie use sql server to get at the FoxPro data.
----- Original Message -----
From: "Bill Grover" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 27, 2000 6:48 PM
Subject: RE: Can I use 2 datasources in one app?
Thanks Stephen,
I saw the message about doing the multiple locations with access. The issue
I'm having is that we don't use Access. In my case one DSN points to a SQL
Server database and the other DSN points to a FoxPro DSN so I can't create 1
select statement to query both tables.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
