Connection String for Text Jet OLE DB Provider ??? 
Author Message
 Connection String for Text Jet OLE DB Provider ???
Anyone know the syntax for the Connection string when I am using the Jet OLE
DB Provider to read a CSV text file?

I already have it working with the ODBC driver so already have the
schema.ini file setup, however I don't know how to specify that I am using
TEXT to the OLEDB Jet driver.

I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
accessing Jet directly.

Steve



Tue, 25 Sep 2001 03:00:00 GMT
 Connection String for Text Jet OLE DB Provider ???

This is how I found out what connection string to use for MS Access, hoepfully
it will work for you.

Put an ADODC control on a form.  Choose its properties.  Click on the connection
string radio button.  Click on build. chose your Jet driver, then chose your
databse.  When your all done you will have a connection string.  Just use
Cntrl-C to copy it and then paste it into your code.

*:> Scott

Somebody at MS really needs to get on the stick and get us some documentation.

Quote:

> Anyone know the syntax for the Connection string when I am using the Jet OLE
> DB Provider to read a CSV text file?

> I already have it working with the ODBC driver so already have the
> schema.ini file setup, however I don't know how to specify that I am using
> TEXT to the OLEDB Jet driver.

> I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
> accessing Jet directly.

> Steve



Tue, 25 Sep 2001 03:00:00 GMT
 Connection String for Text Jet OLE DB Provider ???
This is how I found out what connection string to use for MS Access, hoepfully
it will work for you.

Put an ADODC control on a form.  Choose its properties.  Click on the connection
string radio button.  Click on build. chose your Jet driver, then chose your
databse.  When your all done you will have a connection string.  Just use
Cntrl-C to copy it and then paste it into your code.

*:> Scott

Somebody at MS really needs to get on the stick and get us some documentation.

Quote:

> Anyone know the syntax for the Connection string when I am using the Jet OLE
> DB Provider to read a CSV text file?

> I already have it working with the ODBC driver so already have the
> schema.ini file setup, however I don't know how to specify that I am using
> TEXT to the OLEDB Jet driver.

> I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
> accessing Jet directly.

> Steve



Tue, 25 Sep 2001 03:00:00 GMT
 Connection String for Text Jet OLE DB Provider ???
This is how I found out what connection string to use for MS Access, hoepfully
it will work for you.

Put an ADODC control on a form.  Choose its properties.  Click on the connection
string radio button.  Click on build. chose your Jet driver, then chose your
databse.  When your all done you will have a connection string.  Just use
Cntrl-C to copy it and then paste it into your code.

*:> Scott

Somebody at MS really needs to get on the stick and get us some documentation.

Quote:

> Anyone know the syntax for the Connection string when I am using the Jet OLE
> DB Provider to read a CSV text file?

> I already have it working with the ODBC driver so already have the
> schema.ini file setup, however I don't know how to specify that I am using
> TEXT to the OLEDB Jet driver.

> I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
> accessing Jet directly.

> Steve



Tue, 25 Sep 2001 03:00:00 GMT
 Connection String for Text Jet OLE DB Provider ???
This is how I found out what connection string to use for MS Access, hoepfully
it will work for you.

Put an ADODC control on a form.  Choose its properties.  Click on the connection
string radio button.  Click on build. chose your Jet driver, then chose your
databse.  When your all done you will have a connection string.  Just use
Cntrl-C to copy it and then paste it into your code.

*:> Scott

Somebody at MS really needs to get on the stick and get us some documentation.

Quote:

> Anyone know the syntax for the Connection string when I am using the Jet OLE
> DB Provider to read a CSV text file?

> I already have it working with the ODBC driver so already have the
> schema.ini file setup, however I don't know how to specify that I am using
> TEXT to the OLEDB Jet driver.

> I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
> accessing Jet directly.

> Steve



Tue, 25 Sep 2001 03:00:00 GMT
 Connection String for Text Jet OLE DB Provider ???
Scott,

Tried this, but there is no option to use Jet for text files. I suspect that
the current Jet OLE-DB driver does not support text files yet. Anyone know
if version 4 does???

Many thanks anyway,

Steve

Quote:

>This is how I found out what connection string to use for MS Access,
hoepfully
>it will work for you.

>Put an ADODC control on a form.  Choose its properties.  Click on the
connection
>string radio button.  Click on build. chose your Jet driver, then chose
your
>databse.  When your all done you will have a connection string.  Just use
>Cntrl-C to copy it and then paste it into your code.

>*:> Scott

>Somebody at MS really needs to get on the stick and get us some
documentation.



Fri, 28 Sep 2001 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Connection String for Text Jet OLE DB Provider ???

2. connection strings for the OLE DB Jet

3. Create Jet 3.5x DB with OLE DB Provider 4.0

4. Create Jet 3.5x DB with OLE DB Provider 4.0

5. Use of the Microsoft OLE DB provider for Jet with SQL Server 7

6. Use of the OLE DB provider for Jet with SQL Server 7

7. Problem with Jet OLE DB Provider 4.0

8. Distributed Transaction and OLE DB JET provider

9. OLE DB Provider for Microsoft Jet

10. How to get OLE DB Provider for Microsoft Jet

11. Use OLE DB provider fo Jet with SQL Server 7

12. OLE DB Provider for Jet 3.5x


 
Powered by phpBB® Forum Software