Jet Drivers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Davros Spignot - 06 Nov 2006 12:26 GMT

I am trying to import from a CSV file to SQL using Micrsoft Text Drivers and
.NET.
I do not have Text Driver / Jet Engine (???) installed on my x64 windows
2003 machine and i am lost. From what i can gather i cannot install them on
my 64 bit windows 2003 rented web server? I tried to install the
"Jet 4.0 Service Pack 8 (SP8) for Windows Server 2003 64 Bit Edition
(KB829558)"

but when it runs I get the error: "..image .... is for machine type other
than current machine..." of course I can try an write a CSV parser of my own
using strings but I would like to use jet Drivers. Can I?

As I am sure is obvious I am layman. Advice greatfully received. Thanks.

Reply to this Message

Nut Cracker - 06 Nov 2006 15:14 GMT

>I am trying to import from a CSV file to SQL using Micrsoft Text Drivers
>and
[quoted text clipped - 12 lines]
>
> As I am sure is obvious I am layman. Advice greatfully received. Thanks.

it sounds like you might have grabbed the IA64 version instead of the x64
version of that package. Its the only thing i can think of that would give
you that message.

- NuTs

Reply to this Message

Steve Foster [SBS MVP] - 06 Nov 2006 19:50 GMT

>I am trying to import from a CSV file to SQL using Micrsoft Text Drivers
>and
>.NET.
>I do not have Text Driver / Jet Engine (???) installed on my x64 windows
>2003 machine and i am lost.

There is no Jet for x64, only x86. It's preinstalled on x64 editions of
Windows. It's only accessible by 32-bit applications.

>From what i can gather i cannot install them on
>my 64 bit windows 2003 rented web server? I tried to install the
>"Jet 4.0 Service Pack 8 (SP8) for Windows Server 2003 64 Bit Edition
>(KB829558)"

Tha'ts the Itanium version. x64 versions of Windows already have the
latest Jet 4.0 32-bit DLLs (they're ahead of SP8).

>but when it runs I get the error: "..image .... is for machine type other
>than current machine..." of course I can try an write a CSV parser of my
>own
>using strings but I would like to use jet Drivers. Can I?

If you're running 32-bit SQL, yes.

But f you're running 64-bit SQL Server, you can only use 64-bit tools,
which essentially means ADO.Net.

Signature

Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

Reply to this Message

RADl0PASlV - 08 Nov 2006 12:25 GMT

> I am trying to import from a CSV file to SQL using Micrsoft Text Drivers
> and
[quoted text clipped - 5 lines]
> "Jet 4.0 Service Pack 8 (SP8) for Windows Server 2003 64 Bit Edition
> (KB829558)"

You can vote here:

Microsoft Connect > SQL Server: x64 Jet provider
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125117

Reply to this Message