Martin Reid
mwp.reid at qub.ac.uk
Tue Aug 5 14:39:36 CDT 2003
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\path\db.mdb;" & _
"Jet OLEDB:System Database=System.mdw", _
"Username", "Password"
If u have a workgroup
Is it a Jet 4 DB as well
Martin
----- Original Message -----
From: "Erwin Craps" <Erwin.Craps at ithelps.be>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, August 05, 2003 12:30 PM
Subject: RE: [AccessD] mdb in dmz
> I also once had the problem but I can remember if only with an ODBC
> config or ADO.
> I think it was ODBC. The prob is that access to the workgroup file (and
> dir due to ldb file) needs to be everyone R/W .
>
>
> -----Original Message-----
> From: Jim DeMarco [mailto:Jdemarco at hshhp.org]
> Sent: Tuesday, August 05, 2003 9:26 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] mdb in dmz
>
>
> Yes I did but I'm going to double check that anyway. Your referring to
> the folder the mdb is in as well as the file.
>
> Thanks,
>
> Jim DeMarco
>
>
>
> -----Original Message-----
> From: Erwin Craps [mailto:Erwin.Craps at ithelps.be]
> Sent: Tuesday, August 05, 2003 3:21 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] mdb in dmz
>
>
> Did you check NTFS permissions it they are set to everyone R/W? on the
> whole dir, not only the file. Note that Jet needs to create a ldb file.
>
>
> Erwin
>
>
>
> -----Original Message-----
> From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
> Sent: Tuesday, August 05, 2003 8:20 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] mdb in dmz
>
>
> Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=c:\somepath\myDb.mdb;" & _
> "User Id=admin;" & _
> "Password="
> Try that
>
> Martin
>
>
> ----- Original Message -----
> From: "Jim DeMarco" <Jdemarco at hshhp.org>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, August 05, 2003 11:02 AM
> Subject: RE: [AccessD] mdb in dmz
>
>
> > Looks like everything is going over port 80. The real drag is I can't
>
> > be
> sure it's even a hardware problem. We simplified the code to this (it's
> ASP/VBScript so no data types,etc.):
> >
> > <snip>
> > dim connectstring
> > dim cnn
> > dim dbpath
> >
> > dbpath = "D:\db\HshhpTips.mdb"
> > connectstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & >
> > dbpath
> >
> > Set cnn = Server.CreateObject("ADODB.Connection")
> > 'cnn.open connectstring
> >
> > Response.Write "testing"
> > </snip>
> >
> > The code runs if we leave the cnn.open line commented out but when we
> > put
> it back we now get a page not found error. Works fine on our dev
> machine of course. I would think if it was a data access problem the
> code would bail on the CreateObject call. Server's running Win2K BTW.
> >
> > Jim DeMarco
> >
> >
> >
> > -----Original Message-----
> > From: Jim Dettman [mailto:jimdettman at earthlink.net]
> > Sent: Tuesday, August 05, 2003 12:52 PM
> > To: Access Developers discussion and problem solving
> > Subject: RE: [AccessD] mdb in dmz
> >
> >
> > Jim,
> >
> > <<Can anyone point me in the right direction?>>
> >
> > Check the Firewall's log. It will show the IP address of the web
> server,
> > whether it was TCP or UDP packet, and the port it was trying to use.
> >
> > Jim Dettman
> > President,
> > Online Computer Services of WNY, Inc.
> > (315) 699-3443
> > jimdettman at earthlink.net
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco
> > Sent: Tuesday, August 05, 2003 10:58 AM
> > To: Access Developers discussion and problem solving
> > Subject: RE: [AccessD] mdb in dmz
> >
> >
> > Thanks Frank (where'd you find that domain on your e-mail address??).
> >
> > I searched msdn and found this list of Port Assignments for Common
> Services
> >
> (http://www.microsoft.com/windows2000/techinfo/reskit/samplechapters/cnf
> c/cn
> > fc_por_simw.asp - watch for wrapping). None seems to be what I'm
> > looking (AFAICT anyway). Can anyone point me in the right direction?
> >
> > Thanks,
> >
> > Jim DeMarco
> >
> > -----Original Message-----
> > From: Frank Tanner III [mailto:pctech at mybellybutton.com]
> > Sent: Tuesday, August 05, 2003 10:45 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] mdb in dmz
> >
> >
> > I'm not sure what tcp/udp port(s) that Jet and OLEdb
> > use, but do you have those allowed to pass from the
> > DMZ to wherever it needs to go? i.e. the internal LAN
> > and the external Internet.
> >
> > Usually DMZs are configured to ONLY allow the ports necessary, such as
>
> > HTTP, HTTPS, POP3, SMTP, etc.
> >
> > --- Jim DeMarco <Jdemarco at hshhp.org> wrote:
> > > List,
> > >
> > > We just went live with our web site
> > > (http://www.hshhp.org) but had to remove a feature
> > > that displays health tips. The tips are stored in
> > > an A97 mdb but we get an "unspecified error" when
> > > hitting the page. The db is on the web server box.
> > > The server is behind the firewall in the DMZ. Does
> > > anyone know if the DMZ is an issue when trying to
> > > hit an mdb? We're using the OleDB provider for Jet
> > > 4.0. I ran comcheck and we've got that version
> > > installed. IIS 5.0 as well.
> > >
> > > TIA,
> > >
> > > Jim DeMarco
> > > Director of Product Development
> > > HealthSource/Hudson Health Plan
> > >
> > >
> > >
> >
> ************************************************************************
> ****
> > *******
> > > "This electronic message is intended to be for the
> > > use only of the named recipient, and may contain information from
> > > Hudson Health Plan (HHP) that is confidential or privileged. If you
>
> > > are not the intended recipient, you are hereby notified that any
> > > disclosure, copying, distribution or use of the contents of this
> > > message is strictly prohibited. If you have received this message
> > > in error or are not the named recipient, please notify us
> > > immediately, either by contacting the sender at the electronic
> > > mail address noted above or calling HHP at (914)
> > > 631-1611. If you are not the intended recipient,
> > > please do not forward this email to anyone, and
> > > delete and destroy all copies of this message.
> > > Thank You".
> > >
> >
> ************************************************************************
> ****
> > *******
> > >
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> ************************************************************************
> ****
> > *******
> > "This electronic message is intended to be for the use only of the
> named
> > recipient, and may contain information from Hudson Health Plan (HHP)
> that
> is
> > confidential or privileged. If you are not the intended recipient,
> you
> are
> > hereby notified that any disclosure, copying, distribution or use of
> the
> > contents of this message is strictly prohibited. If you have received
> this
> > message in error or are not the named recipient, please notify us
> > immediately, either by contacting the sender at the electronic mail
> address
> > noted above or calling HHP at (914) 631-1611. If you are not the
> intended
> > recipient, please do not forward this email to anyone, and delete and
> > destroy all copies of this message. Thank You".
> >
> ************************************************************************
> ****
> > *******
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> ************************************************************************
> ****
> *******
> > "This electronic message is intended to be for the use only of the
> named
> recipient, and may contain information from Hudson Health Plan (HHP)
> that is confidential or privileged. If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution or use of the contents of this message is strictly
> prohibited. If you have received this message in error or are not the
> named recipient, please notify us immediately, either by contacting the
> sender at the electronic mail address noted above or calling HHP at
> (914) 631-1611. If you are not the intended recipient, please do not
> forward this email to anyone, and delete and destroy all copies of this
> message. Thank You".
> >
> ************************************************************************
> ****
> *******
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> ************************************************************************
> ***********
> "This electronic message is intended to be for the use only of the named
> recipient, and may contain information from Hudson Health Plan (HHP)
> that is confidential or privileged. If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution or use of the contents of this message is strictly
> prohibited. If you have received this message in error or are not the
> named recipient, please notify us immediately, either by contacting the
> sender at the electronic mail address noted above or calling HHP at
> (914) 631-1611. If you are not the intended recipient, please do not
> forward this email to anyone, and delete and destroy all copies of this
> message. Thank You".
> ************************************************************************
> ***********
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>