Navision and ODBC

rhurley

I can sucessfully open a recordset and fill web pages with Navision data, but as soon as I attempt to create a new record and update it I recieve a Navision ISAM error.

Any suggestions to resolve this?

rhurley

No. I checked that right off when I had the problem and found it was not set in the ODBC setup. I have even attempted this with a simple file with only two fields set up and still recieve the same error.

Thanks for the reply.

---

Dennis_Decoene

Can you give a more specific error message?

---

Dennis Decoene
Navision Software Engineer

MicroComputing NV
Nijverheidsweg 1
9820 Merelbeke
Belgium

Tel: +32 (0)9/231.26.88
Fax: +32 (0)9/231.77.57
http://www.microcomputing.be

rhurley

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Navision Software a/s][Navision Financials ODBC Driver]ISAM error

Here is a sample of the code.<% sub addNavisionEvent

set navconnect = server.createobject("ADODB.Connection")
navconnect.open "Lile-Navision"
set navAppointment = server.createobject("ADODB.Recordset")
set navSales = server.createobject("ADODB.Recordset")
navSales.open "Select * FROM Salesperson_Purchaser WHERE Calendar_User_Name = '" & ucase(sUserName) & "'", navconnect
navAppointment.open "TestTable",navconnect,adOpenStatic, adLockOptimistic, adCmdTable
navAppointment.addnew
navAppointment("No_") = "ABCD"
navAppointment("Test") = "Testing"
navAppointment.UPDATE

---

Dennis_Decoene

Is your connection opened as read only?

---

Dennis Decoene
Navision Software Engineer

MicroComputing NV
Nijverheidsweg 1
9820 Merelbeke
Belgium

Tel: +32 (0)9/231.26.88
Fax: +32 (0)9/231.77.57
http://www.microcomputing.be

Karsten_Fuchs

Is there any CODE field in your table ? If so we do have the same problem. Changing the CODE field(s) to Text could do it.