Re: FP2003 fails to validate data connection

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

Date: Tue, 20 Jul 2004 15:56:02 -0700

Actually the problem happens with any DSN I create. The connections test out OK in the ODBC manager, and FP2003 simply finds the DSN from the list that comes up, so I am not creating my own connection string.

The error comes from ADO, and references a procedure that it cannot find. Whether this is a missing procedure in ADO, in FP2003 or in SQL Server I cannot determine. The error number is no help to me.

I am thinking that perhaps I need to upgrade the MDAC version I am running, which is 2.7.

I would think that this is a very common error in FP2003, but so far everyone on this board is stumped!

What do you think? 

-- 
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

  • Balasan: RE: cant execute "use $database"
    ... I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO. ... I create 'myperl' as DSN from ODBC Administration Tools. ... Here is my connection string: ... Generally speaking, when you want to connect to a specific database, it ...
    (perl.dbi.users)
  • Balasan: RE: cant execute "use $database"
    ... I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO. ... I create 'myperl' as DSN from ODBC Administration Tools. ... Here is my connection string: ... Generally speaking, when you want to connect to a specific database, it ...
    (perl.dbi.users)
  • Re: Crystal Report
    ... pictures from the database, the ODBC connection doesn't work, but the OLE/DB ... I hate ODBC because it requires me to maintain the DSN. ...
    (microsoft.public.vb.crystal)
  • Re: Linking to back end on a web server ?
    ... When I do the File--Get External Data and select the DSN, ... "You cannot use ODBC to import from, export to, or link an external ... Microsoft Jet or ISAM database table to your database. ... that DSN-based connection to a DSN-less connection. ...
    (microsoft.public.access.externaldata)
  • Re: How to Upgrade SQL back end of Access linked tables.
    ... If the file's extension is ADP then this is where your error is: ... you directly connect to a SQL-Server and this connection is using ... so there is no notion of DSN or DSN-Less ... dsn-less connection to SQL Server? ...
    (microsoft.public.access.externaldata)