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.createob ject("adodb.con nection")
set rs = server.createob ject("adodb.rec ordset")
cnn.open "DSN=SYSTEM 2"
Help!
9  9581 
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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
set rs = server.createob ject("adodb.rec ordset")
cnn.open "DSN=SYSTEM 2"
Help!
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******** ******@TK2MSFTN GP12.phx.gbl... p.s. Try dsn-less. For IBM's CA drivers, use:
Provider=IBMDA4 00.DataSource.1 ;Persist Security Info=False;Data
Source=YourAS40 0Name;
Ray at work
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
set rs = server.createob ject("adodb.rec ordset")
cnn.open "DSN=SYSTEM 2"
Help!
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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl... p.s. Try dsn-less. For IBM's CA drivers, use:
Provider=IBMDA4 00.DataSource.1 ;Persist Security Info=False;Data
Source=YourAS40 0Name;
Ray at work
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > set rs = server.createob ject("adodb.rec ordset")
> > cnn.open "DSN=SYSTEM 2"
> >
> > Help!
> >
> >
>
>
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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> p.s. Try dsn-less. For IBM's CA drivers, use:
> Provider=IBMDA4 00.DataSource.1 ;Persist Security Info=False;Data
> Source=YourAS40 0Name;
>
> Ray at work
>
> "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > set rs = server.createob ject("adodb.rec ordset")
> > > cnn.open "DSN=SYSTEM 2"
> > >
> > > Help!
> > >
> > >
> >
> >
>
>
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. Aaarrrrgggghhhh h!!!!!!!
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** *******@tk2msft ngp13.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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> > p.s. Try dsn-less. For IBM's CA drivers, use:
> > Provider=IBMDA4 00.DataSource.1 ;Persist Security Info=False;Data
> > Source=YourAS40 0Name;
> >
> > Ray at work
> >
> > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > > set rs = server.createob ject("adodb.rec ordset")
> > > > cnn.open "DSN=SYSTEM 2"
> > > >
> > > > Help!
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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******** ******@TK2MSFTN GP10.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. Aaarrrrgggghhhh h!!!!!!!
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** *******@tk2msft ngp13.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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > Provider=IBMDA4 00.DataSource.1 ;Persist Security Info=False;Data
> > > Source=YourAS40 0Name;
> > >
> > > Ray at work
> > >
> > > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > > news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > > > set rs = server.createob ject("adodb.rec ordset")
> > > > > cnn.open "DSN=SYSTEM 2"
> > > > >
> > > > > Help!
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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_d etail.asp, line 6
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** ********@TK2MSF TNGP10.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******** ******@TK2MSFTN GP10.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. Aaarrrrgggghhhh h!!!!!!!
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** *******@tk2msft ngp13.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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > Provider=IBMDA4 00.DataSource.1 ;Persist Security
Info=False;Data > > > > Source=YourAS40 0Name;
> > > >
> > > > Ray at work
> > > >
> > > > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > > > news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > > > > set rs = server.createob ject("adodb.rec ordset")
> > > > > > cnn.open "DSN=SYSTEM 2"
> > > > > >
> > > > > > Help!
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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******** ******@TK2MSFTN GP12.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******** ******@TK2MSFTN GP12.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_d etail.asp, line 6
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** ********@TK2MSF TNGP10.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******** ******@TK2MSFTN GP10.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. Aaarrrrgggghhhh h!!!!!!!
>
> "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> news:%2******** *******@tk2msft ngp13.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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> > > > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > > > Provider=IBMDA4 00.DataSource.1 ;Persist Security
Info=False;Data > > > > > > Source=YourAS40 0Name;
> > > > > >
> > > > > > Ray at work
> > > > > >
> > > > > > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > > > > > news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > > > > > > set rs = server.createob ject("adodb.rec ordset")
> > > > > > > > cnn.open "DSN=SYSTEM 2"
> > > > > > > >
> > > > > > > > Help!
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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$******** ******@TK2MSFTN GP12.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******** ******@TK2MSFTN GP12.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******** ******@TK2MSFTN GP12.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_d etail.asp, line 6
"Ray at <%=sLocation% >" <as*@me.forit > wrote in message
news:%2******** ********@TK2MSF TNGP10.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******** ******@TK2MSFTN GP10.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. Aaarrrrgggghhhh h!!!!!!!
> >
> > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > news:%2******** *******@tk2msft ngp13.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******** ******@TK2MSFTN GP10.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******** ******@tk2msftn gp13.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******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP12.phx.gbl...
> > > > > > > p.s. Try dsn-less. For IBM's CA drivers, use:
> > > > > > > Provider=IBMDA4 00.DataSource.1 ;Persist Security
Info=False;Data
> > > > > > > Source=YourAS40 0Name;
> > > > > > >
> > > > > > > Ray at work
> > > > > > >
> > > > > > > "Ray at <%=sLocation% >" <as*@me.forit > wrote in message
> > > > > > > news:%2******** *******@TK2MSFT NGP12.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******** ******@tk2msftn gp13.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.createob ject("adodb.con nection")
> > > > > > > > > set rs = server.createob ject("adodb.rec ordset")
> > > > > > > > > cnn.open "DSN=SYSTEM 2"
> > > > > > > > >
> > > > > > > > > Help!
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: fn |
last post by:
Can anyone help me understand what it takes to define a Linked Server
connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server
or some other product or can I simply do it with the tools provided with
SQL Server 2000?
Any guidance would be very appreciated. Thanks.
Farid
|
by: Niyazi |
last post by:
Hi,
I have to retrieve a data from AS400 DB2 and after working with data I have
to export into one of existing Excel file.
I can connect into specific library in AS400 DB2 using AS400 Client-Access
v5.2 program using (in VB.NET) ODBC driver (DSN Name …) . I can retrieve
datam work on it using VB.NET and I can send into 'NEW' Excel file.
My first problem starts here:
|
by: alan_sec |
last post by:
Hi.
Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of
JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that
is installed on windows 2000?
I' m trying to access db2 from java aplication like this:
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Connection connection =
DriverManager.getConnection("jdbc:as400://hostname","user","password");
|
by: Matthew Wells |
last post by:
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN
EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR
THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.
Can someonne please tell me an ADO connection string to use to link an AS400
table to...
|
by: Sehboo |
last post by:
Hello,
we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access
that from my vb.net application. I don't know anything about AS400.
Is it possible to get data from tables and stored procedures?
can somebody give me the code which shows how to do that?
Thanks
| | |
by: Brad Allison |
last post by:
I posted this to the adonet newsgroup and was recommended to post here.
Thank you for any help:
Okay, I need a bit of advice. I have an ODBC data adapter being filled by
AS400 which is very slow. If I were they user I would think that the
computer locked and try to stop the program, reboot, whatever.
So because management is still "investingating" ways of getting a faster
connection from our primary AS400 (which will never go away)...
|
by: MadMan2004 |
last post by:
Hello all!
I'm having a problem with a project I'm working on and I'd like to ask
for anyone's input that might be helpful. I'm building a rather large
front-end application connecting to an AS400 for the back end database
and I'm experiencing slow response times when executing sql statements.
Some select statement response times are bad. Not all, but some. And
there doesn't seem to be a consistent factor in any of the sql
statements...
|
by: John |
last post by:
We are doing integration with an AS400 running websphere - webservices. When
the customer (AS400) calls the .Net webservice the customers java code
(every other request or so) throws the following exception. We are both
researching the possible cause of this. Any suggestions on the .Net side for
resolving this would be helpful.
John
java.io.IOException: Broken pipe.
at java.lang.Throwable.<init>(Throwable.java:195)
|
by: mortenol |
last post by:
Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database,
and I experience problem when I hit the "Create Package" button in
the "Data Link properties window".
I have understood that the packages need to be created, before I can
run any SQL on the DB2 base via SSIS(?).
Here are the steps that I have done before the problem arise:
1. In MS Visual Studios, I created a new project of type "Integration
Services".
2. On the...
|
by: Iain |
last post by:
Hi All
I am creating a database trigger to write details real time from tables
on one AS400 to another over our WAN. Is there such a concept as ODBC
connections on the AS400 to
perform this task and if so can anyone explain how I would configure
such a connection.
There will be a process on the receiving AS400 waiting to process the
data as soon as
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
