accessing ORACLE

gvolta

does anybody has experience on accessing oracle from Navision?
I am using NF 2.5 with SQLServer and I can read oracle tables (linked tables) but i get an error when i try to write.
somebody told me that it is an ODBC problem but i didn't find any troubleshooting in the MS site until now.
thanks for any help

---

________________
Giuseppe Volta
EID S.r.l.

John_Tegelaar

When running on SQL Server, you should be able to access both Oracle and Navision with SQL queries. Have no experience with transfer to Oracle, but from Oracle to Navision runs fine.

Do you get errors when writing to Navision? What errors?

John

gvolta

Thank you John,

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>...
Do you get errors when writing to Navision? What errors?
<HR></BLOCKQUOTE>

Oracle Tables are 'linked' and defined as views in SQLServer.
It works fine when I read, if I try to write I get this error:

(translated from Italian) SQL Server Error accessing table DEPT

7392,"42000" [MIcrosoft][ODBC SQL Server Driver][SQL Server] Could not start a transaction for OLE DB provider 'MSDAORA'.

Navision is 2.5, SQL Server 7.0, Oracle 8.0.5

---

________________
Giuseppe Volta
EID S.r.l.

mfabian

As far as I recall it is not possible to write into views. Views are always read-only. You would have to link the oracle tables directly.

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

Tarek_Demiati

I'm not a SQL expert but have you tried
to achieve that by doing that by using a
Data Transformation Package from MS SQL 7.0 ?

tarek_demiati@ureach.com

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by gvolta:
does anybody has experience on accessing oracle from Navision?
I am using NF 2.5 with SQLServer and I can read oracle tables (linked tables) but i get an error when i try to write.
somebody told me that it is an ODBC problem but i didn't find any troubleshooting in the MS site until now.
thanks for any help

<HR></BLOCKQUOTE>