Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Error On Primavera SDk.....

4 replies [Last post]
Mon, 2009-09-07 01:30
Izam Zakaria
User offline. Last seen 8 years 23 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Row 0: RDA error: Resource not available - Connect error: da=PMSDK;Driver=PMSDK;engine=PM;lf=C:\temp\PMSDK.LOG;lo=terse;pg=1;pp=pubuser;pu=pubuser;.

Error returned from engine: VDB.Connect; hResult=0x80040003 (PMSDK_E_INTERNALERR: internal driver error); EOleSysError=Invalid return value from CreateAppVDB

Error number: 0x80040003

Is it anyone can tell me why the error sheet come out this result?
Top

Replies

Tue, 2011-10-18 03:29
#1
Farzin Farsi
User offline. Last seen 4 years 27 weeks ago. Offline
Joined: 3 Nov 2008
Posts: 20
Groups: Civil Engineering

Hi Gun,

I have the similar problem connectind excel SDK to ODBC under Win7, have you ever been able to resolve it yet?

Thanks in advance

cheers

Farzin

Top
Sat, 2010-11-27 15:16
#2
Gün Göksu
User offline. Last seen 2 years 44 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS

Hi,

I get the same error.

my machine is a win7 64bit with excel 32 bit.

the xls files do not work. I get the error above.

The same happens if I try to connect through the microsoft scrypt editor.

So I believe the error lies somewhere between the odbc and oracle.

P6 v7.0 works normally.

my backend db is oraclexe. database name is XE. username is pubprm$pm and passwd is oracle.

I can see the dsn for the PMSDK is setup just fine through C:\Windows\SysWOW64\odbcad32.exe.

a test setup under a 32 bit VM works just fine.

 

Any ideas on how to correct this? 

Top
Sat, 2010-11-27 15:16
#3
Gün Göksu
User offline. Last seen 2 years 44 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS

sorry, double post.

Top
Mon, 2009-09-07 02:37
#4
Arnold Puy
User offline. Last seen 10 years 14 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Izam,

Try to reconfigure the database alias for the SDK.

1. In the control panel, choose Data Sources (ODBC).
2. On the system DSN tab, highlight PrimaveraSDK and click configure.
3. Click the "Create Database Alias" button.
4. Choose yes to create the database alias PMSDK.
5. Choose the appropriate driver type for your database:
5.1 Microsoft SQL Server/SQL Express
5.2 Host Name: Machine Name\primavera
5.3 Database Name: pmdb$primavera
Then next and next..
6. Click finish to complete the configuration.

Please refer also to Solution ID: prim7227
(Error: "Resource not available - Connect error" when using the SDK).

I hope this helps

Regards,

Arnold
Top