Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Exchange - ODBC: ErrorNumber 5000

Highlighted
Vleung
Super Collector

Data Exchange - ODBC: ErrorNumber 5000

Hello,

I was just experimenting getting another computer to run some Data Exchange tasks, so I copied the ini files from a laptop to the desktop, set up ODBC through Administrative Tools, and then tried to test it out.

Unfortunately every time I try to export the data it comes back with the fatal error:
"Could not get DB Connection to jdbc:odbc:, user:"

The annoying thing is that it stopped working on the laptop as well, which performed a data import successfully just yesterday. I've looked through the ini file and found nothing was changed. The Import mapping on the laptop didn't have anything wrong either.

Does anyone have any ideas?
1 REPLY
Vleung
Super Collector

Re: Data Exchange - ODBC: ErrorNumber 5000

Found the problem: I have to keep the Excel file open at all times when performing a data exchange. I generally edit the data before a real import which is probably why I thought it was a non-issue whether the excel file was active or not. Oh well, future reference for everyone :)
//Add this to "OnDomLoad" event