ODBC connection error

[Walter Vaughan]

Yeah, your error message could not be clearer. You have probably the 64bit ODBC connector setup to be run for everyone  and that's what your workstation is trying to use. The server  could be a 16-32-64-128-256 bit whatever, but your OBDC connector must be compatible to  the OS of the workstation that wants to use it.

In other news you should not be running any Windows 2003 Server that has any access to the internet.

-----Original Message-----
From: Filepro-list [mailto:filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of Richard Hane via Filepro-list
Sent: Wednesday, September 23, 2015 3:24 PM
To: Filepro List <filepro-list at celestial.com>
Subject: ODBC connection error

Our system, fpodbc (5.0.13) 16 user network.  All data and programs reside on the server.  Users have a mapped drive (V:) to the above.  Only thing on workstations are shortcuts.
Each morning we run a couple of bat files which update data from our ERP software (Microsoft SQL) to filePro.  This has worked for many years.  Recently my workstation is been having some problems, so we want to move the short cuts to another computer.
I went to add the odbc (ERP-fpserver) to another workstation.  I received the attached error message.  Can someone tell me what is wrong?  I should point out that my workstation is running 32 bit Windows7 and the other workstation is running 64 bit Wndows7.  Could this be the problem.
A more important question is it possible to set this up to run directly on the server.  BTW server is Windows 2003 server.
Thank you in advance, Rick Hane

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150923/f8625f59/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fpodbc_error.jpg
Type: image/jpeg
Size: 36382 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150923/f8625f59/attachment.jpg>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list