By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

setup access/win2k for internet use

P: n/a
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine
i have an mdb on win2k adv server machine and want internet read/write to it
from both a non-windows, red hat, webserver using asp/vbscript and a win
xp/2000 machine with vb6.0/ado with or without odbc set up
how do you set up the win2k server machine and/or mdb???
i know enough that some application/service needs to be listening on some
port

so far i have the mdb on my test win2k webserver and can write to it from
asp files running on that server, no surprise here, its a local file on the
server
i can access the mdb from a vb6.0/ado client win2k machine on the same lan
as the server using odbc with a mapped network drive or connection string
with unc
the conn str unc works with the public ip addr but not domain name? ie
this works, ie i can read/write
\\111.222.333.444\share\dirpath\file.mdb however it doesn't work when truly
exteranl, see below error
but not this
\\domain.name\share\dirpath\file.mdb '[ms] [ms access odbc error] disk or
net work file error'


Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"bbxrider" <bb*******@comcast.net> wrote in message
news:ZTZfb.693132$uu5.113038@sccrnsc04...
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine i have an mdb on win2k adv server machine and want internet read/write to it from both a non-windows, red hat, webserver using asp/vbscript and a win
xp/2000 machine with vb6.0/ado with or without odbc set up
how do you set up the win2k server machine and/or mdb???
i know enough that some application/service needs to be listening on some
port

so far i have the mdb on my test win2k webserver and can write to it from
asp files running on that server, no surprise here, its a local file on the server
i can access the mdb from a vb6.0/ado client win2k machine on the same lan
as the server using odbc with a mapped network drive or connection string
with unc
the conn str unc works with the public ip addr but not domain name? ie
this works, ie i can read/write
\\111.222.333.444\share\dirpath\file.mdb however it doesn't work when truly exteranl, see below error
but not this
\\domain.name\share\dirpath\file.mdb '[ms] [ms access odbc error] disk or
net work file error'

This might not be the best group for your question - does this error come
from an ASP page or some VB code? If it's ASP, would you not use
Server.MapPath:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("file.mdb")
Nov 12 '05 #2

P: n/a
its from vb code, where i'm trying to get to the mdb file across the
internet.

i thought the server.mappath is for local file access when running asp for
file access on that same machine, that is no
problem, i have that now on my own test webserver

i am looking for file access both from vb pgm across internet and asp file
running on non windows machine also across internet
can seem to find an answer anywhere, perhaps it is a win2k networking
question more than access

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bl**********@sparta.btinternet.com...
"bbxrider" <bb*******@comcast.net> wrote in message
news:ZTZfb.693132$uu5.113038@sccrnsc04...
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine
i have an mdb on win2k adv server machine and want internet read/write to it
from both a non-windows, red hat, webserver using asp/vbscript and a win
xp/2000 machine with vb6.0/ado with or without odbc set up
how do you set up the win2k server machine and/or mdb???
i know enough that some application/service needs to be listening on

some port

so far i have the mdb on my test win2k webserver and can write to it from asp files running on that server, no surprise here, its a local file on

the
server
i can access the mdb from a vb6.0/ado client win2k machine on the same lan as the server using odbc with a mapped network drive or connection string with unc
the conn str unc works with the public ip addr but not domain name? ie
this works, ie i can read/write
\\111.222.333.444\share\dirpath\file.mdb however it doesn't work when

truly
exteranl, see below error
but not this
\\domain.name\share\dirpath\file.mdb '[ms] [ms access odbc error] disk or net work file error'

This might not be the best group for your question - does this error come
from an ASP page or some VB code? If it's ASP, would you not use
Server.MapPath:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("file.mdb")

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.