ODBC on 64 bit - not the usual numpty error!

MaxBatSWRI

Hi All,

We usually get through our trials and tribulations with Dyanics Nav. o.k. We're stll on 5.0 but it works well for us and we do some good things with it.

However, we (three of us plus users) are stumped in this one. Every avenue has been tried but we cannot get one of our VB programs to run on 32 or 64 bit Vista or Win7 when it has been published from a 64 bit machine. It does run on 32 and 64 bit machines when published froma a 32 bit machine. This applies whether we use VB 2008 or 2010 expresses.

Any ideas? Are doing something basic wrongly?

We can access our Dynamics databases programatically using the Syswow64 ODBC32.exe from Excel 2010 (32 bit) on 64 bit machines, no problem. The message we get from vb reports that there is no DSN - msg is System.Data.Odbc.Odbc. Exception ........ ERROR[IM002] ....... Data source name not found and no default driver specified.

Odbc32 in control panel shows an unconfigurable User DSN but no System DSN. SYsWoW64 shows a fully functioning System DSN which is named to match the call in the VB program.

Any ideas? Pretty sure it's not ODBC but am concerned about the absence of the unconfigurable System DSN in standard (non SysWoW) odbc32.exe

Cheers and thanks for your attention.

Max.