How do I set up the ODBC connection to hit an as/400 ?

Do I need to download something?

I've never done it, so any help is appreciated!

Thanks!

I've never actually done this, but the following connection strings should get you connected without a DSN...

(IBM)
"Provider=IBMDA400;Data source=myAS400;User Id=myUsername;Password=myPassword"

or
(MS)
"Provider=SNAOLEDB;Data source=myAS400;User Id=myUsername;Password=myPassword"

also, the following MS Knowledge Base article may shed more light (dunno, I didn't read it <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

support.microsoft.com/default.aspx?scid=kb;en-us;219077

Hope this helps

Doc
Rangewalk Digital Studios

Edited by - on 14 Nov 2002 14:40:09

Thanks! Thats what I was looking for!