Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-29 : 09:08:54
|
| Ed writes "I created a linked server in MS SQL 7.0 that uses a visual foxpro driver to connect to a legacy xbase database.The problem is that SQL Server can't find the schema or any index files. There are tens of thousands of records in some tables so we need to use indexes if possible. Indexes (.cdx files) are already created and are present in the database directory along with all the .dbf files.Unfortunately, SQL Server (or the Foxpro driver) is looking for an .INF file that doesn't exist. We've searched countless websites and books looking for an example that shows how to create this file but found none. From what little information we did find we came up with this:1. Create an .INF file for each table where we want to use an index (e.g. create CUSTOMER.INF for the CUSTOMER.DBF file)2. List the index files in the .INF file.3. Place the new CUSTOMER.INF file in the same directory.EXAMPLE for CUSTOMER.INF:-------------------------- [dbase 5.0] CDX1=CUSTOMER.cdx CDX2=CUSTLOOK.cdx CDX3=CUSTCMID.cdx CDX4=CUSTZIP.cdx CDX5=CUSTCONT.cdx--------------------------Are we on the right track? Do you have any insight for us? Is there an easier way? Any sample code?Any help you can give would be greatly appreciated.vr,Ed CavanaughVentura, Inc." |
|
|
|
|
|
How to create an dbase index file for use with a SQL linked server