Re: FP2003 fails to validate data connection

From: seeker (seeker_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 09:04:44 -0700

Thanks to everyone who helped with this problem. Microsoft advised an update of MDAC to 2.8, and the error went away. 

-- 
seeker
"MD Websunlimited" wrote:
> 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

  • Re: FP2003 fails to validate data connection
    ... The connection string is not correct or DSN are not correct. ... 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, ... Other apps I have written have no problem using these DSNs. ...
    (microsoft.public.frontpage.programming)
  • Re: Retrieving ODBC Settings Programmatically.
    ... SQLGetDataSources lets you retrieve information for all the DSNs on the ... If you're dealing with SQL Server, then look for the Database keyword in the ... connection string to get the database the connection will use. ...
    (microsoft.public.data.odbc)
  • Re: IIS does not support ASP on local machine
    ... You can check this in the IIS ... > "seeker" wrote in message ... >> Database Results Wizard Error ... If this continues, please contact your server ...
    (microsoft.public.frontpage.programming)
  • Re: Automatically create a system ODBC link
    ... For your case I think I would use dynamic DSNs, ... The only thing you will need to know is all the connection parameters you ... > cover in excess of 500 database server/instance combinations (not counting ...
    (microsoft.public.data.odbc)
  • Re: ODBC and DSN
    ... DSNs must exist on each workstation. ... >I have a database that will be on a server. ... > other types of databases and files on a server. ... > If I set up an ODBC connection on my computer, is it only good on my ...
    (microsoft.public.access.externaldata)
Loading