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!
9  9558 
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!
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!
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!
> >
> >
>
>
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!
> > >
> > >
> >
> >
>
>
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!
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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!
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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!
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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!
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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!
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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...
|
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...
|
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...
|
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...
|
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...
| | |
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
| | |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
|
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...
|
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...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
