ODBC Drivers for windows server 2003 x64

I was developing the application of the related question in a server 2003 x86 with visual studio 2008, there was installed the following driver : http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx, which used to work perfectly.

Now I am using a server 2003 x64 with visual studio 2010 and the same driver but I got an error with the ODBC drivers, just like if that driver were not installed. Is this because x64 version?

Thanks in advance.
dimensionavAsked:
Who is Participating?
 
pcelbaCommented:
Visual FoxPro and all derived drivers are 32 bit and you cannot access them from 64 bit applications.

So, if you need to access DBF files in 64 bit OS you have to compile your application as 32 bit and execute it in 32 bit subsystem. (Windows\SysWOW64\ subfolder obviously).

Alternatively you can access FoxPro DBF files via Sybase ODBC driver included in Advantage Database Server (http://www.sybase.com/products/databasemanagement/advantagedatabaseserver) or dBase DBF files via MS Office driver (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255).
0
 
Jaroslav MrazCTOCommented:
yes you must have x64 driver
0
 
dimensionavAuthor Commented:
I have tested the compiled application in a x86 computer and it says that is not a valid win 32 application

So I can see a couple of problems:

1. A driver that works in both environments (x86 and x64).
2. How to compile the application in order to work in both platforms (x86 and x64)?

What do you recommend?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Jaroslav MrazCTOCommented:
Iam not lot of skiled developer but i whose working on development. And we usualy have drivers alone so every user can instal what he need. And then apication coud be only 32bit :) and it wil work on x64 becouse of emulation.
0
 
Dave BaldwinFixer of ProblemsCommented:
Here's a link to the Fox Pro ODBC driver which is no longer supported: http://msdn.microsoft.com/en-us/vfoxpro/bb190233  And here is the OLE DB provider they mention in that article: http://www.microsoft.com/download/en/details.aspx?id=14839
0
 
dimensionavAuthor Commented:
pcelba:
In case using MS Office driver I have some questions:

1. Could I distribute those drivers freely in all my applications? If yes, How could I pack them as a part of the whole installer of my app?
2. Is necessary that MS Office be installed on each computer that runs my app?

Thanks
0
 
dimensionavAuthor Commented:
pcelba:

in the other hand I have found that using advantange in local applications is just for free...
http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/local-server

Would you mind to give an example how to perform a connectionstring using advantage and MS Office Driver?
0
 
dimensionavAuthor Commented:
After installing MS Office drivers I have tried the following connectionstrings:

Dim sConn As String = "Provider =Microsoft.ACE.OLEDB.12.0; Data Source =z:\temp\mgw10005.dbf;"
And I got a datatype file error.

And If I do this (free tables directory):
Dim sConn As String = "Provider =Microsoft.ACE.OLEDB.12.0; Data Source =z:\temp\;" I got a ISAM error.
0
 
pcelbaCommented:
The driver works without office installed but I am not licensing specialist, you have to ask Microsoft about distribution possibilities.

Sybase ODBC driver is delivered together with documentation which contains connection string examples.

MS Office driver supports dBase files only. FoxPro files report ISAM error.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.