FP2003 cannot make a database connection

G

gr8faith

Hi;

I am in the process of learning to use FP2003 and
I'm trying to make a connection to the sample nwind database , when I do
this error appears:

***
Server error: Unable to connect to a database from the Web server using the
connection string 'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
Call was rejected by callee. (ADODB.Connection)

Source: ADO
Number: -2147418111 (0x80010001)

My system is Using WinXP Sp2
Office 2003 suite
4Gb RAM
3Ghz Intel processor

Any help is appreciated; TIA
 
S

Stefan B Rusynko

Are you running / testing that in a server based web like localhost or an online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database , when I do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server using the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver software; it may
| appear in a different language depending on how the driver is configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 
G

gr8faith

No, just on the local machine (localhost?) Oh, it needs to be on IIS! ok but
what components does IIS need to support access? We have installed asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page all i get
is "Database Results Wizard Error"
 
K

Kathleen Anderson [MVP - FrontPage]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
No, just on the local machine (localhost?) Oh, it needs to be on IIS! ok
but
what components does IIS need to support access? We have installed asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page all i
get
is "Database Results Wizard Error"



Stefan B Rusynko said:
Are you running / testing that in a server based web like localhost or an
online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database , when I
do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server using
the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver software; it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 
G

gr8faith

Thanks for that tidbit! here is the returned error:
***
Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd40 Thread 0x10e4
DBC 0xcb7744 Jet'.
***
I am thinking this to be a regkey on the server with a permission issue?

-Jb

Kathleen Anderson said:
To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
No, just on the local machine (localhost?) Oh, it needs to be on IIS! ok
but
what components does IIS need to support access? We have installed asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page all i
get
is "Database Results Wizard Error"



Stefan B Rusynko said:
Are you running / testing that in a server based web like localhost or an
online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database , when I
do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server using
the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver software; it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 
K

Kathleen Anderson [MVP - FrontPage]

Jb:
Is this on your local machine? Try adding the Internet Guest Account
IUSR_yourmachinename to the Temp folder under Windows and give it full
control or change permissions.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
Thanks for that tidbit! here is the returned error:
***
Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd40 Thread 0x10e4
DBC 0xcb7744 Jet'.
***
I am thinking this to be a regkey on the server with a permission issue?

-Jb

Kathleen Anderson said:
To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
No, just on the local machine (localhost?) Oh, it needs to be on IIS!
ok
but
what components does IIS need to support access? We have installed
asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page all
i
get
is "Database Results Wizard Error"



:

Are you running / testing that in a server based web like localhost or
an
online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:

http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database , when
I
do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server
using
the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver software;
it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 
G

gr8faith

KA;
It's on the server, I did the security change on the server (my web root
folder however is not on the default c:\inetpub). The security change did not
work on the C:\%systemroot%\temp folder on the server. I'm not sure were the
temporary stuff gets stored on the server.

Btw; I appreciate you following this through.
-JB


Kathleen Anderson said:
Jb:
Is this on your local machine? Try adding the Internet Guest Account
IUSR_yourmachinename to the Temp folder under Windows and give it full
control or change permissions.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
Thanks for that tidbit! here is the returned error:
***
Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd40 Thread 0x10e4
DBC 0xcb7744 Jet'.
***
I am thinking this to be a regkey on the server with a permission issue?

-Jb

Kathleen Anderson said:
To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




No, just on the local machine (localhost?) Oh, it needs to be on IIS!
ok
but
what components does IIS need to support access? We have installed
asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page all
i
get
is "Database Results Wizard Error"



:

Are you running / testing that in a server based web like localhost or
an
online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:

http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database , when
I
do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server
using
the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver software;
it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 
K

Kathleen Anderson [MVP - FrontPage]

Well, I only suggested it because I just had a similar problem with XP
Pro/IIS 5.1 on a new laptop. Why don't you try posting to
microsoft.public.inetserver.iis?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


gr8faith said:
KA;
It's on the server, I did the security change on the server (my web root
folder however is not on the default c:\inetpub). The security change did
not
work on the C:\%systemroot%\temp folder on the server. I'm not sure were
the
temporary stuff gets stored on the server.

Btw; I appreciate you following this through.
-JB


Kathleen Anderson said:
Jb:
Is this on your local machine? Try adding the Internet Guest Account
IUSR_yourmachinename to the Temp folder under Windows and give it full
control or change permissions.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




gr8faith said:
Thanks for that tidbit! here is the returned error:
***
Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd40 Thread
0x10e4
DBC 0xcb7744 Jet'.
***
I am thinking this to be a regkey on the server with a permission
issue?

-Jb

:

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




No, just on the local machine (localhost?) Oh, it needs to be on
IIS!
ok
but
what components does IIS need to support access? We have installed
asp.net
2.0 and frontpage extensions 2002. I put it up on the server and the
connection worked ( thanks!) but now when I look at a results page
all
i
get
is "Database Results Wizard Error"



:

Are you running / testing that in a server based web like localhost
or
an
online hosted server that supports Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:

http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I am in the process of learning to use FP2003 and
| I'm trying to make a connection to the sample nwind database ,
when
I
do
| this error appears:
|
| ***
| Server error: Unable to connect to a database from the Web server
using
the
| connection string 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.
|
| The following error message comes from the database driver
software;
it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| Call was rejected by callee. (ADODB.Connection)
|
| Source: ADO
| Number: -2147418111 (0x80010001)
|
| My system is Using WinXP Sp2
| Office 2003 suite
| 4Gb RAM
| 3Ghz Intel processor
|
| Any help is appreciated; TIA
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top