Microsoft.Jet.OLEDB.4.0 on 64 bit version MS SQL 2005

[GoodDay]

Hello & sorry for poor english!
I migrate from SQL 2000 on 32 bit platform to SQL 2005 (Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
One of the stored procedure (its works well on 32 bit 2000) using Openrowset (Microsoft Jet OleDb driver) to select from dbase file. I made all as writing at BOL

http://msdn.microsoft.com/en-us/library/ms141766(SQL.90).aspx

:
1 Create package (Execute Sql Task Editor, that call this procedure), with Debug Options Run64BitRuntime = false (package was create on 32 bit developer's PC)
2 Deploy project and save package at msdb
3 Create test job with one step. Its type is Operating System (CmdExec) The command call 32 bit version dtexec
"c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" and run my package
As result I get an error : Executed as user: ...00.1399.06 for 32-bit ..Code: 0xC002F210 ...Execute SQL Task Description: Executing the query "exec MyOpenRowSetStoredProc" failed with the following error: "Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".".
Please help, what i must do that package works correct?
Thank you!

 

[gmmastros]

Try running this in a query window.

xp_enum_oledb_providers

That above code will display 3 columns. In the "Provider Name" column, do you see "Microsoft.Jet.OLEDB.4.0" ?


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[GoodDay]

Thank you, gmmastros, but in result set of xp_enum_oledb_providers there is NOT "Microsoft.Jet.OLEDB.4.0".And how I can register (install) this provider (dll) on server (also 64 bit version)?

 

[GoodDay]

Sorry - I so quick press button Post. My question is :
And how I can register (install) this provider (dll) on server (that also has 64-bit Windows version)?

 

[gmmastros]

Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on [!]Windows NT 5.2 (Build 3790: Service Pack 2)[/!]

Are you running Windows XP Service Pack 2? If so, you should run windows updates to see if this fixes the problem. I recommend this method first because if you are missing this particular windows update, what else are you missing?

For computers that are running Microsoft Windows XP

If you are running Windows XP SP2, you have a later version of Jet 4.0 than the version that is included with Jet 4.0 SP8. We recommend that you install the latest service pack for Windows XP.

http://support.microsoft.com/kb/239114

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[GoodDay]

George, thank you. I try do it at monday. But some stored procedures r working with another openrowset MDAC (now i forgot the version of MDAC) And i feel, that MDAC is another problem.....

 

[gmmastros]

Why do you think you have a problem with MDAC? There used to be a time (quite a few years ago) when MDAC would install the microsoft jet drivers. Not so anymore. You have to install mdac separately from the jet driver.

Anyway, if you think you need to install a new version of MDAC...

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&displaylang=en

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[GoodDay]

George , thank you !