OleDb and x64

[Mark Rae]

Hi,

Since there *appears* to be no 64-bit support for any data source other than
SQL Server (and I wouldn't use OleDb to interface with SQL Server anyway as
there's a native .NET data provider for that), what is the "accepted wisdom"
for porting 32-bit apps to 64-bit when they require OleDb support...? Can it
simply not be done...?

E.g. let's say I have an existing 32-bit WinForms app written in VS.NET 2005
(C#) and my client has now asked me to create a 64-bit version, but the
existing 32-bit app uses Jet as its back-end database... What are my
options...?

Maybe the WinForms app is a data consolidation tool which receives remote
data feeds in the form of emails with attached Jet databases or Excel
spreadsheets...? Jet and Excel remain hugely popular file formats in the
corporate world, and that seems unlikely to change in the near future,
especially Excel...

Do I have to tell my client that, regrettably, it's just not possible to
create a 64-bit version of any app which needs to interface with Jet or
Excel...?

Any assistance gratefully received.

Mark

 

[Guest]

Hi Mark,

As you have already found out, Microsoft do not provide an OLE-DB
Provider for ODBC data sources for 64bit versions of SQL Server 2005 as
they do with the 32bit versions.

All is not lost though, we at OpenLink Software do provide a 64bit OLE DB
Provider for ODBC data sources.

A full featured time limited evaluation of this product can be downloaded
from http://download.openlinksw.com/download/

Please note, that all dlls etc that run in the same process space need to be
either all 32bit or all 64bit (not mixed).

That is, you are using 64bit SQL Server so the OLE DB Provider needs to be
64bit and so does the ODBC Driver and any third party dependant libraries.

I hope this helps?

If you need more information, please let us know directly.

Regards,

Garry M. Biggs
Technical Support
OpenLink Software

 

[Mark Rae]

All is not lost though, we at OpenLink Software do provide a 64bit OLE DB
Provider for ODBC data sources.

A full featured time limited evaluation of this product can be downloaded
from http://download.openlinksw.com/download/

Thanks - I'll take a look...

Please note, that all dlls etc that run in the same process space need to
be
either all 32bit or all 64bit (not mixed).

That is, you are using 64bit SQL Server so the OLE DB Provider needs to be
64bit and so does the ODBC Driver and any third party dependant libraries.

Understood.