vb.net dll

[Guest]

I am new to using .net. I am told that I need to setup a config file that
will be accessed by a VB.net dll. This vb.net dll will be setup to run every
5 to 10 minutes by a timer that is coded into the vb.net application.
A user will submit a request to obtain data from a HP mainframe.

This web config file needs to be able to do the following:

1. The user will submit the request to a sql server 2000 database (that
resides on a different that where the vb.net application will be running).
2.. The vb.net code will that submit the request for data to the hp
mainframe by using http and xml.

Thus my questions are:

1. How do you setup a connection and retrieve data from the sql server 2000
database that resides with the company's intranet? This will somehow need to
include a connection object and statements oh how to connect to the SQL
server 2000 database. The user name and password are suppose to be passed to
the sql server as part of the connection string.
2. How would I request to the HP mainframe using soap, http, and xml to wrap
up the request?

Thanks!

 

[Guest]

Hi,

Take a look at web services
http://msdn.microsoft.com/webservices/understanding/webservicebasics/default.aspx

SQL server data acces
http://msdn.microsoft.com/library/d...ystemdatasqlclientsqlconnectionclasstopic.asp

http://msdn.microsoft.com/library/d...stemdatasqlclientsqldataadapterclasstopic.asp

Ken

 

[Cor Ligthert]

Wendy,

In addition to Ken's link see this nice walkthrough,

http://msdn.microsoft.com/library/d...atingDistributedWebApplicationWalkthrough.asp

I hope this helps a little bit?

Cor