Rob
|
| Posted: 06/20/2001, 2:20 PM |
|
Hi everyone,
I am wondering if someone did use CC for accessing AS/400 DB2 database? I am
having problem while using ODBC on client access for AS/400 while my site
profile works well with Access database. I have used same field lengths for
Tables and field names like in DB2 and I feel that it shall work. I was able
to access login-in area and it worked but when SQL was executed on next
page, it did not showed any record -
If SQL is different for DB2? Any suggestion would be highly appreciated.
Thanks.
Rob
|
|
|
 |
Paul
|
| Posted: 06/21/2001, 6:50 AM |
|
It's been a long time since I've used DB2 or AS/400 but if memory serves you
need to have CAE installed, and call your SQL through the SQLExecute
function. Beyond this the clouds are really forming.
Paul
Rob wrote in message <9gr42i$2sd$1@news.codecharge.com>...
>Hi everyone,
>
>I am wondering if someone did use CC for accessing AS/400 DB2 database? I
am
>having problem while using ODBC on client access for AS/400 while my site
>profile works well with Access database. I have used same field lengths for
>Tables and field names like in DB2 and I feel that it shall work. I was
able
>to access login-in area and it worked but when SQL was executed on next
>page, it did not showed any record -
>
>If SQL is different for DB2? Any suggestion would be highly appreciated.
>
>Thanks.
>
>Rob
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/21/2001, 6:55 AM |
|
I'm using OLE to connect.
Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
On my form, I specify the sql string.
Select * from library.database
I have been able to create a grid and populate it, but it fails when I try
to run the app.
The error is:
Error Type:
ADODB.Connection (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/AS400/Common.asp, line 23
I'm still working on this, if anyone can share how to resolve this, I would
be most appreciate.
Regards,
Frank
|
|
|
|
Frank Rocco
|
| Posted: 06/21/2001, 7:05 AM |
|
I now have it working.
I needed to change the provider string to:
"Provider=IBMDA400;Data Source=MySystem;"
HTH
Frank
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9gsucv$q54$1@news.codecharge.com...
> I'm using OLE to connect.
> Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
> Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
>
> On my form, I specify the sql string.
> Select * from library.database
>
> I have been able to create a grid and populate it, but it fails when I try
> to run the app.
> The error is:
> Error Type:
> ADODB.Connection (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /AS400/Common.asp, line 23
>
> I'm still working on this, if anyone can share how to resolve this, I
would
> be most appreciate.
>
> Regards,
> Frank
>
>
|
|
|
|
Rob
|
| Posted: 06/23/2001, 3:44 AM |
|
Hi Frank,
You means to say that library path has to be mentioned before the table
name, like Select * rgp040.Customer.CUSN03, rgp040.Customer.NAM03, .. ...
..., ... , ... WHERE rgp040.Customer.DESQ03 = rgp040.Orders.DESQ03 AND ...,
....
* Above rgp040 = Library name/ path
Customers and Orders = Table names
This means I have to use SQL statements in all my Pages in CC or in other
words, edit manually SQL statements created in ASP pages?
Last question; are you fully successful in selecting and updating data on
AS/400 using above technique? Did you find any performance issue?
Thanks and appreciate if you reply in detail.
Rob
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9gsucv$q54$1@news.codecharge.com...
> I'm using OLE to connect.
> Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
> Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
>
> On my form, I specify the sql string.
> Select * from library.database
>
> I have been able to create a grid and populate it, but it fails when I try
> to run the app.
> The error is:
> Error Type:
> ADODB.Connection (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /AS400/Common.asp, line 23
>
> I'm still working on this, if anyone can share how to resolve this, I
would
> be most appreciate.
>
> Regards,
> Frank
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/23/2001, 5:53 AM |
|
Hi Rob,
I was only testing this, so I will have to try some of the requests you
made.
If you is an ODBC driver, you can say what library or libraries you want in
the odbc configuration.
I'm new to the OLE way of doing this, so am still testing.
but library.database is the standard syntax for AS/400 SQL.
I'll test updating and if there is a way to specify a default library in OLE
DB.
HTH
Frank
"Rob" <rob@rhct.net> wrote in message
news:9h1ru4$i3q$1@news.codecharge.com...
> Hi Frank,
>
> You means to say that library path has to be mentioned before the table
> name, like Select * rgp040.Customer.CUSN03, rgp040.Customer.NAM03, .. ...
> .., ... , ... WHERE rgp040.Customer.DESQ03 = rgp040.Orders.DESQ03 AND
....,
> ...
>
> * Above rgp040 = Library name/ path
> Customers and Orders = Table names
>
> This means I have to use SQL statements in all my Pages in CC or in other
> words, edit manually SQL statements created in ASP pages?
>
> Last question; are you fully successful in selecting and updating data on
> AS/400 using above technique? Did you find any performance issue?
>
> Thanks and appreciate if you reply in detail.
>
> Rob
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9gsucv$q54$1@news.codecharge.com...
> > I'm using OLE to connect.
> > Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
> > Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
> >
> > On my form, I specify the sql string.
> > Select * from library.database
> >
> > I have been able to create a grid and populate it, but it fails when I
try
> > to run the app.
> > The error is:
> > Error Type:
> > ADODB.Connection (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> > /AS400/Common.asp, line 23
> >
> > I'm still working on this, if anyone can share how to resolve this, I
> would
> > be most appreciate.
> >
> > Regards,
> > Frank
> >
> >
>
>
|
|
|
|
Rob
|
| Posted: 06/23/2001, 11:41 AM |
|
Paul,
Can you tell how I can use SQLExecute while using CC? Sorry I am newbie and
that is why could not get your point. Your advise on this matter would be
highly appreciated.
Rob
"Paul" <paporter@visto.com> wrote in message
news:9gsu3f$q0q$1@news.codecharge.com...
> It's been a long time since I've used DB2 or AS/400 but if memory serves
you
> need to have CAE installed, and call your SQL through the SQLExecute
> function. Beyond this the clouds are really forming.
>
> Paul
> Rob wrote in message <9gr42i$2sd$1@news.codecharge.com>...
> >Hi everyone,
> >
> >I am wondering if someone did use CC for accessing AS/400 DB2 database? I
> am
> >having problem while using ODBC on client access for AS/400 while my site
> >profile works well with Access database. I have used same field lengths
for
> >Tables and field names like in DB2 and I feel that it shall work. I was
> able
> >to access login-in area and it worked but when SQL was executed on next
> >page, it did not showed any record -
> >
> >If SQL is different for DB2? Any suggestion would be highly appreciated.
> >
> >Thanks.
> >
> >Rob
> >
> >
>
>
|
|
|
|
Don Orrell
|
| Posted: 06/29/2001, 7:34 AM |
|
I can't get CodeCharge to work with a DB2 database. I tried the connection
string and SQL statement in Visual Basic and it works. I placed the
connection string in the database properties and the SQL in the SQL of the
Form Properties and get the following error:
SQL State: 42601, SQLCODE: -104
Thanks for any suggestions or help.
Don
dorrell@favoritenurese.com
"Rob" <rob@rhct.net> wrote in message
news:9h1ru4$i3q$1@news.codecharge.com...
> Hi Frank,
>
> You means to say that library path has to be mentioned before the table
> name, like Select * rgp040.Customer.CUSN03, rgp040.Customer.NAM03, .. ...
> .., ... , ... WHERE rgp040.Customer.DESQ03 = rgp040.Orders.DESQ03 AND
....,
> ...
>
> * Above rgp040 = Library name/ path
> Customers and Orders = Table names
>
> This means I have to use SQL statements in all my Pages in CC or in other
> words, edit manually SQL statements created in ASP pages?
>
> Last question; are you fully successful in selecting and updating data on
> AS/400 using above technique? Did you find any performance issue?
>
> Thanks and appreciate if you reply in detail.
>
> Rob
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9gsucv$q54$1@news.codecharge.com...
> > I'm using OLE to connect.
> > Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
> > Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
> >
> > On my form, I specify the sql string.
> > Select * from library.database
> >
> > I have been able to create a grid and populate it, but it fails when I
try
> > to run the app.
> > The error is:
> > Error Type:
> > ADODB.Connection (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> > /AS400/Common.asp, line 23
> >
> > I'm still working on this, if anyone can share how to resolve this, I
> would
> > be most appreciate.
> >
> > Regards,
> > Frank
> >
> >
>
>
|
|
|
|
Thierry B.
|
| Posted: 07/05/2001, 8:28 AM |
|
Hi,
I don't know for OLEDB, but with ODBC you HAVE TO add your library name in
your SQL statements IF YOU SPECIFY MORE THAN ONE IN YOUR ODBC SOURCE (
/Server tab/ Default library).
If you copy/paste the sql code from an access query (querying an attached
as/400 table), access always add the library name, but if your odbc sourve
has only one, you can remove it.
Hope this helps,
Thierry B.
"Rob" <rob@rhct.net> a écrit dans le messagenews:
9h1ru4$i3q$1@news.codecharge.com...
> Hi Frank,
>
> You means to say that library path has to be mentioned before the table
> name, like Select * rgp040.Customer.CUSN03, rgp040.Customer.NAM03, .. ...
> .., ... , ... WHERE rgp040.Customer.DESQ03 = rgp040.Orders.DESQ03 AND
....,
> ...
>
> * Above rgp040 = Library name/ path
> Customers and Orders = Table names
>
> This means I have to use SQL statements in all my Pages in CC or in other
> words, edit manually SQL statements created in ASP pages?
>
> Last question; are you fully successful in selecting and updating data on
> AS/400 using above technique? Did you find any performance issue?
>
> Thanks and appreciate if you reply in detail.
>
> Rob
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9gsucv$q54$1@news.codecharge.com...
> > I'm using OLE to connect.
> > Provider=IBMDA400.DataSource.1;Password="";User ID=USERID;Data
> > Source=SYSTEMNAME;Transport Product=Client Access;SSL=DEFAULT
> >
> > On my form, I specify the sql string.
> > Select * from library.database
> >
> > I have been able to create a grid and populate it, but it fails when I
try
> > to run the app.
> > The error is:
> > Error Type:
> > ADODB.Connection (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> > /AS400/Common.asp, line 23
> >
> > I'm still working on this, if anyone can share how to resolve this, I
> would
> > be most appreciate.
> >
> > Regards,
> > Frank
> >
> >
>
>
|
|
|
|
|
