Re: Clipper and ADO

From: Martin Walke (martin.walke_at_spamvega.co.uk)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 09:44:11 +0100

Jhon,

It'll be the ODBC driver. Look for the ODBC Admin icon in control panel. In
win2k (and perhaps XP) it's under the administration tools icon. If not,
then check:

a) your OS disk
b) Office disk (data access drivers)
c) download from the MS site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetmicrosoft_desktop_database_drivers.asp

Once loaded, you need to set up an ODBC data source connection via the
control panel icon. Then you can use the data view wizard in VB6 to connect
to this connection (?if that makes sense). The wizard will show you what the
connection string should be - something like
DSN=dbf;DBQ=c:\jhon;DefaultDir=c:\jhon;FIL=dBase III

I'm not 100% sure how it determines which dbase file to access from the
directory specified in the connection string but the above MS link should
provide you with some pointers. If not search using dbase "odbc
connection string" . I got about 95 hits so there's plenty out there.

When you deploy, you'll need to:

a) copy the DBase drivers to the target machine
b) create the ODBC data source connection

HTH
Martin

"Jhon" <anonymous@discussions.microsoft.com> wrote in message
news:0D0C9C11-C245-47AC-AA4D-5BFE6BE6E975@microsoft.com...
> Hi Martin,
>
> How can I check if Dbase driver is loaded? If no, from or where can I load
it?
>
> What I need is:
> 1. I have Client.dbf in C:\Jhon folder
> 2. conn as ADODB.Connection
> 3. conn.ConnectionString="that's what I need....."
>
> Thank you!
>
> Jhon

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DSN-less connection for Informix database
    ... build an odbc for using the specificed driver ... ... Pervasive ODBC client Interface ... ... having to SETUP an odbc connection profile .. ... in your connection string, replace the DNS=jaco ... ...
    (microsoft.public.dotnet.languages.vb)
  • Re: DSN-less connection for Informix database
    ... Is there a way to find out the ODBC driver version on the client ... on is having to SETUP an odbc connection profile .. ... in your connection string, replace the DNS=jaco ... ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Linking a Frontpage 2000 form to an existing Access DB
    ... Using ODBC your connection string should look like this: ... "Driver={Microsoft Access Driver ... >First off please let me tell you that I am a newbie to Frontpage 2000. ...
    (microsoft.public.frontpage.programming)
  • New test release 1.16_3 of DBD::ODBC
    ... Disallow building with iODBC if it is a unicode build. ... Fix bug in out connection string handling that attempted to use an out ... but cannot describe all parameters e.g., MS SQL Server ODBC driver ...
    (perl.dbi.users)