Access a DB2 database using ASP

[edgonz]

Is there a way to access a DB2 database on an AS/400 with ASP? I'd like to be able to have my users create queries on the web browser then execute those on a DB2 database on an AS/400 box.
Any ideas are greatly appreciated.


Edward.

 

[shaddow]

Set Connection = Server.CreateObject( "ADODB.Connection" )
Connection.Open "Driver={Microsoft dBase Driver (*.dbf)};DriverId=533;FIL=dBase 5.0;DBQ="&pathtofile+"\filename.dbf"&";ReadOnly=0;UID=admin;"

<%
Const adOpenStatic = 3
Const adUseClient = 3
Const adLockPessimistic = 2

set rs=server.CreateObject(&quot;ADODB.Recordset&quot

sub ExecuteSQL(byval cmd)
if rs.State=1 then rs.Close
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.LockType = adLockPessimistic
rs.Source = cmd
rs.ActiveConnection = Connection 'The record set needs to know what connection to use.
rs.Open
end sub

...

SQL=&quot;select * from MyDatabaseName&quot;
ExecuteSQL(SQL)
RecNo=rs.RecordCount
...

 

[shaddow]

Sorry there is an error
u have to use it without &quot;<%&quot;

 

[edgonz]

Shaddow,


Thanks for your reply. I must admint that I'm a beginner to ASP and I was wondering if there was some sample code I could use. Where would I put this code on the asp page?
The OS/400 programmer created a test DB called SAMPLEDB2 on the DEVLIB library and added some dummy data to play with. I imagine I can add that info in the DBQ= section, right?
I appreciate your help on this problem.

 

[shaddow]

U use Dbase database?
If this is'n work tell me and i send to u an sample...

 

[edgonz]

I use DB2 (IBM) on an AS/400 machine.
And it appears that the code is not working for me.

 

[shaddow]

What U use NT, 2000?
Can u use an Access database or SQL?

 

[edgonz]

I'm running IIS 4 on an NT 4 server. All SPs loaded.
I can use them, but I need to access the IBM DB2 database instead. My company's main DB system runs on our AS/400 and we use DB2 instead of MS-SQL.

 

[shaddow]

Try to create an DSN to the database and use this DSN to connect to the database...

 

[edgonz]

Ok, I'll try that. Thanks.

 

[dianal]

Hello,
As far as I know you are in trouble when trying to connect to DB2 from ASP.
See MSDN article

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvsgen/html/onlinebookset.asp

You will need
OLE DB Provider for DB2 (it seem not to be free) in order to access your database.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his/hh/his/db2oldb1_1276.asp

Or ODBC Driver for DB2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his/hh/his/db2odbc1_8jtu.asp

Wish you success!
D.

 

[edgonz]

Hmm...is there another way I can have access to DB2 data on an AS/400? Do you know if those ODBC drivers are free?

Thanks.

 

[dianal]

Hello,
Seems that MS OLE DB and ODBC drivers come with installation of SNA Server, which is not free.

http://www.microsoft.com/sna/productinfo/overview.asp

Try to look what IBM provides:

http://www.software.ibm.com/data/db2/db2connect

There is a DB2 Personal Developer's Edition which is free.

Even more links for ODBC drivers

http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm

(most of them have 30-90 days preview).

A gude for installing and configuring DB2 Clients

http://taurus.vcu.edu/db2/db2iy/db2iy03.htm

Success!
D.