|
 |
aspx_beginners thread: ODBC Question
Message #1 by "Ben Densmore" <ben_densmore@e...> on Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)
|
|
Hi everyone, =0D
I have a potential client that uses some type of software that has an=0D
Access DB. He wants to allow users going to his website to be able to fil
l=0D
out some info that gets inserted into this same database. The problem is=0D
this database is on a machine in his office and his web server is hosted
at=0D
a different location. Is it possible to make an ODBC connection from the=0D
webserver to this Access Database via an IP Address? I think I have seen=0D
work arounds for this but can't seem to find it anywhere. =0D
=0D
Thanks, =0D
Ben
Message #2 by "Ben Roberts" <sucrerey@h...> on Thu, 13 Mar 2003 08:45:07 -0700
|
|
why not map a drive from the webserver to the host machine?
<geek class="middle">me</geek>
From: "Ben Densmore" <ben_densmore@e...>
Reply-To: "aspx_beginners" <aspx_beginners@p...>
To: "aspx_beginners" <aspx_beginners@p...>
Subject: [aspx_beginners] ODBC Question
Date: Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)
Hi everyone,
I have a potential client that uses some type of software that has an
Access DB. He wants to allow users going to his website to be able to fill
out some info that gets inserted into this same database. The problem is
this database is on a machine in his office and his web server is hosted at
a different location. Is it possible to make an ODBC connection from the
webserver to this Access Database via an IP Address? I think I have seen
work arounds for this but can't seem to find it anywhere.
Thanks,
Ben
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
Message #3 by "Ben Densmore" <ben_densmore@e...> on Thu, 13 Mar 2003 13:06:57 -0500 (Eastern Standard Time)
|
|
--------------Boundary-00=_LZ8PIA11VA4000000000
Content-Type: Text/Plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Well the problem with that is the webserver isn't owned by the client, it
's
a shared hosting account by another company. So I need another solution.=0D
=0D
Ben=0D
=0D
-------Original Message-------=0D
=0D
From: aspx_beginners=0D
Date: Thursday, March 13, 2003 10:46:19 AM=0D
To: aspx_beginners=0D
Subject: [aspx_beginners] Re: ODBC Question=0D
=0D
why not map a drive from the webserver to the host machine?=0D
=0D
=0D
=0D
<geek class=3D"middle">me</geek>=0D
=0D
=0D
=0D
=0D
=0D
From: "Ben Densmore" <ben_densmore@e...>=0D
Reply-To: "aspx_beginners" <aspx_beginners@p...>=0D
To: "aspx_beginners" <aspx_beginners@p...>=0D
Subject: [aspx_beginners] ODBC Question=0D
Date: Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)=0D
=0D
Hi everyone,=0D
I have a potential client that uses some type of software that has an=0D
Access DB. He wants to allow users going to his website to be able to fil
l=0D
out some info that gets inserted into this same database. The problem is=0D
this database is on a machine in his office and his web server is hosted
at=0D
a different location. Is it possible to make an ODBC connection from the=0D
webserver to this Access Database via an IP Address? I think I have seen=0D
work arounds for this but can't seem to find it anywhere.=0D
=0D
Thanks,=0D
Ben=0D
=0D
=0D
---=0D
Change your mail options at http://p2p.wrox.com/manager.asp or=0D
to unsubscribe send a blank email to =0D
=0D
=0D
=0D
_________________________________________________________________=0D
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. =0D
http://join.msn.com/?page=3Dfeatures/virus=0D
=0D
=0D
---=0D
Change your mail options at http://p2p.wrox.com/manager.asp or =0D
to unsubscribe send a blank email to leave-aspx_beginners-1638673Q@p...
ox
com.=0D
=2E
Message #4 by "Jerry Lanphear" <jerrylan@q...> on Sat, 15 Mar 2003 09:09:59 -0700
|
|
Ben,
If that is really the configuration you are shooting for you could have IIS installed on the clients machine and SQL Server 2000 as
well. Use an SQL connection object and data adapter. Oh, dont forget to use a good firewall router.
Regards
----- Original Message -----
From: Ben Densmore
To: aspx_beginners
Sent: Thursday, March 13, 2003 11:06 AM
Subject: [aspx_beginners] Re: ODBC Question
Well the problem with that is the webserver isn't owned by the client, it's a shared hosting account by another company. So
I need another solution.
Ben
-------Original Message-------
From: aspx_beginners
Date: Thursday, March 13, 2003 10:46:19 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: ODBC Question
why not map a drive from the webserver to the host machine?
<geek class="middle">me</geek>
From: "Ben Densmore" <ben_densmore@e...>
Reply-To: "aspx_beginners" <aspx_beginners@p...>
To: "aspx_beginners" <aspx_beginners@p...>
Subject: [aspx_beginners] ODBC Question
Date: Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)
Hi everyone,
I have a potential client that uses some type of software that has an
Access DB. He wants to allow users going to his website to be able to fill
out some info that gets inserted into this same database. The problem is
this database is on a machine in his office and his web server is hosted at
a different location. Is it possible to make an ODBC connection from the
webserver to this Access Database via an IP Address? I think I have seen
work arounds for this but can't seem to find it anywhere.
Thanks,
Ben
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
.
Message #5 by "Paul Riley" <rilez@t...> on Sun, 16 Mar 2003 02:33:08 -0000
|
|
Surly your talking about hosting the site client side??? Not the ideal
solution. But then again what is. Why does the database have to be
stored where it is? Can't a mySQL bd be used on the host side and the
changes be populated at a certain time during the night using a script?
Why is the SQL db used in the first place???
-----Original Message-----
From: Jerry Lanphear [mailto:jerrylan@q...]
Sent: 15 March 2003 16:10
To: aspx_beginners
Subject: [aspx_beginners] Re: ODBC Question
Ben,
If that is really the configuration you are shooting for you could have
IIS installed on the clients machine and SQL Server 2000 as well. Use
an SQL connection object and data adapter. Oh, dont forget to use a good
firewall router.
Regards
----- Original Message -----
From: Ben Densmore
To: aspx_beginners
Sent: Thursday, March 13, 2003 11:06 AM
Subject: [aspx_beginners] Re: ODBC Question
Well the problem with that is the webserver isn't owned by the
client, it's a shared hosting account by another company. So I need
another solution.
Ben
-------Original Message-------
From: aspx_beginners
Date: Thursday, March 13, 2003 10:46:19 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: ODBC Question
why not map a drive from the webserver to the host machine?
<geek class="middle">me</geek>
From: "Ben Densmore" <ben_densmore@e...>
Reply-To: "aspx_beginners" <aspx_beginners@p...>
To: "aspx_beginners" <aspx_beginners@p...>
Subject: [aspx_beginners] ODBC Question
Date: Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)
Hi everyone,
I have a potential client that uses some type of software that
has an
Access DB. He wants to allow users going to his website to be
able to fill
out some info that gets inserted into this same database. The
problem is
this database is on a machine in his office and his web server
is hosted at
a different location. Is it possible to make an ODBC connection
from the
webserver to this Access Database via an IP Address? I think I
have seen
work arounds for this but can't seem to find it anywhere.
Thanks,
Ben
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
.
Message #6 by "Jerry Lanphear" <jerrylan@q...> on Sun, 16 Mar 2003 00:33:28 -0700
|
|
I agree. However, without further explaination we can only speculate as to
the clients thinking. Another idea would be to host the data server side
and keep a copy on the client side. Access is capable on its own of
resyncing the two databases over the Internet with a single menu click of
the clients mouse.
Regards
----- Original Message -----
From: "Paul Riley" <rilez@t...>
To: "aspx_beginners" <aspx_beginners@p...>
Sent: Saturday, March 15, 2003 7:33 PM
Subject: [aspx_beginners] Re: ODBC Question
> Surly your talking about hosting the site client side??? Not the ideal
> solution. But then again what is. Why does the database have to be
> stored where it is? Can't a mySQL bd be used on the host side and the
> changes be populated at a certain time during the night using a script?
> Why is the SQL db used in the first place???
>
> -----Original Message-----
> From: Jerry Lanphear [mailto:jerrylan@q...]
> Sent: 15 March 2003 16:10
> To: aspx_beginners
> Subject: [aspx_beginners] Re: ODBC Question
>
>
> Ben,
>
> If that is really the configuration you are shooting for you could have
> IIS installed on the clients machine and SQL Server 2000 as well. Use
> an SQL connection object and data adapter. Oh, dont forget to use a good
> firewall router.
>
> Regards
> ----- Original Message -----
> From: Ben Densmore
> To: aspx_beginners
> Sent: Thursday, March 13, 2003 11:06 AM
> Subject: [aspx_beginners] Re: ODBC Question
>
>
> Well the problem with that is the webserver isn't owned by the
> client, it's a shared hosting account by another company. So I need
> another solution.
>
> Ben
>
> -------Original Message-------
>
> From: aspx_beginners
> Date: Thursday, March 13, 2003 10:46:19 AM
> To: aspx_beginners
> Subject: [aspx_beginners] Re: ODBC Question
>
> why not map a drive from the webserver to the host machine?
>
>
>
> <geek class="middle">me</geek>
>
>
>
>
>
> From: "Ben Densmore" <ben_densmore@e...>
> Reply-To: "aspx_beginners" <aspx_beginners@p...>
> To: "aspx_beginners" <aspx_beginners@p...>
> Subject: [aspx_beginners] ODBC Question
> Date: Thu, 13 Mar 2003 10:33:06 -0500 (Eastern Standard Time)
>
> Hi everyone,
> I have a potential client that uses some type of software that
> has an
> Access DB. He wants to allow users going to his website to be
> able to fill
> out some info that gets inserted into this same database. The
> problem is
> this database is on a machine in his office and his web server
> is hosted at
> a different location. Is it possible to make an ODBC connection
> from the
> webserver to this Access Database via an IP Address? I think I
> have seen
> work arounds for this but can't seem to find it anywhere.
>
> Thanks,
> Ben
>
>
>
>
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>
> .
>
>
>
>
>
>
>
>
|
|
|
View Cart
