Microsoft Project OLE DB Provider 10.0

S

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
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
 

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

Similar Threads

MS Project Center-Autolink column fields 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
MS Project OLE DB Provider 10.0 1
Project 2002 OLE DB Provider - Unique Task IDs for Sub Projects 1
Project 2010 "Project has stopped working" error when attempting to import from Excel 0
OLE DB Provider access to SQL DB 0
OLEDB Provider 5
Trouble with the ACE provider 0

Top