By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,584 Members | 1,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,584 IT Pros & Developers. It's quick & easy.

ASP connection to DB2/AS400

P: n/a
I am trying to connect to a DB2 database on an AS400 via ASP. On the server
I can connect fine using VB, but keep getting a communcation link failure
when using the exact same code in ASP. Here is my code (I know the AS400
ODBC DSN works ok because I can connect to it from MS Access with no
problems):

set cnn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
cnn.open "DSN=SYSTEM2"

Help!
Jul 19 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Do you have the DSN setup on the server? Do you have drivers installed?

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eU**************@tk2msftngp13.phx.gbl...
I am trying to connect to a DB2 database on an AS400 via ASP. On the server I can connect fine using VB, but keep getting a communcation link failure
when using the exact same code in ASP. Here is my code (I know the AS400
ODBC DSN works ok because I can connect to it from MS Access with no
problems):

set cnn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
cnn.open "DSN=SYSTEM2"

Help!

Jul 19 '05 #2

P: n/a
I am using IBM's client access software and have setup a DSN which works via
VB. When I try using the DSN-less connection string below, I get provider
cannot be found.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...
p.s. Try dsn-less. For IBM's CA drivers, use:
Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data
Source=YourAS400Name;

Ray at work

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Do you have the DSN setup on the server? Do you have drivers installed?

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eU**************@tk2msftngp13.phx.gbl...
I am trying to connect to a DB2 database on an AS400 via ASP. On the

server
I can connect fine using VB, but keep getting a communcation link failure when using the exact same code in ASP. Here is my code (I know the AS400 ODBC DSN works ok because I can connect to it from MS Access with no
problems):

set cnn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
cnn.open "DSN=SYSTEM2"

Help!



Jul 19 '05 #3

P: n/a
Yes they are, I am actually using my desktop as a dev server. When I go into
the ODBC admin I can see IBM Client Access under the drivers tab.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...
Are the IBM DB/2 drivers installed on the server though? It doesn't sound
like it.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eO**************@TK2MSFTNGP10.phx.gbl...
I am using IBM's client access software and have setup a DSN which works

via
VB. When I try using the DSN-less connection string below, I get provider
cannot be found.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...
p.s. Try dsn-less. For IBM's CA drivers, use:
Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data
Source=YourAS400Name;

Ray at work

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
> Do you have the DSN setup on the server? Do you have drivers

installed? >
> Ray at work
>
> "mechweb" <me*****@yahoo.com> wrote in message
> news:eU**************@tk2msftngp13.phx.gbl...
> > I am trying to connect to a DB2 database on an AS400 via ASP. On the > server
> > I can connect fine using VB, but keep getting a communcation link
failure
> > when using the exact same code in ASP. Here is my code (I know the

AS400
> > ODBC DSN works ok because I can connect to it from MS Access with no > > problems):
> >
> > set cnn = server.createobject("adodb.connection")
> > set rs = server.createobject("adodb.recordset")
> > cnn.open "DSN=SYSTEM2"
> >
> > Help!
> >
> >
>
>



Jul 19 '05 #4

P: n/a
Huh, how about that. Alright, with your DSN that you have setup, is that a
user DSN or system? Try creating a system DSN (and testing it) and see if
that helps.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:Of**************@TK2MSFTNGP10.phx.gbl...
Yes they are, I am actually using my desktop as a dev server. When I go into the ODBC admin I can see IBM Client Access under the drivers tab.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...
Are the IBM DB/2 drivers installed on the server though? It doesn't sound
like it.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eO**************@TK2MSFTNGP10.phx.gbl...
I am using IBM's client access software and have setup a DSN which works
via
VB. When I try using the DSN-less connection string below, I get
provider cannot be found.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...
> p.s. Try dsn-less. For IBM's CA drivers, use:
> Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data
> Source=YourAS400Name;
>
> Ray at work
>
> "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> news:%2***************@TK2MSFTNGP12.phx.gbl...
> > Do you have the DSN setup on the server? Do you have drivers

installed?
> >
> > Ray at work
> >
> > "mechweb" <me*****@yahoo.com> wrote in message
> > news:eU**************@tk2msftngp13.phx.gbl...
> > > I am trying to connect to a DB2 database on an AS400 via ASP. On the > > server
> > > I can connect fine using VB, but keep getting a communcation
link > failure
> > > when using the exact same code in ASP. Here is my code (I know the AS400
> > > ODBC DSN works ok because I can connect to it from MS Access

with no > > > problems):
> > >
> > > set cnn = server.createobject("adodb.connection")
> > > set rs = server.createobject("adodb.recordset")
> > > cnn.open "DSN=SYSTEM2"
> > >
> > > Help!
> > >
> > >
> >
> >
>
>



Jul 19 '05 #5

P: n/a
The DSN I have been using is a system DSN. In VB, I can get data back no
problem, but ASP is giving me hell. I have tried about 50 variations of a
connection string to no avail. I still think ASP should work just like in
VB, but it doesn't. Aaarrrrgggghhhhh!!!!!!!

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Huh, how about that. Alright, with your DSN that you have setup, is that a user DSN or system? Try creating a system DSN (and testing it) and see if
that helps.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:Of**************@TK2MSFTNGP10.phx.gbl...
Yes they are, I am actually using my desktop as a dev server. When I go

into
the ODBC admin I can see IBM Client Access under the drivers tab.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...
Are the IBM DB/2 drivers installed on the server though? It doesn't sound like it.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eO**************@TK2MSFTNGP10.phx.gbl...
> I am using IBM's client access software and have setup a DSN which works via
> VB. When I try using the DSN-less connection string below, I get

provider
> cannot be found.
>
> "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> news:ue**************@TK2MSFTNGP12.phx.gbl...
> > p.s. Try dsn-less. For IBM's CA drivers, use:
> > Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data
> > Source=YourAS400Name;
> >
> > Ray at work
> >
> > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > news:%2***************@TK2MSFTNGP12.phx.gbl...
> > > Do you have the DSN setup on the server? Do you have drivers
installed?
> > >
> > > Ray at work
> > >
> > > "mechweb" <me*****@yahoo.com> wrote in message
> > > news:eU**************@tk2msftngp13.phx.gbl...
> > > > I am trying to connect to a DB2 database on an AS400 via ASP.
On
the
> > > server
> > > > I can connect fine using VB, but keep getting a communcation

link > > failure
> > > > when using the exact same code in ASP. Here is my code (I know the > AS400
> > > > ODBC DSN works ok because I can connect to it from MS Access

with
no
> > > > problems):
> > > >
> > > > set cnn = server.createobject("adodb.connection")
> > > > set rs = server.createobject("adodb.recordset")
> > > > cnn.open "DSN=SYSTEM2"
> > > >
> > > > Help!
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Jul 19 '05 #6

P: n/a
You're right. It should in this case. Just for the hell of it, post
relevant code and the error/line number.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:uR**************@TK2MSFTNGP10.phx.gbl...
The DSN I have been using is a system DSN. In VB, I can get data back no
problem, but ASP is giving me hell. I have tried about 50 variations of a
connection string to no avail. I still think ASP should work just like in
VB, but it doesn't. Aaarrrrgggghhhhh!!!!!!!

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Huh, how about that. Alright, with your DSN that you have setup, is that
a
user DSN or system? Try creating a system DSN (and testing it) and see if that helps.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:Of**************@TK2MSFTNGP10.phx.gbl...
Yes they are, I am actually using my desktop as a dev server. When I
go into
the ODBC admin I can see IBM Client Access under the drivers tab.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...
> Are the IBM DB/2 drivers installed on the server though? It doesn't sound
> like it.
>
> Ray at work
>
> "mechweb" <me*****@yahoo.com> wrote in message
> news:eO**************@TK2MSFTNGP10.phx.gbl...
> > I am using IBM's client access software and have setup a DSN which

works
> via
> > VB. When I try using the DSN-less connection string below, I get
provider
> > cannot be found.
> >
> > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > news:ue**************@TK2MSFTNGP12.phx.gbl...
> > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data
> > > Source=YourAS400Name;
> > >
> > > Ray at work
> > >
> > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > news:%2***************@TK2MSFTNGP12.phx.gbl...
> > > > Do you have the DSN setup on the server? Do you have drivers
> installed?
> > > >
> > > > Ray at work
> > > >
> > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > news:eU**************@tk2msftngp13.phx.gbl...
> > > > > I am trying to connect to a DB2 database on an AS400 via
ASP. On the
> > > > server
> > > > > I can connect fine using VB, but keep getting a communcation

link
> > > failure
> > > > > when using the exact same code in ASP. Here is my code (I

know the
> > AS400
> > > > > ODBC DSN works ok because I can connect to it from MS Access

with
no
> > > > > problems):
> > > > >
> > > > > set cnn = server.createobject("adodb.connection")
> > > > > set rs = server.createobject("adodb.recordset")
> > > > > cnn.open "DSN=SYSTEM2"
> > > > >
> > > > > Help!
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Jul 19 '05 #7

P: n/a
Here is the error, it craps out on the line that contains my cnn.open (the
code is in my first post I think):

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link
failure. COMM RC=0x3
/d1main/fieldbulletin_detail.asp, line 6

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
You're right. It should in this case. Just for the hell of it, post
relevant code and the error/line number.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:uR**************@TK2MSFTNGP10.phx.gbl...
The DSN I have been using is a system DSN. In VB, I can get data back no
problem, but ASP is giving me hell. I have tried about 50 variations of a
connection string to no avail. I still think ASP should work just like in VB, but it doesn't. Aaarrrrgggghhhhh!!!!!!!

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Huh, how about that. Alright, with your DSN that you have setup, is
that
a
user DSN or system? Try creating a system DSN (and testing it) and see if that helps.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:Of**************@TK2MSFTNGP10.phx.gbl...
> Yes they are, I am actually using my desktop as a dev server. When I go into
> the ODBC admin I can see IBM Client Access under the drivers tab.
>
> "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> news:uA**************@tk2msftngp13.phx.gbl...
> > Are the IBM DB/2 drivers installed on the server though? It
doesn't sound
> > like it.
> >
> > Ray at work
> >
> > "mechweb" <me*****@yahoo.com> wrote in message
> > news:eO**************@TK2MSFTNGP10.phx.gbl...
> > > I am using IBM's client access software and have setup a DSN which works
> > via
> > > VB. When I try using the DSN-less connection string below, I get
> provider
> > > cannot be found.
> > >
> > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > news:ue**************@TK2MSFTNGP12.phx.gbl...
> > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > Provider=IBMDA400.DataSource.1;Persist Security Info=False;Data > > > > Source=YourAS400Name;
> > > >
> > > > Ray at work
> > > >
> > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > news:%2***************@TK2MSFTNGP12.phx.gbl...
> > > > > Do you have the DSN setup on the server? Do you have drivers > > installed?
> > > > >
> > > > > Ray at work
> > > > >
> > > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > > news:eU**************@tk2msftngp13.phx.gbl...
> > > > > > I am trying to connect to a DB2 database on an AS400 via

ASP.
On
> the
> > > > > server
> > > > > > I can connect fine using VB, but keep getting a communcation link
> > > > failure
> > > > > > when using the exact same code in ASP. Here is my code (I

know the
> > > AS400
> > > > > > ODBC DSN works ok because I can connect to it from MS Access with
> no
> > > > > > problems):
> > > > > >
> > > > > > set cnn = server.createobject("adodb.connection")
> > > > > > set rs = server.createobject("adodb.recordset")
> > > > > > cnn.open "DSN=SYSTEM2"
> > > > > >
> > > > > > Help!
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Jul 19 '05 #8

P: n/a
In my VB app, I was using ADO 2.6. I changed it to reference ADO 2.0 and it
still worked ok. This has to be some kind of IIs or ASP issue, but I am not
sure I'll find the answer.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:ev**************@TK2MSFTNGP12.phx.gbl...
Next suggestion

[re]Install the latest version of MDAC to verify that your odbcjt32.dll file is compatible with CA.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eu**************@TK2MSFTNGP12.phx.gbl...
Here is the error, it craps out on the line that contains my cnn.open (the
code is in my first post I think):

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link
failure. COMM RC=0x3
/d1main/fieldbulletin_detail.asp, line 6

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
You're right. It should in this case. Just for the hell of it, post
relevant code and the error/line number.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:uR**************@TK2MSFTNGP10.phx.gbl...
> The DSN I have been using is a system DSN. In VB, I can get data back
no > problem, but ASP is giving me hell. I have tried about 50 variations of
a
> connection string to no avail. I still think ASP should work just
like in
> VB, but it doesn't. Aaarrrrgggghhhhh!!!!!!!
>
> "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> news:%2***************@tk2msftngp13.phx.gbl...
> > Huh, how about that. Alright, with your DSN that you have setup,
is that
> a
> > user DSN or system? Try creating a system DSN (and testing it) and see
if
> > that helps.
> >
> > Ray at work
> >
> > "mechweb" <me*****@yahoo.com> wrote in message
> > news:Of**************@TK2MSFTNGP10.phx.gbl...
> > > Yes they are, I am actually using my desktop as a dev server.
When I go
> > into
> > > the ODBC admin I can see IBM Client Access under the drivers
tab. > > >
> > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > news:uA**************@tk2msftngp13.phx.gbl...
> > > > Are the IBM DB/2 drivers installed on the server though? It

doesn't
> > sound
> > > > like it.
> > > >
> > > > Ray at work
> > > >
> > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > news:eO**************@TK2MSFTNGP10.phx.gbl...
> > > > > I am using IBM's client access software and have setup a DSN

which
> > works
> > > > via
> > > > > VB. When I try using the DSN-less connection string below, I

get > > > provider
> > > > > cannot be found.
> > > > >
> > > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > > news:ue**************@TK2MSFTNGP12.phx.gbl...
> > > > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > > > Provider=IBMDA400.DataSource.1;Persist Security

Info=False;Data
> > > > > > Source=YourAS400Name;
> > > > > >
> > > > > > Ray at work
> > > > > >
> > > > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > > > news:%2***************@TK2MSFTNGP12.phx.gbl...
> > > > > > > Do you have the DSN setup on the server? Do you have

drivers
> > > > installed?
> > > > > > >
> > > > > > > Ray at work
> > > > > > >
> > > > > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > > > > news:eU**************@tk2msftngp13.phx.gbl...
> > > > > > > > I am trying to connect to a DB2 database on an AS400 via ASP.
> On
> > > the
> > > > > > > server
> > > > > > > > I can connect fine using VB, but keep getting a

communcation
> > link
> > > > > > failure
> > > > > > > > when using the exact same code in ASP. Here is my code (I know
> > the
> > > > > AS400
> > > > > > > > ODBC DSN works ok because I can connect to it from MS

Access
> > with
> > > no
> > > > > > > > problems):
> > > > > > > >
> > > > > > > > set cnn = server.createobject("adodb.connection")
> > > > > > > > set rs = server.createobject("adodb.recordset")
> > > > > > > > cnn.open "DSN=SYSTEM2"
> > > > > > > >
> > > > > > > > Help!
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Jul 19 '05 #9

P: n/a
I wouldn't be so sure that it's an ASP issue. IIRC, the comm link failures
always have to do with MDAC. Either that, or the as-database daemon isn't
running... STRHOSTSVR *ALL.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:O$**************@TK2MSFTNGP12.phx.gbl...
In my VB app, I was using ADO 2.6. I changed it to reference ADO 2.0 and it still worked ok. This has to be some kind of IIs or ASP issue, but I am not sure I'll find the answer.

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:ev**************@TK2MSFTNGP12.phx.gbl...
Next suggestion

[re]Install the latest version of MDAC to verify that your odbcjt32.dll file
is compatible with CA.

Ray at work

"mechweb" <me*****@yahoo.com> wrote in message
news:eu**************@TK2MSFTNGP12.phx.gbl...
Here is the error, it craps out on the line that contains my cnn.open (the code is in my first post I think):

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x3
/d1main/fieldbulletin_detail.asp, line 6

"Ray at <%=sLocation%>" <as*@me.forit> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
> You're right. It should in this case. Just for the hell of it, post > relevant code and the error/line number.
>
> Ray at work
>
> "mechweb" <me*****@yahoo.com> wrote in message
> news:uR**************@TK2MSFTNGP10.phx.gbl...
> > The DSN I have been using is a system DSN. In VB, I can get data back
no
> > problem, but ASP is giving me hell. I have tried about 50 variations
of
a
> > connection string to no avail. I still think ASP should work just like in
> > VB, but it doesn't. Aaarrrrgggghhhhh!!!!!!!
> >
> > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > news:%2***************@tk2msftngp13.phx.gbl...
> > > Huh, how about that. Alright, with your DSN that you have
setup, is > that
> > a
> > > user DSN or system? Try creating a system DSN (and testing it) and see
> if
> > > that helps.
> > >
> > > Ray at work
> > >
> > > "mechweb" <me*****@yahoo.com> wrote in message
> > > news:Of**************@TK2MSFTNGP10.phx.gbl...
> > > > Yes they are, I am actually using my desktop as a dev server. When
I
> go
> > > into
> > > > the ODBC admin I can see IBM Client Access under the drivers

tab. > > > >
> > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > news:uA**************@tk2msftngp13.phx.gbl...
> > > > > Are the IBM DB/2 drivers installed on the server though? It
doesn't
> > > sound
> > > > > like it.
> > > > >
> > > > > Ray at work
> > > > >
> > > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > > news:eO**************@TK2MSFTNGP10.phx.gbl...
> > > > > > I am using IBM's client access software and have setup a
DSN which
> > > works
> > > > > via
> > > > > > VB. When I try using the DSN-less connection string below, I get
> > > > provider
> > > > > > cannot be found.
> > > > > >
> > > > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > > > news:ue**************@TK2MSFTNGP12.phx.gbl...
> > > > > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > > > > Provider=IBMDA400.DataSource.1;Persist Security
Info=False;Data
> > > > > > > Source=YourAS400Name;
> > > > > > >
> > > > > > > Ray at work
> > > > > > >
> > > > > > > "Ray at <%=sLocation%>" <as*@me.forit> wrote in message
> > > > > > > news:%2***************@TK2MSFTNGP12.phx.gbl...
> > > > > > > > Do you have the DSN setup on the server? Do you have
drivers
> > > > > installed?
> > > > > > > >
> > > > > > > > Ray at work
> > > > > > > >
> > > > > > > > "mechweb" <me*****@yahoo.com> wrote in message
> > > > > > > > news:eU**************@tk2msftngp13.phx.gbl...
> > > > > > > > > I am trying to connect to a DB2 database on an AS400 via > ASP.
> > On
> > > > the
> > > > > > > > server
> > > > > > > > > I can connect fine using VB, but keep getting a
communcation
> > > link
> > > > > > > failure
> > > > > > > > > when using the exact same code in ASP. Here is my

code (I
> know
> > > the
> > > > > > AS400
> > > > > > > > > ODBC DSN works ok because I can connect to it from

MS Access
> > > with
> > > > no
> > > > > > > > > problems):
> > > > > > > > >
> > > > > > > > > set cnn = server.createobject("adodb.connection")
> > > > > > > > > set rs = server.createobject("adodb.recordset")
> > > > > > > > > cnn.open "DSN=SYSTEM2"
> > > > > > > > >
> > > > > > > > > Help!
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Jul 19 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.