Connecting to database

[Jim]

Hi Folks,

We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.

The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.

I assume that this intermediary computer would be whats called a SQL server?

If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?

Anyone?

Cheers

-Al

[Mark A]

"Jim" <bi******@hotmail.com> wrote in message
news:bt**********@lust.ihug.co.nz...

Hi Folks,

We have a DB2 database on a WAN at work. I want to access the database from some Visual Basic for Applications code that I have written at work.

The database itself is not directly accessable and as it was described to me is "buffered"
from the users by a second computer which passes on requests for data.

I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?

Anyone?

Cheers

-Al

More than likely it was a gateway machine in between the DB2 server and
clients. Unless there are some networking issues involved in the WAN, you
should be able to submit requests directly to the DB2 server if you are
given proper authorization. The client software required to perform this
depends on what platform the DB2 server is running on.

[Pete H]

Hi Jim;
what you're describing sounds like a DB2 Connect gateway server. From
an application perspective, it should look no different than any other
DB2 server, but it does take client requests and pass them on to other
(usually DB2 OS/390 or DB2 AS400/iSeries) DB2 servers.

Once you are given the normal DB2 client configuration for your shop
and a valid connection string to this DB2 Connect server, you should
be all set.

Pete H
ph******@MoshierIsland--NOSPAM--Group.com

"Jim" <bi******@hotmail.com> wrote in message news:<bt**********@lust.ihug.co.nz>...

Hi Folks,

We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.

The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.

I assume that this intermediary computer would be whats called a SQL server?

If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?

Anyone?

Cheers

-Al

[Jim]

Thanks for the replies guys.

Currently we can query the database via a webpage interface.

I have looked at the code behind the webpage and it consists of some
javascript.

I am guessing but it looks like the webpage sends the request to the
webserver
which I assume passes it to the SQL server.

Is it possible that the computer i work on cant talk to the sql server
directly?

I need to know where to go from here....

Cheers

-Al

"Pete H" <ph******@intellicare.com> wrote in message
news:d2**************************@posting.google.c om...

Hi Jim;
what you're describing sounds like a DB2 Connect gateway server. From
an application perspective, it should look no different than any other
DB2 server, but it does take client requests and pass them on to other
(usually DB2 OS/390 or DB2 AS400/iSeries) DB2 servers.

Once you are given the normal DB2 client configuration for your shop
and a valid connection string to this DB2 Connect server, you should
be all set.

Pete H
ph******@MoshierIsland--NOSPAM--Group.com

"Jim" <bi******@hotmail.com> wrote in message

news:<bt**********@lust.ihug.co.nz>...

Hi Folks,

We have a DB2 database on a WAN at work. I want to access the database from some Visual Basic for Applications code that I have written at work.

The database itself is not directly accessable and as it was described to me is "buffered"
from the users by a second computer which passes on requests for data.

I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?

Anyone?

Cheers

-Al

[Database Guy]

"Jim" <bi******@hotmail.com> wrote in message news:<bt**********@lust.ihug.co.nz>...

Thanks for the replies guys.

Currently we can query the database via a webpage interface.

I have looked at the code behind the webpage and it consists of some
javascript.

I am guessing but it looks like the webpage sends the request to the
webserver
which I assume passes it to the SQL server.

Is it possible that the computer i work on cant talk to the sql server
directly?

I need to know where to go from here....

Your web pages will be generated by a web server that presumably
resides on the so-called "SQL server". The web server will use JDBC to
access DB2 (or any other RDBMS), and JDBC (type 3 and 4) drivers don't
need any DB2 client software to be installed anywhere. So this could
equally apply to Java programs running on your own workstation.

ODBC on the other hand does require a DB2 Client to be installed.
This can either talk to DB2 UDB databases directly, or through a DB2
Connect gateway on some other server (especially if you want access to
mainframe DB2).

I think people will need more information to be able to give you a
less generalised answer.
DG

[Jim]

Thanks DG.

I will try to get a little more info about what is being run on the server
side.

-Al

"Database Guy" <db******@hotmail.com> wrote in message
news:7f**************************@posting.google.c om...

"Jim" <bi******@hotmail.com> wrote in message

news:<bt**********@lust.ihug.co.nz>...

Thanks for the replies guys.

Currently we can query the database via a webpage interface.

I have looked at the code behind the webpage and it consists of some
javascript.

I am guessing but it looks like the webpage sends the request to the
webserver
which I assume passes it to the SQL server.

Is it possible that the computer i work on cant talk to the sql server
directly?

I need to know where to go from here....

Your web pages will be generated by a web server that presumably
resides on the so-called "SQL server". The web server will use JDBC to
access DB2 (or any other RDBMS), and JDBC (type 3 and 4) drivers don't
need any DB2 client software to be installed anywhere. So this could
equally apply to Java programs running on your own workstation.

ODBC on the other hand does require a DB2 Client to be installed.
This can either talk to DB2 UDB databases directly, or through a DB2
Connect gateway on some other server (especially if you want access to
mainframe DB2).

I think people will need more information to be able to give you a
less generalised answer.
DG