Integration Manager Error- Data source name not found and no default driver specified

(0) Share

Report

Posted on by Community Member

Hi! Has anyone seen this before. User is trying to Run an integration. This is a new machine and IM was just recently loaded. My next step was to maybe check the users old machine and make sure the ODBC settings are the same. Any other suggestions?

"Cannot write to a closed textwriter" Error executing script after integration line 5 [Microsoft][ ODBC Driver manager] Data source name not found and no default driver specified."

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Run EVERYTHING as (right click) Administrator

- Current version of IM - compatible with GP Client

- Did you do all the installation as Domain Admin?

- Did you verify ODBC is 32bit

Hey, you asked for ideas.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

It is mostly a data source issue, make sure to test the ODBC connection before hand with the appropriate administrative privileges.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Adding a point to the above suggestions. Your GP application is active when you are trying to run this Integration ? Because, the IM retrieves the connection and login information for the user currently signed on to Microsoft Dynamics GP .

Are you able to successfully login to GP using the ODBC connection? If not, as suggested by Mahamoud you need to check the ODBC connection.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The data source had the wrong server listed! Oops! Thanks for your help! =)

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Ooops !

Well, good to have your issue resolved eventually ;)

Was this reply helpful? Yes No