ADO ConnectionString for dBASE IV 
Author Message
 ADO ConnectionString for dBASE IV

Does anyone have an example of an ADO connection string for dBase IV that
uses OLE DB?  Here's an example of what I am trying, but which does not
work:

With mcnTest
    .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=\\myserver\myshare\mydata.dbf;" & _
            "Extended Properties=dBase IV;"

    .Open
End With

Thanks for your help,

Todd A. Blanchard



Sun, 13 Apr 2003 03:00:00 GMT  
 ADO ConnectionString for dBASE IV

With thanks to Carl Prothman, I've used the following:

  Set cn = New ADODB.Connection
  cn.Open "Driver={Microsoft dBASE DRIVER (*.dbf)};DriverID=277;" & _
      "Dbq=d:\vb_apps\parse_addr_num;"

 - Tom



Quote:
> Does anyone have an example of an ADO connection string for dBase IV
that
> uses OLE DB?  Here's an example of what I am trying, but which does
not
> work:

> With mcnTest
>     .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>             "Data Source=\\myserver\myshare\mydata.dbf;" & _
>             "Extended Properties=dBase IV;"

>     .Open
> End With

> Thanks for your help,

> Todd A. Blanchard




Sun, 13 Apr 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with dBase IV ODBC access via ADO

2. dBASE IV & ADO

3. Problem with dBase IV ODBC access via ADO

4. Openeing DBase IV files with ADO

5. Q:Strange-dBase IV in EXE<>dBASE IV in FRM!

6. Q:Strange-dBase IV in EXE<>dBASE IV in FRM!

7. Importing dBase IV

8. Export to dBase IV problem

9. Updating dbase IV index.

10. Import/Export to/from dBase IV looses time in DateTime field

11. Export Table as dBASE IV

12. OleDbConnection and dBase IV

 

 
Powered by phpBB® Forum Software