Anyone connecting to an AS/400 with ASP

[bigfoot]

I'm getting this error:

IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. Comm RC=11001 - CWBCO1003 - Winsock error, function returned 11001, S10A9999, Password length = 8, Prompt Mode = PROMPT_NEVER, System IP Address =

when I try to connect. I have tried all of these:

'oConn.Open "ODBC;DSN=S10A9999"
'oConn.Open "ODBC;UID=me;PWD=me;DSN=S10A9999"
'oConn.Open "Provider=IBMDA400.DataSource.1;Password=me;User ID=me;Data Source=S10A9999;Transport Product=Client Access;SSL=DEFAULT"
oConn.Open "Driver={Client Access ODBC Driver (32-bit)};" & _
"System=S10A9999;" & _
"Uid=me;" & _
"Pwd=me;"


Some give me different errors. I can connect with VB6 fine, but when I try to use an asp page, it bombs.

HELP! This machine is making me crazy!

 

[MrGreed]

try:

oConn.Open "DSN=S10A9999;UID=;PWD=;"

If you have a UserID and Password include those above.

Also Check out this link:

http://www.ibm.com/search?en=utf&v=...2/400+SQL]Communication+link+failure&x=15&y=9

"did you just say Minkey?, yes that's what I said."

MrGreed

 

[bigfoot]

Put this in:
oConn.Open "DSN=S10A9999;UID=;PWD=;"

Added the name and password, and this is what I get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. Comm RC=11001 - CWBCO1003 - Winsock error, function returned 11001, S10A9999, Password length = 8, Prompt Mode = PROMPT_NEVER, System IP Address =


db_stuff/as400dbtest.asp, line 28

 

[bigfoot]

Ahhhhhhhh You all forgot to tell me this bit of information:

To configure the ODBC Driver you need to do the following:

Ø Install Client Access

Ø Configure a Client Access connection to your AS/400

And now, the part that makes it work!!!

Ø In the Client Access installation directory type: CWBCFG /host hostname /s where ‘hostname’ is the name of your AS/400 on your TCP/IP network

Ø Configure a System Data Source in the ODBC Administrator

The AS/400 can now be accessed just like any other ODBC data source. The reason you need to run the CWBCFG utility is to add Client Access configuration information for the .default user which permits IIS to find and use the configuration information.

A sample connection string for a DSN name AS400_DSN would then be:

objConnection.Open "Data Source=AS400_DSN;User ID=USERID;Password=PASSWORD"

Works now BG.
If I could only figure out how to do a Right(field,2)
The AS/400 will not take it in a SQL string.