ODBC to OLEDB - VFoxPro

D

DevourU

I have been running a msaccess 2000-3 database with ODBC for several years.
It is now time to move on to OLEDB. Is there a way to subsititute an OLEDB
link for the ODBC for a one stop switch? If not can I gat help on how to
place my init string:

Provider=VFPOLEDB.1;Data Source=f:\pcmrpw;Mode=Read|Share Deny
None;Password="";Collating Sequence=MACHINE

Many thankx in advance.
-JS
 
D

Douglas J. Steele

As far as I'm aware, it's not possible to use OleDb to create a linked table
or a pass-through query.

It's only possible when creating a recordset in VBA.
 
D

DevourU

Thankx for your reply. If I were to Import data in Excel, I can select MS
Data Link (UDL file). This works fine. Is there UDL path to provide similar
results in Access? TIA

-JS
 
D

DevourU

How 'bout this: I have a new mdb database. Start a new query. Go to
properties. I have 2 choices, Source Database and Source Connect Str. How
can I use a UDL file or connect string to work with VFoxPro data? Noob
problems? :)

-JS
 
D

Douglas J. Steele

As I already said, I don't believe it's possible.

While you can programmatically set the Connect property of a TableDef (or
QueryDef) object, as far as I'm aware Access will not access OleDb
connection strings, only ODBC ones.
 
J

Jason

DevourU,

Have you been able to find a solution or a work arround for this? I'm having
the exact same problem and I'm stuck. If you cracked it, please post the
solution.

Thanks,

Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top