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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jaroslav MrazCTOCommented:
yes you must have x64 driver
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?
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.
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

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
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).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dimensionavAuthor Commented:
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?

dimensionavAuthor Commented:

in the other hand I have found that using advantange in local applications is just for free...

Would you mind to give an example how to perform a connectionstring using advantage and MS Office Driver?
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.
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.