Hi

I have a need to modify a custom field in Project 2007 from exisitng data in
an SQL Database.

I understand that the Project 2007 Modle is to use Project Server and
customise from there, but it seems a bit of overkill for this particular
project (and I've had trouble in setting-up a Project 2007 Test Server
anyway!).

Is there any way I can get an ODBC/OLE_DB connection to the Project file ?

Simon

Firstly the 2003 oledb driver is read only (2007 does not support oledb)

You can update the database directly, but this is not supported in 2007.

Best version independent way to update a custom field is via automation.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


"simon p" <simon.parr@nospam.appsense.com> wrote in message
news:%23bjJw4IvHHA.4916@TK2MSFTNGP04.phx.gbl...
> Hi
>
> I have a need to modify a custom field in Project 2007 from exisitng data
> in an SQL Database.
>
> I understand that the Project 2007 Modle is to use Project Server and
> customise from there, but it seems a bit of overkill for this particular
> project (and I've had trouble in setting-up a Project 2007 Test Server
> anyway!).
>
> Is there any way I can get an ODBC/OLE_DB connection to the Project file ?
>
> Simon
>
>

Thanks for the prompt resposne Rob.

When you say automation, do you mean via Macro's/VBA within project looking
outside to SQL ?

Si



"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
news:%23UrSvRJvHHA.2088@TK2MSFTNGP06.phx.gbl...
> Firstly the 2003 oledb driver is read only (2007 does not support oledb)
>
> You can update the database directly, but this is not supported in 2007.
>
> Best version independent way to update a custom field is via automation.
>
> --
>
> Rod Gill
> Project MVP
>
> Project VBA Book, for details visit:
> http://www.projectvbabook.com
>
> NEW!! Web based VBA training course delivered by me. For details visit:
> http://projectservertraining.com/learning/index.aspx
>
>
> ----------------------------------------------------------------------------------------------------
>
>
> "simon p" <simon.parr@nospam.appsense.com> wrote in message
> news:%23bjJw4IvHHA.4916@TK2MSFTNGP04.phx.gbl...
>> Hi
>>
>> I have a need to modify a custom field in Project 2007 from exisitng data
>> in an SQL Database.
>>
>> I understand that the Project 2007 Modle is to use Project Server and
>> customise from there, but it seems a bit of overkill for this particular
>> project (and I've had trouble in setting-up a Project 2007 Test Server
>> anyway!).
>>
>> Is there any way I can get an ODBC/OLE_DB connection to the Project file
>> ?
>>
>> Simon
>>
>>
>
>

No,

Yes. Have Project open, then in Project VBA, or any other language read the
data from SQL Server and store the results in required fields.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


"simon p" <simon.parr@nospam.appsense.com> wrote in message
news:%23g1HPYJvHHA.1184@TK2MSFTNGP04.phx.gbl...
> Thanks for the prompt resposne Rob.
>
> When you say automation, do you mean via Macro's/VBA within project
> looking outside to SQL ?
>
> Si
>
>
>
> "Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
> news:%23UrSvRJvHHA.2088@TK2MSFTNGP06.phx.gbl...
>> Firstly the 2003 oledb driver is read only (2007 does not support oledb)
>>
>> You can update the database directly, but this is not supported in 2007.
>>
>> Best version independent way to update a custom field is via automation.
>>
>> --
>>
>> Rod Gill
>> Project MVP
>>
>> Project VBA Book, for details visit:
>> http://www.projectvbabook.com
>>
>> NEW!! Web based VBA training course delivered by me. For details visit:
>> http://projectservertraining.com/learning/index.aspx
>>
>>
>> ----------------------------------------------------------------------------------------------------
>>
>>
>> "simon p" <simon.parr@nospam.appsense.com> wrote in message
>> news:%23bjJw4IvHHA.4916@TK2MSFTNGP04.phx.gbl...
>>> Hi
>>>
>>> I have a need to modify a custom field in Project 2007 from exisitng
>>> data in an SQL Database.
>>>
>>> I understand that the Project 2007 Modle is to use Project Server and
>>> customise from there, but it seems a bit of overkill for this particular
>>> project (and I've had trouble in setting-up a Project 2007 Test Server
>>> anyway!).
>>>
>>> Is there any way I can get an ODBC/OLE_DB connection to the Project file
>>> ?
>>>
>>> Simon
>>>
>>>
>>
>>
>
>