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
-AlYou need to ask whoever is administering your servers what technology is
used for accessing the DB2 database. Microsoft has a product called Host
Integration Server which can connect to DB2 systems. It is also possible to
link Microsoft SQLServer to external data sources such as DB2, but without
more information about what system you have in place it's difficult to give
a useful answer to your question.
Assuming you are provided with an OLEDB or ODBC connection to the database
you can use ADO to access your data from within Visual Basic.
http://msdn.microsoft.com/library/d.../>
rtpage1.asp
http://msdn.microsoft.com/library/d...t_oledb-db2.asp
To do this you'll need information such as the provider name, server name,
database name, user name and password. Your system administrator should be
able to supply that information.
(cross-postings removed)
David Portas
--
Please reply only to the newsgroup
--|||Thanks for the reply.
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
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:ereU30F0DHA.2308@.TK2MSFTNGP11.phx.gbl...
quote:
> You need to ask whoever is administering your servers what technology is
> used for accessing the DB2 database. Microsoft has a product called Host
> Integration Server which can connect to DB2 systems. It is also possible
to
quote:
> link Microsoft SQLServer to external data sources such as DB2, but without
> more information about what system you have in place it's difficult to
give
quote:
> a useful answer to your question.
> Assuming you are provided with an OLEDB or ODBC connection to the database
> you can use ADO to access your data from within Visual Basic.
>
http://msdn.microsoft.com/library/d...ostartpage1.asp[QUOT
E]
>[/QUOTE]
http://msdn.microsoft.com/library/d...t_oledb-db2.asp[
QUOTE]
> To do this you'll need information such as the provider name, server name,
> database name, user name and password. Your system administrator should be
> able to supply that information.
>
> (cross-postings removed)
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>[/QUOTE]
No comments:
Post a Comment