|
 |
asp_databases thread: I have a question
Message #1 by "Phil Perks" <philp@w...> on Tue, 29 Aug 2000 14:51:58 +0100
|
|
-----Original Message-----
From: m.bakker011@k... [mailto:m.bakker011@k...]
Sent: 25 August 2000 14:28
To: support@w...
Subject: I have a question
Hello,
i bought your book ASP Databases, but i can not find a method in the book
how to connect to an Access 2000 database in a directory on another server.
I build an ASP page on server 1 to extract records from an Access database
on another server. The script is working fine when the database is on the
same server. Can you give me a tip how i can connect to an Access database
on another server.
Thanks.
Met vriendelijke groet,
Mark Bakker
Message #2 by "Dana Coffey" <dcoffey@x...> on Tue, 29 Aug 2000 11:10:47 -0400
|
|
I believe that the server administrator needs to set up a system DSN for
your database before you can access it.
Dana Coffey
Technologist, Xceed, Inc.
112 Krog St. Atlanta, GA 30307
tel. xxx-xxx-xxxx x 5013
www.xceed.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Everything should be as simple as it is, but not simpler.
----Albert Einstein
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
{{-----Original Message-----
{{From: Phil Perks [mailto:philp@w...]
{{Sent: Tuesday, August 29, 2000 9:52 AM
{{To: ASP Databases
{{Subject: [asp_databases] I have a question
{{
{{
{{-----Original Message-----
{{
{{From: m.bakker011@k... [mailto:m.bakker011@k...]
{{
{{Sent: 25 August 2000 14:28
{{
{{To: support@w...
{{
{{Subject: I have a question
{{
{{
{{
{{Hello,
{{
{{i bought your book ASP Databases, but i can not find a method in the book
{{
{{how to connect to an Access 2000 database in a directory on
{{another server.
{{
{{I build an ASP page on server 1 to extract records from an Access database
{{
{{on another server. The script is working fine when the database is on the
{{
{{same server. Can you give me a tip how i can connect to an Access database
{{
{{on another server.
{{
{{Thanks.
{{
{{
{{
{{Met vriendelijke groet,
{{
{{Mark Bakker
{{
{{
{{
{{
{{---
{{You are currently subscribed to asp_databases
{{
{{$subst('Email.Unsub')
{{
{{
{{
Message #3 by "Joe White" <jwboy78@h...> on Tue, 29 Aug 2000 08:06:24 PDT
|
|
I would create an ado string with the ip addy of the other server and then
the rest of the info. Justan idea
>From: "Phil Perks" <philp@w...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] I have a question
>Date: Tue, 29 Aug 2000 14:51:58 +0100
>
>-----Original Message-----
>
>From: m.bakker011@k... [mailto:m.bakker011@k...]
>
>Sent: 25 August 2000 14:28
>
>To: support@w...
>
>Subject: I have a question
>
>
>
>Hello,
>
>i bought your book ASP Databases, but i can not find a method in the book
>
>how to connect to an Access 2000 database in a directory on another server.
>
>I build an ASP page on server 1 to extract records from an Access database
>
>on another server. The script is working fine when the database is on the
>
>same server. Can you give me a tip how i can connect to an Access database
>
>on another server.
>
>Thanks.
>
>
>
>Met vriendelijke groet,
>
>Mark Bakker
>
>
>
>
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 30 Aug 2000 11:03:53 +1000
|
|
Server1 has the webserver
Server2 has the database
a) On server1 create an IUSR_Server2 account. Make sure it has the same
password as the IUSR_server2 account on Server2
b) Share the folder with the database on server2 (eg as \databases\). Make
sure the \\server2\IUSR_server2 account has permissions to the share
c) Set up a connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server2\databases\db1.mdb"
HTH
Cheers
Ken
----- Original Message -----
From: "Phil Perks" <philp@w...>
Newsgroups: asp_databases
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, August 29, 2000 11:51 PM
Subject: [asp_databases] I have a question
> -----Original Message-----
>
> From: m.bakker011@k... [mailto:m.bakker011@k...]
>
> Sent: 25 August 2000 14:28
>
> To: support@w...
>
> Subject: I have a question
>
>
>
> Hello,
>
> i bought your book ASP Databases, but i can not find a method in the book
>
> how to connect to an Access 2000 database in a directory on another
server.
>
> I build an ASP page on server 1 to extract records from an Access database
>
> on another server. The script is working fine when the database is on the
>
> same server. Can you give me a tip how i can connect to an Access database
>
> on another server.
>
> Thanks.
>
>
>
> Met vriendelijke groet,
>
> Mark Bakker
>
>
>
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
>
|
|
|
View Cart
