I have two intermittent problems with a Windows 7-32 bit Dell Optiplex 3010 connecting using ODBC to a SQL Server 2008 database using Dymanics GP 2013. I'm using both SQL Native Client 10.0 and 11.0.
The first problem is the Worldship 2014 software cannot connect to the Import Key map every Monday Morning and sometimes other mornings. It will try to bring up the key for about 10 seconds then the key shows up but will not connect to the server. The key is used to pull in the Sales Order address info. When it does work, it takes 2 seconds to connect then pops up the import key window. It will work the rest of the day after that. I have to reboot every Monday and that works about 80% of the time. 20% of the time I will have to go reconfigure the ODBC 32-bit DSN Connection. I just test it.
UPS Tech Support had me setup two test machines in my office and they both would not error out so they told me it's an isolated issue with my factory PC.
Things I've tried;
Connected the PC in my office over the weekend to change the LAN. Still error-ed out.
Change the NIC.
Removed all sleep and power settings.
Tried ODBC SQL Driver 10.0 and 11.0.
Removed Trend Micro antivirus.
Reinstalled UPS Worldship 2014.
Can not find any events in logs for both the PC and Server.
Deleted and recreated the ODBC maps in Worldship 2014.
Tried a ODBC Data Source Trace but it never connects with the trace on and just fills the log.
The second problem is with the Export Map back to my database. It's set to write the UPS Tracking Number back to a table in SQL at the End of Day processing. This works about 80% of the time. When it doesn't write the data to the table, I can go to the PC and manually export the data to the SQL table and that works every time.
I've attached the generic UPS error messages but they do not create an event.
This problem started on the Windows XP PC after upgrading to Worldship 2014. I lived with it for a month because I was upgrading to the Windows 7-32 PC. The problem has continued on the new PC.