Database, Connection String for Text Jet OLE DB Provider ???

Connection String for Text Jet OLE DB Provider ???

Author	Message
Steve Dalto #1 / 6	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

Scott Metzge #2 / 6	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

Scott Metzge #3 / 6	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

Scott Metzge #4 / 6	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

Scott Metzge #5 / 6	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

Steve Dalto #6 / 6	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

Page 1 of 1

[ 6 post ]