MYOB ODBC Driver Problem On 64 bit Windows 10 PC

Question

Hi&nbsp;We have third party C# .NET CRM software which shares data with MYOB via MYOAU1001 ODBC driver connection embedded in code of CRM application.&nbsp;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".&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;Thankyou.&nbsp;&nbsp;&nbsp;&nbsp;

mike_james · Answer

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

slim17 · Answer

Hi&nbsp;Mike_James&nbsp;&nbsp;Previously we have installed driver locally. It is creating folder C:\MYOBODBCAU10 after installation.&nbsp;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;&nbsp;Does this make sense?

gavin12345 · Answer

Hi&nbsp;slim17&nbsp;&nbsp;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.&nbsp;RegardsGavin

waddoaus · Answer

Hi&nbsp;gavin12345&nbsp;,Wondering if you can offer any assistance.... we use ODBC on good old enterprise 19.7 and recently had to set up on a 64 bit machine (previously running on a 32 bit).&nbsp; I too get the "The specified DSN contains an architecture mismatch between the Driver and Application" message when running our interface program.&nbsp; I set up the DSN from the 32bit ..windows/SysWOW64/odbcad32 and the test connection indicates no problems but still get the architecture mismatch error?, I'm pulling my hair out and i'm guessing it's something simple.&nbsp;&nbsp;Regards,Sam

slim17 · Answer

&nbsp;WaddoAus&nbsp;FWIW I raised this issue with the MYOB development team. This was their reply...&nbsp;"...Thank you for reaching out. Unfortunately, we no longer support AccountRight v19 classic as this has been discontinued. This also applies to ODBC as we no longer support AccountRight classic we also discontinued ODBC. We have not turned the program off. As AccountRight v19 and earlier versions were only tested and supported for compatibility with 32bit Office applications, the ODBC driver is designed as a 32 bit driver. Currently we don’t offer a 64 bit option of the ODBC driver&nbsp;The team that used to support ODBC no longer is available at&nbsp;MYOB&nbsp;for questions or support.&nbsp;At this stage, we would recommend for the end-user to upgrade to our latest versions of AccountRight Live which uses the API not ODBC. This would require a separate integration though..."So after much trial and error trying to do workarounds I eventually gave up.

Forum Discussion

MYOB ODBC Driver Problem On 64 bit Windows 10 PC

Looking for something else?

Related content

Credit Card Allocation problems

Inventory Import Problems

Can't access prepare BAS window

Problem with allocating credit card payments

Problem lodging BAS

Problems with generating debtor statement

Opening MYOB Account Edge in Windows

TERMINATION PAYMENT PROBLEM