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!

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

SQL ODBC to AS 400

Status
Not open for further replies.
bartsimpson

bartsimpson

IS-IT--Management
Jul 23, 2001
100
GB
I'm trying to set up an ODBC link between an SQL server and an AS 400. I have created an ODBC link from the client access CD, and successfully connected via MS Access. However, if I try via SQL server data transformation services, the link just fails with a nondescript error message. I get an error if I try and connect from MS Excel too -

SQL0104 - Token * was not valid. Valid tokens : ( <IDENTIFIER>.

There is no more information.

Has anyone else seen this message, or been able to do what I am trying to do successfully ?

Regards,
 
Status
Not open for further replies.

Similar threads

DrB0b
  • Locked
  • Question
Moving possibly to AWS 1
Replies
3
Views
209
SamBones
SamBones
olorin0958
  • Locked
  • Question
Unable to source hp part 148757-001
Replies
2
Views
211
olorin0958
olorin0958
DrB0b
  • Locked
  • Question
Kofax TotalAgility Questions
Replies
0
Views
195
DrB0b
DrB0b
amandeepgautam
  • Locked
  • Question
How to mount a ufs (on solaris 10) on solaris 11
Replies
0
Views
113
amandeepgautam
amandeepgautam
evr72
  • Locked
  • Question
Copy AS400 file to a different AS400 folder
Replies
1
Views
216
evr72
evr72

Part and Inventory Search

Sponsor

Back
Top