FileSaveAs - ORA 03114

[Djemel Guizani]

Hello,

Context of the issue:
- VBA scripts runing in Microsoft Project Pro 2003
- Oracle Database 9.2 with MSP tables
- Oracle ODBC driver to connect to database.

We use the FileOpen API with MsProject.odbc flag to open project from the
Oracle database.
The users can work and the save their modification using FileSave or
FileSaveAs.
This is working using ODBC defined connection.

If a disconnection occurs while users work on project (example users using
laptops going to a meeting room) then when they come back to dockstation
(reconnecting to the network) to save, FileSave/FileSaveAs API return an
(uncatchable exception) "[Oracle][odbc][Ora]Ora-03114 Not connected to
Oracle". It seems that this API did not recreate the ODBC connection if
lost.

I try manualy to simulate that with ADODB.Connection and ADODB.Recordset and
it works. When connection is lost you recreate the connnection to retrieve
or save data in the database (SELECT or INSERT)

I've try with SP1 and SP2 of Ms Project 2003.
I've try with Microsoft ODBC for Oracle
I've try with Oracle ODBC drivers uptodate version

Still unable to save the project back to the database

Do you know any fix or workaround for that issue.

Thank you

Djemel

 

[Rod Gill]

Can you save as to a local.mpp file then re-save back to Oracle after
closing and opening Project again?

 

[Djemel Guizani]

Yes this would probably be the last solution.
But isn't there a way to get this FileSaveAs code sources or get a Microsoft
fix that recreate the connection in this API

Can you save as to a local.mpp file then re-save back to Oracle after
closing and opening Project again?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hello,

Context of the issue:
- VBA scripts runing in Microsoft Project Pro 2003
- Oracle Database 9.2 with MSP tables
- Oracle ODBC driver to connect to database.

We use the FileOpen API with MsProject.odbc flag to open project from the
Oracle database.
The users can work and the save their modification using FileSave or
FileSaveAs.
This is working using ODBC defined connection.

If a disconnection occurs while users work on project (example users
using laptops going to a meeting room) then when they come back to
dockstation (reconnecting to the network) to save, FileSave/FileSaveAs
API return an (uncatchable exception) "[Oracle][odbc][Ora]Ora-03114 Not
connected to Oracle". It seems that this API did not recreate the ODBC
connection if lost.

I try manualy to simulate that with ADODB.Connection and ADODB.Recordset
and it works. When connection is lost you recreate the connnection to
retrieve or save data in the database (SELECT or INSERT)

I've try with SP1 and SP2 of Ms Project 2003.
I've try with Microsoft ODBC for Oracle
I've try with Oracle ODBC drivers uptodate version

Still unable to save the project back to the database

Do you know any fix or workaround for that issue.

Thank you

Djemel

 

[Rod Gill]

I doubt very much they will release the .mpp structure, trying to support
files that are corrupted by add-ons causing problems would be a nightmare.

Part of your solution has to be training. The other part is to experiment to
see where the problem is and look for replacements. I've haven't seen people
with connection problems to other ODBC data sources (no posts to this ng in
many years that I remember) so have you tried different oracle drivers?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Yes this would probably be the last solution.
But isn't there a way to get this FileSaveAs code sources or get a
Microsoft fix that recreate the connection in this API

Can you save as to a local.mpp file then re-save back to Oracle after
closing and opening Project again?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hello,

Context of the issue:
- VBA scripts runing in Microsoft Project Pro 2003
- Oracle Database 9.2 with MSP tables
- Oracle ODBC driver to connect to database.

We use the FileOpen API with MsProject.odbc flag to open project from
the Oracle database.
The users can work and the save their modification using FileSave or
FileSaveAs.
This is working using ODBC defined connection.

If a disconnection occurs while users work on project (example users
using laptops going to a meeting room) then when they come back to
dockstation (reconnecting to the network) to save, FileSave/FileSaveAs
API return an (uncatchable exception) "[Oracle][odbc][Ora]Ora-03114 Not
connected to Oracle". It seems that this API did not recreate the ODBC
connection if lost.

I try manualy to simulate that with ADODB.Connection and ADODB.Recordset
and it works. When connection is lost you recreate the connnection to
retrieve or save data in the database (SELECT or INSERT)

I've try with SP1 and SP2 of Ms Project 2003.
I've try with Microsoft ODBC for Oracle
I've try with Oracle ODBC drivers uptodate version

Still unable to save the project back to the database

Do you know any fix or workaround for that issue.

Thank you

Djemel

 

[Djemel Guizani]

I've try with Microsoft for Oracle ODBC driver, Oracle ODBC drivers every
release I've found, Project Pro 2003 SP1, SP2 ...
I've try also disabling ODBC pooling but nothing works.

The problem is clear. Using ODBC connection to oracle with VBA in Project
Pro 2003. The FileSaveAs method from the API dit not test or try to recreate
the connection if lost and only send Oracle exception

I doubt very much they will release the .mpp structure, trying to support
files that are corrupted by add-ons causing problems would be a nightmare.

Part of your solution has to be training. The other part is to experiment
to see where the problem is and look for replacements. I've haven't seen
people with connection problems to other ODBC data sources (no posts to
this ng in many years that I remember) so have you tried different oracle
drivers?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Yes this would probably be the last solution.
But isn't there a way to get this FileSaveAs code sources or get a
Microsoft fix that recreate the connection in this API

Can you save as to a local.mpp file then re-save back to Oracle after
closing and opening Project again?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Hello,

Context of the issue:
- VBA scripts runing in Microsoft Project Pro 2003
- Oracle Database 9.2 with MSP tables
- Oracle ODBC driver to connect to database.

We use the FileOpen API with MsProject.odbc flag to open project from
the Oracle database.
The users can work and the save their modification using FileSave or
FileSaveAs.
This is working using ODBC defined connection.

If a disconnection occurs while users work on project (example users
using laptops going to a meeting room) then when they come back to
dockstation (reconnecting to the network) to save, FileSave/FileSaveAs
API return an (uncatchable exception) "[Oracle][odbc][Ora]Ora-03114 Not
connected to Oracle". It seems that this API did not recreate the ODBC
connection if lost.

I try manualy to simulate that with ADODB.Connection and
ADODB.Recordset and it works. When connection is lost you recreate the
connnection to retrieve or save data in the database (SELECT or INSERT)

I've try with SP1 and SP2 of Ms Project 2003.
I've try with Microsoft ODBC for Oracle
I've try with Oracle ODBC drivers uptodate version

Still unable to save the project back to the database

Do you know any fix or workaround for that issue.

Thank you

Djemel

 

[Rod Gill]

It still sounds like an Oracle ODBC driver problem unless you can duplicate
the problem with an ODBC connection to an Access database or another ODBC
source.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

I've try with Microsoft for Oracle ODBC driver, Oracle ODBC drivers every
release I've found, Project Pro 2003 SP1, SP2 ...
I've try also disabling ODBC pooling but nothing works.

The problem is clear. Using ODBC connection to oracle with VBA in Project
Pro 2003. The FileSaveAs method from the API dit not test or try to
recreate the connection if lost and only send Oracle exception

I doubt very much they will release the .mpp structure, trying to support
files that are corrupted by add-ons causing problems would be a nightmare.

Part of your solution has to be training. The other part is to experiment
to see where the problem is and look for replacements. I've haven't seen
people with connection problems to other ODBC data sources (no posts to
this ng in many years that I remember) so have you tried different oracle
drivers?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Yes this would probably be the last solution.
But isn't there a way to get this FileSaveAs code sources or get a
Microsoft fix that recreate the connection in this API

"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
Can you save as to a local.mpp file then re-save back to Oracle after
closing and opening Project again?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Hello,

Context of the issue:
- VBA scripts runing in Microsoft Project Pro 2003
- Oracle Database 9.2 with MSP tables
- Oracle ODBC driver to connect to database.

We use the FileOpen API with MsProject.odbc flag to open project from
the Oracle database.
The users can work and the save their modification using FileSave or
FileSaveAs.
This is working using ODBC defined connection.

If a disconnection occurs while users work on project (example users
using laptops going to a meeting room) then when they come back to
dockstation (reconnecting to the network) to save, FileSave/FileSaveAs
API return an (uncatchable exception) "[Oracle][odbc][Ora]Ora-03114
Not connected to Oracle". It seems that this API did not recreate the
ODBC connection if lost.

I try manualy to simulate that with ADODB.Connection and
ADODB.Recordset and it works. When connection is lost you recreate the
connnection to retrieve or save data in the database (SELECT or
INSERT)

I've try with SP1 and SP2 of Ms Project 2003.
I've try with Microsoft ODBC for Oracle
I've try with Oracle ODBC drivers uptodate version

Still unable to save the project back to the database

Do you know any fix or workaround for that issue.

Thank you

Djemel