Re: Thick client connection works, VB/ASP doesn't!
From: Mark Schupp (notvalid_at_email.net)
Date: 10/26/04
- Next message: Chad Scharf: "Too Many Include Files causing IIS 500 Error"
- Previous message: Naveen: "The call to Server.CreateObject failed while checking permissions."
- In reply to: UncleHarpoon: "Thick client connection works, VB/ASP doesn't!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 09:01:05 -0700
As others have pointed out this is a "traditional" asp newsgroup, not an
asp.net one. However, from your connection string it looks like you are
using named pipes to connect. Have you tried TCP/IP instead?
-- --Mark Schupp Head of Development Integrity eLearning www.ielearning.com "UncleHarpoon" <UncleHarpoon@discussions.microsoft.com> wrote in message news:4389F5BA-420B-4A0A-A5F5-F3A7D6396BF3@microsoft.com... > An asp application is attempting to log on to a database using the > SqlDataAdapter ADO. For some reason, the same connection strings that work > in > non-web applications are refused when the asp application attempts to > connect > with the same connection string. > > Sqlconnection.connectionstring = "User ID=user00;Password=pw00;Initial > Catalog=test_db;Data Source=np:\\.\pipe\sql\query" > > > Dim dt As New DataTable > Try > Dim query As String = "SELECT * from table" > Dim dataAdapt As New SqlDataAdapter(query,sqlConnection) > > dataAdapt.Fill(dt) > > Catch SQLex As SqlException > Throw SQLex > End Try > > > The solution that I am currently using is using the impersonate feature in > the web.config: > > <identity impersonate="true" userName="domain\username" password="pwd"/> > > -- > Don Glman, P.E., MCP > Sr. Software Engineer > Energy Systems Lab, Texas A&M
- Next message: Chad Scharf: "Too Many Include Files causing IIS 500 Error"
- Previous message: Naveen: "The call to Server.CreateObject failed while checking permissions."
- In reply to: UncleHarpoon: "Thick client connection works, VB/ASP doesn't!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
