Re: Excel import with x64 machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks for the hints and sorry for an additional stupid question (I
don't know much about x64 architecture...): I guess when the app is
run in 32 Bit mode, it will also behave like it was run under Win32
and not address more than 2GB? That is no option then, since the
ability to use huge amounts of RAM is why the app was ported to x64 in
the first place.

I could not have been that hard to at least "bridge" the 64 Bit OleDB
Drivers to the 32 Bit OleDB Drivers (or ODBC drivers). This makes me
wonder how much dedication MS spents to x64 systems.

I will look for other solutions like write a litte 32 Bit Program that
only executes the Jet Imports (and communicates with the 64 Bit
somehow and I don't know how other than exchanging files) or have SQL
Server import the Excel data to a temp table, but it is a pity that
this is necessary. My app is a windows service, I wonder how deep the
porting issues would possibly be if I had to work with graphics and
printer drivers.

Regards
DC

On 10 Mai, 18:18, "Mark Rae" <m...@xxxxxxxxxxxxxxxxx> wrote:
"Nicholas Paldino [.NET/C# MVP]" <m...@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
messagenews:%23DeKp2xkHHA.1624@xxxxxxxxxxxxxxxxxxxxxxx

Have you thought about running your app in 32 bit compatability mode? This
might be your only option.

I had a similar problem recently with Jet rather than Excel, but the
principle is the same...

As I understand it, there are no 64-bit OleDb drivers for anything other
than SQL Server - therefore, it's not possible to write 64-bit apps which
interface with databases in this way...

In the end I had no choice but to force the app to compile in 32-bit after
which, of course, everything was fine...


.

Relevant Pages

  • Re: Migrating app from 3.2v4.2 to OpenServer 5.0.7?
    ... > application talks directly to the device with its own drivers. ... from SCO Unix 3.2v4.2 to OpenServer 5.0.7. ... The app is working fine. ... 3.2v4.2 might be difficult to install on current hardware. ...
    (comp.unix.sco.misc)
  • Re: [RFC] What are the goals for the architecture of an in-kernel IR system?
    ... the tables from the kernel drivers. ...  There is no reason to make the lirc merge wait for it. ... definition app via udev. ... Could anyone please draw me a picture, starting with a "receiver" ...
    (Linux-Kernel)
  • Re: Pentium 1.8Ghz / Windows 2000 / Delphi 6 problem
    ... There's a difference between a user mode DLL, ... User mode DLL's will not affect the control word *across ... >any DLL's that your app is using, ... For drivers, they may well change and forget to restore the FPU ...
    (comp.lang.pascal.delphi.misc)
  • Re: Problem with XP scheduler?
    ... they've architected OS that makes possible for 3rd party drivers to ... Now, has MS & industry made some progress, or not? ... If I can not run my perfectly working firewall app ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Excel import with x64 machine
    ... don't know much about x64 architecture...): I guess when the app is ... You are accessing Excel data, right, excel is still 32 bit, you can't possibly have worksheets larger than 2GB. ... Drivers to the 32 Bit OleDB Drivers. ...
    (microsoft.public.dotnet.languages.csharp)