Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Error 1

Status
Not open for further replies.

jpanic

IS-IT--Management
Nov 17, 2000
14
US
I am running Crystal Reports 7 accessing data from a DB2 database on an AS/400. Over the weekend we reinstalled Microsoft Office on our desktops. Now when we try to run our reports we get the following error message "Run-Time error 40002 IM 006 [Microsoft]{ODBC Driver Manager] [Drivers SQL Set Connect Attr Failed.

We have reinstalled the ODBC driver and reconfigured it according to where it was set before. ANy ideas.
 
Can you get any ODBC connection to work? Can you get an ODBC connection to the AS/400? Can you create a new report with an ODBC connection to the AS/400? Have you tried Database|Verify, or Database|Set Location? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top