ADO works ADO.NET does

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

From: resolutionsnet (resolutionsnet_at_discussions.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 01:33:06 -0800

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: Missing fields in temp tables causes errors in SQL 2000 but 20
    ... took a walk down memory lane and reloaded SQL Server 2000 BOL and found the ... Deferred Name Resolution can only be used when you reference nonexistent ... All other objects must exist at the time the stored procedure ... SQL Server DBA in Sacramento, ...
    (microsoft.public.sqlserver.programming)
  • Re: Novice question
    ... SQL Server is a product that implements the specification of a relational ... database management system. ... applications can be built using the features of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I develop both applications and databases. ... Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. ... and put it into a stored procedure? ... By contrast a procedure is a server side extension of your client application. ...
    (comp.databases.ms-sqlserver)
  • Re: Access Control Best Practices for shared hosting seem at odds with Web Site Starters
    ... the full context of the bullet I quoted appears to be the HTTP POST ... Do not allow anonymous user to have write permission. ... content to the server, then they can write anything onto the server. ... More secure alternatives are applications that store ...
    (microsoft.public.inetserver.iis.security)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)