khinvra
asked on
"Index not found" while Accessing DBF file in SQL Server 2000 using OpenDataSource.
Hi,
I am using following query
SELECT * FROM OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="C:\fa45\0405";Exte nded Properties=dBASE IV;')...acctmast
I am getting follwoing error.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Index not found.]
I think it is not using ISAM... but how to set that I do not know... Need help
Rahul
I am using following query
SELECT * FROM OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0',
I am getting follwoing error.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Index not found.]
I think it is not using ISAM... but how to set that I do not know... Need help
Rahul
ASKER
I do not need connection string for VB. this query i am running in SQLServer query analyzer
sorry...this looks like a problem of compatibilty between DBASE III and DBASE IV oledb provider when dealing whith indexes; I suggest you use ODBC which has much more material you can chew on to find documentation.
ASKER
What is the syntax for ODBC to be used with opendatasource for dbase files.?
take a look at this ... not specifically for dBase but ISAM looking for other links...
http://support.microsoft.com/default.aspx?scid=kb;en-us;321686
http://support.microsoft.com/default.aspx?scid=kb;en-us;321686
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer