I recently completed a big move of my company’s online store from Volusion to 3D Cart’s platform. Whew! I’m glad it’s over and I’m so happy with the results, but more on this big move later. One problem I encountered was getting Endicia USPS shipping to work with 3D Cart. Here’s a brief overview of the fix.
I’m currently working with a Dymo Endicia Professional installation on a Windows 7 64-bit machine. It works great and there are no problems. But after following 3D Cart’s installation guide, Endicia just would not connect to my database. :( I suspected it had something to do with the 64-bit environment, and was right.
First, check out this article on 3D Cart’s knowledgebase:
The PDF on that page lists the steps but omits these important steps:
1) Configure your database connection with the 32-bit driver
Endicia Professional is a 32-bit application so it needs to look at the 32-bit driver. Open this by clickin on START > RUN> %windir%\syswow64\odbcad32.exe
This will open the 32-bit ODBC setup (which is identical to the 64-bit setup). Now you can add your “Galaxy” database as indicated in the 3D Cart documentaion.
2) Rename galaxy.mda
When you export your data file from your 3D Cart store, you will need to rename it. The file exports as galaxy.mda – just rename this to galaxy.mdb and hook it up to Endicia.