iis web folder

thanks for the reply, the odbc connection limitations are not clear to me at
all
so is there no way to connect over internet using an odbc connection??
i tried, i think, all the ways to put a domain name or public ip into a unc
but nothing is accepted

the 'add network place wizard' indicates you can use a http url in the
examples and it does let me add one
but its functionality seems limited to something like windows explorer
browsing, i.e. can open the folder and access files from windows explorer
but if i select that 'network place' when setting up the odbc connection it
just keeps the
'ok' button greyed out.


"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:blegag$iq12@kcweb01.netnews.att.com...
 > "bbxrider" <bbxrider RemoveThis @comcast.net> wrote in message
 > news:e3Xdzz5hDHA.1172@TK2MSFTNGP09.phx.gbl...
  > > win2k adv server, iis5.0, access2000
  > > trying to create a 'web' folder where i can put a mdb that i can get to
 > with
  > > an odbc connection
  > > what i have tried
  > > 1.create a virtual website=web1 (i have web pages here that i can
  > > access)(mydomain.com/web1/web.htm)
  > > 2, create a virtual directory in the above website where the .mdb file
is
  > > located, this dir has read + write permissions and just anonymous access
 > for
  > > now, directory alias is 'web1data'
  > >
  > > when i go to create the odbc connection on a 'client' machine and give
the
  > > location to be a 'network place',
  > > <a style='text-decoration: underline;' href="http://mydomain.com/web1data/," target="_blank">http://mydomain.com/web1data/,</a> first i got prompted for user/pwd and
gave
 > it
  > > a admin acct, it seems to accept it, then i get a new instance of IE
with
  > > the address displayed being <a style='text-decoration: underline;' href="http://mydomain.com/web1data/," target="_blank">http://mydomain.com/web1data/,</a> its an empty
  > > page, but thats it, and am left with the odbc connection ready to pick a
  > > local file like i had never even specified the connection to be a
'network
  > > folder' or 'network place'
  > >
  > > anybody follow this? and had experience with this?
 >
 > You need to specify a local or UNC path. You cannot use an HTTP URL as
the
 > path to the database.
 >
 > --
 > Tom Kaminski IIS MVP
 > <a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running
IIS
<font color=purple> > <a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/</font" target="_blank">http://mvp.support.microsoft.com/</font</a>>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/</font" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</font</a>>
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: iis web folder 

"bbxrider" <bbxrider DeleteThis @comcast.net> wrote in message
news:uC8cyZViDHA.3204@TK2MSFTNGP11.phx.gbl...
 > thanks for the reply, the odbc connection limitations are not clear to me
at
 > all
 > so is there no way to connect over internet using an odbc connection??
 > i tried, i think, all the ways to put a domain name or public ip into a
unc
 > but nothing is accepted
 >
 > the 'add network place wizard' indicates you can use a http url in the
 > examples and it does let me add one
 > but its functionality seems limited to something like windows explorer
 > browsing, i.e. can open the folder and access files from windows explorer
 > but if i select that 'network place' when setting up the odbc connection
it
 > just keeps the
 > 'ok' button greyed out.

That's right, you can only use a local (C:\database\file.mdb) or UNC
(\\servername\sharename\file.mdb) path for database connections. A UNC will
work over the internet provided that you give the server IP or FQDN as the
servername and there's an appropriate Windows share setup (and there are no
firewalls, etc involved). An HTTP URL path will not work.

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: iis web folder