469,963 Members | 2,108 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

setup access/win2k for internet use

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
2 2908
"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
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.

Similar topics

1 post views Thread by Tom Jones | last post: by
6 posts views Thread by Ed | last post: by
4 posts views Thread by Richard Shea | last post: by
7 posts views Thread by messagedog | last post: by
2 posts views Thread by Ravikanth[MVP] | last post: by
reply views Thread by Georg Scholz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.