HomeHome Product Discus... Product Discus...SmithCartSmithCartError Importing ProductsError Importing Products
Previous
 
Next
New Post
1/20/2011 1:42 PM
 

When trying to import products I get the following error:

The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine.

My info:

DNN 5.05

Smith Cart 3.98

App Server: Server 2k8 64 bit

DB: SQL 2k8

What I've tried:

I tried xls, xlsx, and csv.

I registering the dlls for jet 4.0 with regsvr32. Here is the list and article that I got it from:

Microsoft Jet 4.0 OLE DB Provider
Provider=Microsoft.Jet.OLEDB.4.0
C:\WINNT\System32\Msjetoledb40.dll
C:\WINNT\System32\Msjet40.dll
C:\WINNT\System32\Mswstr10.dll
C:\WINNT\System32\Msjter40.dll
C:\WINNT\System32\Msjint40.dll

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

I tried that on both the app server and my local machine.

Not sure what else to try. Any ideas anyone?

 
New Post
1/20/2011 5:13 PM
Accepted Answer 

The cart product import feature imports data from .xls format, and uses the Microsoft Jet 4.0 OLE DB Engine to import products. By default x64 servers do not include the Microsoft Jet 4.0 OLE DB Engine. Heres a link to install the latest service pack for the Microsoft Jet 4.0 Database Engine, which supports 64bit servers. Heres a good forum post that explains how to properly install Microsoft Jet 4.0 engine to your server. http://stackoverflow.com/questions/12....

Christian

 
New Post
1/21/2011 10:05 AM
 

Thanks for the help.

The first link (the microsoft site) didn't really help, as I'm on Server 2k8, so there was nothing for me to do there. However, the second link to stackover flow solved my issue.

For those who have the same problem check it out. Basically you just need to go into IIS and set your app pool on the site to accept 32 bit apps.

That solved my issue. Then I came across another issue with an index out of range. That was solved using this thread: http://www.smith-consulting.com/forum...

Thanks again.

Justin

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError Importing ProductsError Importing Products