MS Project OLE DB Provider 10.0

[Snake]

I am programming in VB.Net to import data from within a project file to an Oracle database. To do this I use the OLE DB Provider. I have a couple of problems using the ole db connection:
1) When I do a select on the project table with multiple columns I don't get the full values of the fields back.
e.g.
SELECT project FROM PROJECT gives me: MyProjectName.Published
BUT SELECT project, ProjectUniqueId FROM PROJECT gives me: MyProjectNa, 1
So only a part of the value is returned.
2) I am concatenating a string with the results I get back from a select query on the TASKS table but the concetanation is not working because there is a special character in the string, when I concatenate the string in the command window while debugging it is working correctly.

Does anyone know what is causing those problems?

Best Regards,

Lieven

 

[Rod Gill]

Hi,

Have you tried the field project Title?

The example you gave is MyProjectName.Published which suggests you are using
Project Server? If so, then connect directly to the SQL Server and read the
MSP_VIEW tables. They are read only tables that are there for reporting
purposes and are updated every time a project is published.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

I am programming in VB.Net to import data from within a project file to an

Oracle database. To do this I use the OLE DB Provider. I have a couple of
problems using the ole db connection:

1) When I do a select on the project table with multiple columns I don't

get the full values of the fields back.

e.g.
SELECT project FROM PROJECT gives me: MyProjectName.Published
BUT SELECT project, ProjectUniqueId FROM PROJECT gives me: MyProjectNa, 1
So only a part of the value is returned.
2) I am concatenating a string with the results I get back from a select

query on the TASKS table but the concetanation is not working because there
is a special character in the string, when I concatenate the string in the
command window while debugging it is working correctly.