Forum Discussion

slim17's avatar
4 years ago

MYOB ODBC Driver Problem On 64 bit Windows 10 PC

Hi

 

We have third party C# .NET CRM software which shares data with MYOB via MYOAU1001 ODBC driver connection embedded in code of CRM application.

 

Client has upgraded their Windows 7 32 bit machine to Windows 10 64 bit machine and ODBC export from CRM to MYOB is no longer working. When our CRM is attempting to connect to MYOB, we are receiving error message like this "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

 

We have research this problem and our understanding is that MYOB MYOAU1001 ODBC driver is only compatible for 32 bit machine not 64 bit machine.

 

The problem is that client must upgrade to 64 bit machine for compliance reason. Second problem is that client must continue to use CRM software as it is very important for their business. Third problem is that to pull out all CRM export code and replace it with new API code will be expensive job take many hours.

 

So I am looking for MYOB ODBC aware developer to assist me with this how I can engineer simple cost effective solution to get this existing architecture working on Windows 10 64 bit environment please. Can feel free to PM me I am happy to talk this though on phone if necessary as is critical problem.

 

Thankyou. 

 

  

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User

    Hi slim17 , if you are using a DSN to connect to the file, then you need to use C:\Windows\SysWOW64\odbcad32.exe to create/configure it. This is the 32-bit version. 

    • slim17's avatar
      slim17

      Hi Mike_James 

       

      Previously we have installed driver locally. It is creating folder C:\MYOBODBCAU10 after installation.

       

      Then we are connecting in C# using an ODBC connection object using MYOB driver connection string to database. This has created connection without having to manually creating DSN in Windows control panel.

      Connectionstring was like this:

      {MYOAU1001};TYPE=MYOB;ACCESS_TYPE=READ_WRITE;DRIVER_COMPLETION=DRIVER_PROMPT;SQL_LOGIN_TIMEOUT=30;SUPPRESS_WARNINGS=TRUE;NETWORK_PROTOCOL=TCPIP;HOST_EXE_PATH=C:\Premier19\Myobp.exe;UID=x;PWD=y;Database=C:\Premier19\DB.myo;KEY=z;

       

      Does this make sense?

      • gavin12345's avatar
        gavin12345
        Ultimate User

        Hi slim17 

         

        You may need to re-install the MYOBODBC driver now that you have upgraded your computer. I use ODBC in similar manner to what you have described. I run this on a 64 bit Windows OS - the 64 bit system is not the issue, it is that the 64 bit system cannot find the driver MYOBAU1001 - reinstalling this might help recreate the relevant registry settings.

         

        Regards

        Gavin