PHP, ODBC, and Navision.

Daedalus
Daedalus Member Posts: 30
edited 2007-01-16 in NAV/Navision Classic Client
I'm trying to connect to Navision using ODBC through PHP.

I was having a problem with an incorrect username and password but when I started using the windows login (even though i should because the dsn is on the web server and i do not know what kind of permissions it has in Navision), it started working again but now I am getting this error:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Simba][SimbaEngine ODBC Driver][DRM File Library]The operating system cannot gain access to the file .Please check that the file type and attributes are correct. Error: 5, SQL state S1000 in SQLConnect in [edited] on line 23
S1000

I do not know what the hell it wants from me, I have been messing with it for over three hours and I am getting ready to go home. 12 hours is a long enough day for me. :/
"A man without beer is like a man without water, thirsty and sober!"

Comments

  • kine
    kine Member Posts: 12,562
    Without more info about how you are setting the parameters for connecting we cannot help you. Please, send more info (mainly the parameters used when connecting the NAV server).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Daedalus
    Daedalus Member Posts: 30
    EDIT: I just realised I am retarded and need to try some new code, I'll check back later.
    "A man without beer is like a man without water, thirsty and sober!"

Categories