Re: ADO works ADO.NET does

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Patrice (nobody_at_nowhere.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 11:41:21 +0100

Try SQL profiler to check the user name is the one you expect... You could
also retrive the DB name, the user name instead of calling the stroed proc
to make sure you are in the expected context...

Patrice 

-- 
"resolutionsnet" <resolutionsnet@discussions.microsoft.com> a écrit dans le
message de news:021D4193-09BF-4A5E-9D10-1DF92E8DC739@microsoft.com...
> I have a strange issue and wondered if anyone could shed some light on the
> situation.
>
> I have two applications (sitting on web server A), one is a VB website
using
> ADO and one is a VB.NET using ADO.NET. They both connect to the same SQL
> Server, with the same user id and password. The VB application can connect
> and execute stored procedure X, but when the ADO.NET application tries it
> receives a SQL Server does not exist error message. These two application
do
> exactly the thing, just call one stored procedure. I have gone through
> various DSN settings, but none work. Even if I bring down the applications
to
> my server, the same results happen.
>
> Any Ideas?
>

Relevant Pages

  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)