>All our database is either in SQL 7. or Access. And we use Cold Fusion to connect to the database and develop forms or web pages.
>Now We have some FP5.0 tabels and I need to develop forms with the data in those tables. I was told that I should convert(retrieve) FP tables to(from) SQL Server7 because it's more secure and the original data won't get messed up. I tried "linked server" but it came up with some errors when I created it.
>
>Please give me some ideas. Thanks.
First, the VFP ODBC driver (which is what is being used to "link" the servers) doesn't supporting linking. It does support the use of T-SQL function OPENROWSET(). You need to specify the OLE DB provider for ODBC (MSDASQL) and then the VFP connection string.
Ex.
select vfp.* from
openrowset('MSDASQL',
'Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=D:\Dev\VFPTest\mytest.dbc;Exclusive=No;Deleted=No;BackgroundFetch=No',
'select * from test') as vfp
Secondly, why do you want to go through these hoops? Just as easily as you connect to SQL Server and Access, you can connect to VFP tables. And, IMO, the chance of messing something up in VFP is just as likely as it is to mess something up in Access, remote.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao