RE: connection to ado.net object

From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 03/25/05 

Date: Fri, 25 Mar 2005 06:09:04 -0800

Answered in your other thread "communicating to 2 databases". 

---
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Wendy Elizabeth" wrote:
> 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!

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using SQl to store aspx pages and memory problems
    ... I've seen classic ASP applications design this way that work ... database isn't some sort of magic pixie dust that solves all problems. ... > the memory increases - the slowness of the request could be dealt with by ... >> takes to get the page from SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)