|
 |
asp_database_setup thread: How do I connect to an Access db across the internet
Message #1 by Eva Jaatmaa <eva.j@c...> on Thu, 12 Jul 2001 12:18:50 -0700
|
|
Good morning,
I am struggling with a problem that has occured because I cannot connect
and work with data on the WebServer (and my ISP cannot solve it)
How do I write a connection string to open and work with a database on a
remote webserver? (The connection string has to (I guess) include the
URL to the server)
I am using asp, vb, and the database is MS Access.
Thankful for any ideas
Eva Jaatmaa
PS The complete application is -
1. I have data entered into a MS Access data base
(residing on the Web werver - that is remote and I have no real control,
I have had my ISP tch setup system DSNs for all my work with connecting
to the db files)
2. Data is transfered, edited withing the Access database and moved to a
Access table for later transfer
3. The last step is transferring the data fropm the Access table to a
Paradox table (as for now this Paradox table also resides on the Wevserver)
4. I download the Paradox file (FTP) and merge in into an application I
have locally.
THE PROBLEM is the Paradox, transfer and connection does not work on the
Web Server, and my ISp cannot resolve it. So my idea now is that I get
the Access data over to my (local) machine - and I do the transfer here
(the application works on my Win2000, IIS machine)
Thanks again - for your time
Where will I find replies if there are any?????
Eva
Message #2 by "Drew, Ron" <RDrew@B...> on Thu, 12 Jul 2001 14:19:40 -0400
|
|
Data Source must be using MapPath to take a virtual path and convert it to a
physical path or just specify the physical path...as an example
dim cnDB
set cnDB = Server.CreateObject("ADODB.Connection")
sQryConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\InetPub\wwwroot\mydirectory\myaccess.mdb;" &
_
"User Id=admin;" & _
"Password=;"
cnDB.CursorLocation =adUseClient
cnDB.Open (sQryConn )
-----Original Message-----
From: Eva Jaatmaa [mailto:eva.j@c...]
Sent: Thursday, July 12, 2001 3:19 PM
To: ASP Database Setup
Subject: [asp_database_setup] How do I connect to an Access db across
the internet
Good morning,
I am struggling with a problem that has occured because I cannot connect
and work with data on the WebServer (and my ISP cannot solve it)
How do I write a connection string to open and work with a database on a
remote webserver? (The connection string has to (I guess) include the
URL to the server)
I am using asp, vb, and the database is MS Access.
Thankful for any ideas
Eva Jaatmaa
PS The complete application is -
1. I have data entered into a MS Access data base
(residing on the Web werver - that is remote and I have no real control,
I have had my ISP tch setup system DSNs for all my work with connecting
to the db files)
2. Data is transfered, edited withing the Access database and moved to a
Access table for later transfer
3. The last step is transferring the data fropm the Access table to a
Paradox table (as for now this Paradox table also resides on the Wevserver)
4. I download the Paradox file (FTP) and merge in into an application I
have locally.
THE PROBLEM is the Paradox, transfer and connection does not work on the
Web Server, and my ISp cannot resolve it. So my idea now is that I get
the Access data over to my (local) machine - and I do the transfer here
(the application works on my Win2000, IIS machine)
Thanks again - for your time
Where will I find replies if there are any?????
Eva
Message #3 by "Eva Jaatmaa" <eva.j@c...> on Sat, 14 Jul 2001 18:36:59
|
|
My question continues -
If I have the Asp document on my machine and I need to connect to the
database on the WebServer how would the Data source look - can I somehow
use something like "http://www.thewebserver/.... ..... .....".?
Eva
> Data Source must be using MapPath to take a virtual path and convert it to a
> physical path or just specify the physical path...as an example
> dim cnDB
> set cnDB = Server.CreateObject("ADODB.Connection")
> sQryConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=D:\InetPub\wwwroot\mydirectory\myaccess.mdb;" &
> _
> "User Id=admin;" & _
> "Password=;"
> cnDB.CursorLocation =adUseClient
> cnDB.Open (sQryConn )
>
> -----Original Message-----
> From: Eva Jaatmaa [mailto:eva.j@c...]
> Sent: Thursday, July 12, 2001 3:19 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] How do I connect to an Access db across
> the internet
>
>
> Good morning,
> I am struggling with a problem that has occured because I cannot connect
> and work with data on the WebServer (and my ISP cannot solve it)
> How do I write a connection string to open and work with a database on a
> remote webserver? (The connection string has to (I guess) include the
> URL to the server)
> I am using asp, vb, and the database is MS Access.
>
> Thankful for any ideas
> Eva Jaatmaa
>
>
> PS The complete application is -
> 1. I have data entered into a MS Access data base
> (residing on the Web werver - that is remote and I have no real control,
> I have had my ISP tch setup system DSNs for all my work with connecting
> to the db files)
> 2. Data is transfered, edited withing the Access database and moved to a
> Access table for later transfer
> 3. The last step is transferring the data fropm the Access table to a
> Paradox table (as for now this Paradox table also resides on the Wevserver)
> 4. I download the Paradox file (FTP) and merge in into an application I
> have locally.
>
> THE PROBLEM is the Paradox, transfer and connection does not work on the
> Web Server, and my ISp cannot resolve it. So my idea now is that I get
> the Access data over to my (local) machine - and I do the transfer here
> (the application works on my Win2000, IIS machine)
>
> Thanks again - for your time
> Where will I find replies if there are any?????
> Eva
>
Message #4 by "Ken Schaefer" <ken@a...> on Mon, 16 Jul 2001 11:53:27 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Eva Jaatmaa" <eva.j@c...>
Subject: [asp_database_setup] RE: How do I connect to an Access db across -
the internet
: My question continues -
: If I have the Asp document on my machine and I need to connect to the
: database on the WebServer how would the Data source look - can I somehow
: use something like "http://www.thewebserver/.... ..... .....".?
: Eva
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
No - you can't. Please do some research instead of posting this question
repeatedly to the list.
There is no TCP based listener service for Access. You can only connect to
Access by specifying a path\file, eg:
k:\databases\database.mdb
where k is a drive letter mapped to a share on the remote machine.
Cheers
Ken
Message #5 by "Enzo" <enzo@t...> on Mon, 16 Jul 2001 22:18:02 +0800
|
|
Hello Eva!!!
I have the same problem too a month ago and I found this code below
effective IF your using SQL server or in my case i've used MSDE which
also SQL 7 compatible.
oConn.Open "Provider=3Dsqloledb;" & _
"Data Source=3DServerMachineName;" & _
"Initial Catalog=3DDatabaseName;" & _
"User Id=3DmyUsername;" & _
"Password=3DmyPassword;"
If still that doesn't answer your problem may be try going to this site
http://www.able-consulting.com/ado_conn.htm this is a great site for
connection syntax for different purposes. I got this one from Tony.
thanks to him! c",)
Cyah!!!
Enzo
----- Original Message -----
From: Eva Jaatmaa
To: ASP Database Setup
Sent: Saturday, July 14, 2001 6:36 PM
Subject: [asp_database_setup] RE: How do I connect to an Access db
across - the internet
My question continues -
If I have the Asp document on my machine and I need to connect to the
database on the WebServer how would the Data source look - can I
somehow
use something like "http://www.thewebserver/.... ..... .....".?
Eva
> Data Source must be using MapPath to take a virtual path and convert
it to a
> physical path or just specify the physical path...as an example
> dim cnDB
> set cnDB =3D Server.CreateObject("ADODB.Connection")
> sQryConn =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
> "Data
Source=3DD:\InetPub\wwwroot\mydirectory\myaccess.mdb;" &
> _
> "User Id=3Dadmin;" & _
> "Password=3D;"
> cnDB.CursorLocation =3DadUseClient
> cnDB.Open (sQryConn )
>
> -----Original Message-----
> From: Eva Jaatmaa [mailto:eva.j@c...]
> Sent: Thursday, July 12, 2001 3:19 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] How do I connect to an Access db
across
> the internet
>
>
> Good morning,
> I am struggling with a problem that has occured because I cannot
connect
> and work with data on the WebServer (and my ISP cannot solve it)
> How do I write a connection string to open and work with a database
on a
> remote webserver? (The connection string has to (I guess) include
the
> URL to the server)
> I am using asp, vb, and the database is MS Access.
>
> Thankful for any ideas
> Eva Jaatmaa
>
>
> PS The complete application is -
> 1. I have data entered into a MS Access data base
> (residing on the Web werver - that is remote and I have no real
control,
> I have had my ISP tch setup system DSNs for all my work with
connecting
> to the db files)
> 2. Data is transfered, edited withing the Access database and moved
to a
> Access table for later transfer
> 3. The last step is transferring the data fropm the Access table to
a
> Paradox table (as for now this Paradox table also resides on the
Wevserver)
> 4. I download the Paradox file (FTP) and merge in into an
application I
> have locally.
>
> THE PROBLEM is the Paradox, transfer and connection does not work on
the
> Web Server, and my ISp cannot resolve it. So my idea now is that I
get
> the Access data over to my (local) machine - and I do the transfer
here
> (the application works on my Win2000, IIS machine)
>
> Thanks again - for your time
> Where will I find replies if there are any?????
> Eva
>
Message #6 by "Drew, Ron" <RDrew@B...> on Mon, 16 Jul 2001 14:44:53 -0400
|
|
I replied in the same manner as Ken...
Either do a MapPath to get the physical directory location or call your ISP
and ask them for the path...normally
"Data Source=C:\InetPub\wwwroot\yourdirectory\your.mdb;"
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Sunday, July 15, 2001 9:53 PM
To: ASP Database Setup
Subject: [asp_database_setup] RE: How do I connect to an Access db
across - the internet
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Eva Jaatmaa" <eva.j@c...>
Subject: [asp_database_setup] RE: How do I connect to an Access db across -
the internet
: My question continues -
: If I have the Asp document on my machine and I need to connect to the
: database on the WebServer how would the Data source look - can I somehow
: use something like "http://www.thewebserver/.... ..... .....".?
: Eva
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
No - you can't. Please do some research instead of posting this question
repeatedly to the list.
There is no TCP based listener service for Access. You can only connect to
Access by specifying a path\file, eg:
k:\databases\database.mdb
where k is a drive letter mapped to a share on the remote machine.
Cheers
Ken
Message #7 by "fadi" <fadirh@u...> on Wed, 18 Jul 2001 06:56:50
|
|
|
|
|
View Cart
