Re: ODBC Driver for MSProject

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gérard Ducouret (gerard.ducouret_at_wanadooNOSPAM.fr)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 14:48:03 +0100

Hello Burcu,
you don't need any specific ODBC driver. you just have to create a reference
on Microsoft ActiveX Data Objects 2.1 Library :
in the VBA Editor :
Tools / Reference...

Then you'll create a connection :

Dim conData As New ADODB.Connection
FILE_NAME = "C:\Mes Documents\MS Project 2K\StockProjets\Projet B.mpp"
conData.ConnectionString = "Provider=Microsoft.Project.OLEDB.9.0;PROJECT
NAME=" & FILE_NAME
.../...

Hope this helps,

Gérard Ducouret

"burcu" <burcu.kagnici@introsolutions.com> a écrit dans le message de
news:%23HoBrYS$DHA.3828@TK2MSFTNGP10.phx.gbl...
> Hi,
> Is there an ODBC driver for Ms Project?
> Where can I find it?
> Cheers,
> Burcu
>
>

Relevant Pages

  • Re: Getting OLE Error 800A0E7F
    ... I've found a reference to ... >You should also try updating your MDAC if it's not the latest version. ... >> database connected through the OLE DB ODBC driver. ... >> retrievals are done using threads (and yes I have called CoInitialize ...
    (borland.public.delphi.database.ado)
  • Re: ODBC Driver Example Code
    ... I've looked through the MSDN site and found a number of ... discuss ODBC Driver development. ...
    (microsoft.public.data.odbc)
  • Re: VB.NET and Visual FoxPro 6.0
    ... MM> I tried adding a reference to this dll. ... AFAIK, you don't have to add a reference to the ODBC driver. ...
    (microsoft.public.fox.helpwanted)
  • Re: Access 2003-Access 2002 Incompatibility
    ... Microsoft ActiveX Data Objects Recordset 2.7 Library ... The first one corresponds to msado15.dll (and adds the ADODB reference), ... There are two ADO type libraries. ...
    (microsoft.public.access.conversion)
  • RE: ADO/VBA
    ... I have a reference to Microsoft ActiveX Data Objects 2.8 Library. ... attempting this I keep gettig errors. ... Dim cn As New ADODB.Connection ...
    (microsoft.public.excel.programming)