How to use MySQL with DSN in Prime 3.1 with ODBCread ?

WalterSchrabmai — Thu, 03 May 2018 15:15:59 GMT

Hi experts,I have a sheet done (the demo) with a MS Access DB with DSN and OLE in Prime 3.1. See https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS181327For this to get run you have to install: (See the Q&A resouce from the web below)Q: I'm working on a program

Re: How to use MySQL with DSN in Prime 3.1 with ODBCread ?

WalterSchrabmai — Sat, 25 Jul 2015 18:20:10 GMT

I found the reason, there was some problems with odbcad32.exe

I made a new DSN in the normal Application (Admin Tools > ODBC), not in windows\syswow64\odbcad32.exe

ANd I had to install both 32 bit and 64bit MySQL ODBC 5.3 Dirvers. ( I think I had forgotten to install the 32bit driver before.)

ANd defined the connect string as follows:

ConnectString := "FIL=MS Access;DSN=mathcadASNI.dsn"

and did logging on to check if there are errors. and vola! It works.

BUT: for the ODBCRead the decimal point must be a . not a comma. So you have to change to english format in the windows settings.