Brian Gubb
|
| Posted: 11/19/2003, 2:25 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_00B5_01C3AEF4.6FB7B6F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I get this message every time I try to publish locally. Could someone =
please tell me how to setup IIS correctly, using XP Pro.
TIA Brian
Unable to establish connection to database.
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
General error: Invalid file dsn 'forcethree.com_access_forcethree.dsn'
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection =
settings or insufficient security set on your database folder or file.=20
For more details please refer to =
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518
------=_NextPart_000_00B5_01C3AEF4.6FB7B6F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I get this message every time I try to =
publish=20
locally. Could someone please tell me how to setup IIS correctly, using =
XP=20
Pro.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA Brian</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Unable to establish connection to=20
database.<BR>Error information:<BR>Microsoft OLE DB Provider for ODBC =
Drivers=20
(0x80004005)<BR>General error: Invalid file dsn=20
'forcethree.com_access_forcethree.dsn'<BR>Other possible cause of this=20
problem:<BR>The database cannot be opened, most likely due to incorrect=20
connection settings or insufficient security set on your database folder =
or=20
file. <BR>For more details please refer to <A=20
href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518=
">http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518</A></=
FONT></DIV></BODY></HTML>
------=_NextPart_000_00B5_01C3AEF4.6FB7B6F0--
|
|
|
 |
DonB
|
| Posted: 11/19/2003, 5:40 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0092_01C3AE78.C899FF70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
First get rid of the ODBC driver - use the OLEDB Driver for Access. I =
use the OLEDB driver because I could never get memo fields to work right =
with the ODBC driver.
Now to the real problem. Your webserver must open the Access database =
file with read/write access. This message indicates that these =
permissions have not been granted. I assume the dsn is fine since you =
were using it to work in the designer.
Check the folder permissions where the database is kept and grant the =
IIS account (usually that is "IUSR_" + the name of the computer) =
permission to write to that folder.
I have never used a "file" dsn to connect to the database, so I can't =
say if there are any issues with using a file dsn to connect. I always =
define a Connection String. I don't define the dsn in the ODBC admin =
tool, I put the information right into the CCS Connection object.
--=20
DonB
http://www.gotodon.com/ccbth
"Brian Gubb" <b.gubb@amcom.co.nz> wrote in message =
news:bpfgf0$qmi$1@news.codecharge.com...
I get this message every time I try to publish locally. Could someone =
please tell me how to setup IIS correctly, using XP Pro.
TIA Brian
Unable to establish connection to database.
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
General error: Invalid file dsn 'forcethree.com_access_forcethree.dsn'
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection =
settings or insufficient security set on your database folder or file.=20
For more details please refer to =
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518
------=_NextPart_000_0092_01C3AE78.C899FF70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>First get rid of the ODBC driver - use =
the OLEDB=20
Driver for Access. I use the OLEDB driver because I could never =
get memo=20
fields to work right with the ODBC driver.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Now to the real problem. Your =
webserver must=20
open the Access database file with read/write access. This message =
indicates that these permissions have not been granted. I assume =
the dsn=20
is fine since you were using it to work in the designer.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Check the folder permissions where the =
database is=20
kept and grant the IIS account (usually that is "IUSR_" + the name of =
the=20
computer) permission to write to that folder.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have never used a "file" =
dsn to=20
connect to the database, so I can't say if there are any issues with =
using a=20
file dsn to connect. I always define a Connection String. I =
don't=20
define the dsn in the ODBC admin tool, I put the information right into =
the CCS=20
Connection object.</FONT></DIV>
<DIV><BR>-- <BR>DonB</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://www.gotodon.com/ccbth">http://www.gotodon.com/ccbth</A></D=
IV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@amcom.co.nz">b.gubb@amcom.co.nz</A>> wrote in =
message=20
<A=20
=
href=3D"news:bpfgf0$qmi$1@news.codecharge.com">news:bpfgf0$qmi$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I get this message every time I try =
to publish=20
locally. Could someone please tell me how to setup IIS correctly, =
using XP=20
Pro.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA Brian</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Unable to establish connection to=20
database.<BR>Error information:<BR>Microsoft OLE DB Provider for ODBC =
Drivers=20
(0x80004005)<BR>General error: Invalid file dsn=20
'forcethree.com_access_forcethree.dsn'<BR>Other possible cause of this =
problem:<BR>The database cannot be opened, most likely due to =
incorrect=20
connection settings or insufficient security set on your database =
folder or=20
file. <BR>For more details please refer to <A=20
=
href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518=
">http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q306518</A></=
FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0092_01C3AE78.C899FF70--
|
|
|
|
|
