Re: FP2003 fails to validate data connection

From: MD Websunlimited (none_at_none.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 14:58:10 -0500

Hi Seeker,

The connection string is not correct or DSN are not correct. Correct it and it should work. 

-- 
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
"seeker" <seeker@discussions.microsoft.com> wrote in message news:16AF6811-C518-4CB4-8F75-B40FF0DC1A1D@microsoft.com...
> I am attempting to make a connection to a SQL Server 2000 database on my development computer.  The machine is running XP Pro with
IIS 5.1 and SQL Server 2000 both running.
>
> The FP2003 Database Results Wizard and Database Interface Wizard have no problem locating the active DSNs on the machine, but
cannot open them.  Other apps I have written have no problem using these DSNs.
>
> Here is the error I receive:
>
> Server error: Unable to connect to a database from the Web server using the connection string 'DSN=giradb;DRIVER={SQL Server}'.
>
> The following error message comes from the database driver software; it may appear in a different language depending on how the
driver is configured.
> -------------------------------------------------------
> The specified procedure could not be found.
>
> Source: ADO
> Number: -2147024769 (0x8007007f)
>
>
> This is a very difficult error to debug because the 'specified procedure' is not defined.
>
> Could anyone please shed some light on what the specific problem is?  It seems to be a bug in FP2003.
> -- 
> seeker

Relevant Pages

  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie question on SQL connection
    ... database on my developer machine. ... > to develop databases away from the live SQL server - that way in the ... > domain SQL Server. ... Does your connection string contain a typo? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.sqlserver.connect)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection String/Network Library
    ... The only reason I tend to think it's the connection string is that we've ... DSNs up until recently without problem. ... >> General Network Error on any page that connects to SQL Server. ...
    (microsoft.public.inetserver.asp.general)