|
 |
asp_database_setup thread: Dbase separated from the asp pages
Message #1 by "Enzo" <enzo@t...> on Fri, 15 Jun 2001 05:32:42 +0800
|
|
Greetings!!! I have a problem regarding connecting to the dbase which
is located on the other server machine. How can I make a connection to
SERVER1(where the database is placed) from SERVER2(where the htm and asp
are placed)??????? Will I be using the IP address to specify the dbase
location????
We've been doing this to avoid hackers from doing nasty things on the
dbase so the dbase is located on anther server machine. Do we need to
install IIS on both SERVER1 & SERVER2????? What connection method is
better to use DSN or OLE-DB?????
Please advice. I need response very badly.
Enzo
PrintMagic Trading
ICQ# 36446068
http://enzoy.cjb.net
Message #2 by "Tony" <one_dev@h...> on Fri, 15 Jun 2001 09:04:22 -0500
|
|
Enzo,
I got this information from http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples.
To connect via an IP address
oConn.Open "Provider=sqloledb;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Network Library=DBMSSOCN;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword;"
Note:
"Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than Named
Pipes (Q238949). And 1433 is the default port number for SQL Server
Tony
"Enzo" <enzo@t...> wrote in message news:74073@a..._database_setup...
>
> Greetings!!! I have a problem regarding connecting to the dbase which
> is located on the other server machine. How can I make a connection to
> SERVER1(where the database is placed) from SERVER2(where the htm and asp
> are placed)??????? Will I be using the IP address to specify the dbase
> location????
>
> We've been doing this to avoid hackers from doing nasty things on the
> dbase so the dbase is located on anther server machine. Do we need to
> install IIS on both SERVER1 & SERVER2????? What connection method is
> better to use DSN or OLE-DB?????
>
> Please advice. I need response very badly.
>
>
> Enzo
> PrintMagic Trading
> ICQ# 36446068
> http://enzoy.cjb.net
>
>
Message #3 by "Enzo" <enzo@t...> on Sat, 16 Jun 2001 00:10:23 +0800
|
|
Thank you very much Tony this is a great help!!!! I'll try using the
codes and I'll see if it works. If it doesn't, well i have to ask you a
favor again =3D) hehe thanks a lot!!!!!
Enzo
PrintMagic Trading
ICQ# 36446068
http://enzoy.cjb.net
Message #4 by "Enzo" <enzo@t...> on Sat, 16 Jun 2001 01:05:16 +0800
|
|
Hi Tony!
How about if I want to connect to the remote dbase server not using IP
let say I'm in a network. MACHINE 1 contains the ASP and is a web server
machine then MACHINE 2 is where the dbase is located but it is not a
server machine but just one of the computers connected to the network.
Thanks in advance!!!! =3D)
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Friday, June 15, 2001 10:04 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
I got this information from
http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples.
To connect via an IP address
oConn.Open "Provider=3Dsqloledb;" & _
"Data Source=3Dxxx.xxx.xxx.xxx,1433;" & _
"Network Library=3DDBMSSOCN;" & _
"Initial Catalog=3DmyDatabaseName;" & _
"User ID=3DmyUsername;" & _
"Password=3DmyPassword;"
Note:
"Network Library=3DDBMSSOCN" tells OLE DB to use TCP/IP rather than
Named
Pipes (Q238949). And 1433 is the default port number for SQL Server
Tony
"Enzo" <enzo@t...> wrote in message
news:74073@a..._database_setup...
>
> Greetings!!! I have a problem regarding connecting to the dbase
which =3D
> is located on the other server machine. How can I make a connection
to =3D
> SERVER1(where the database is placed) from SERVER2(where the htm and
asp =3D
> are placed)??????? Will I be using the IP address to specify the
dbase =3D
> location????
>
> We've been doing this to avoid hackers from doing nasty things on
the =3D
> dbase so the dbase is located on anther server machine. Do we need
to =3D
> install IIS on both SERVER1 & SERVER2????? What connection method
is =3D
> better to use DSN or OLE-DB?????
>
> Please advice. I need response very badly.
>
>
> Enzo
> PrintMagic Trading
> ICQ# 36446068
> http://enzoy.cjb.net
>
>
Message #5 by "Enzo" <enzo@t...> on Sat, 16 Jun 2001 01:27:43 +0800
|
|
Oh sorry I'm bit confused, does the IP address means the unique IP
address of the computer in a network or is it the IP address of a web
server like for example http://292.268.234.1 ????? Help me clear things
out.
Thanks
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Friday, June 15, 2001 10:04 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
I got this information from
http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples.
To connect via an IP address
oConn.Open "Provider=3Dsqloledb;" & _
"Data Source=3Dxxx.xxx.xxx.xxx,1433;" & _
"Network Library=3DDBMSSOCN;" & _
"Initial Catalog=3DmyDatabaseName;" & _
"User ID=3DmyUsername;" & _
"Password=3DmyPassword;"
Note:
"Network Library=3DDBMSSOCN" tells OLE DB to use TCP/IP rather than
Named
Pipes (Q238949). And 1433 is the default port number for SQL Server
Tony
"Enzo" <enzo@t...> wrote in message
news:74073@a..._database_setup...
>
> Greetings!!! I have a problem regarding connecting to the dbase
which =3D
> is located on the other server machine. How can I make a connection
to =3D
> SERVER1(where the database is placed) from SERVER2(where the htm and
asp =3D
> are placed)??????? Will I be using the IP address to specify the
dbase =3D
> location????
>
> We've been doing this to avoid hackers from doing nasty things on
the =3D
> dbase so the dbase is located on anther server machine. Do we need
to =3D
> install IIS on both SERVER1 & SERVER2????? What connection method
is =3D
> better to use DSN or OLE-DB?????
>
> Please advice. I need response very badly.
>
>
> Enzo
> PrintMagic Trading
> ICQ# 36446068
> http://enzoy.cjb.net
>
>
Message #6 by "Tony" <one_dev@h...> on Mon, 18 Jun 2001 08:06:24 -0500
|
|
Enzo,
If you're connecting to a SQL Server on a network, you can use the machine
name:
oConn.Open "Provider=sqloledb;" & _
"Data Source=MACHINE2_Name;" & _
"Initial Catalog=DatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword;"
Tony
"Enzo" <enzo@t...> wrote in message news:74339@a..._database_setup...
Hi Tony!
How about if I want to connect to the remote dbase server not using IP let
say I'm in a network. MACHINE 1 contains the ASP and is a web server machine
then MACHINE 2 is where the dbase is located but it is not a server machine
but just one of the computers connected to the network.
Thanks in advance!!!! =)
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Friday, June 15, 2001 10:04 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
I got this information from http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples.
To connect via an IP address
oConn.Open "Provider=sqloledb;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Network Library=DBMSSOCN;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword;"
Note:
"Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than Named
Pipes (Q238949). And 1433 is the default port number for SQL Server
Tony
"Enzo" <enzo@t...> wrote in message news:74073@a..._database_setup...
>
> Greetings!!! I have a problem regarding connecting to the dbase which
> is located on the other server machine. How can I make a connection to
> SERVER1(where the database is placed) from SERVER2(where the htm and asp
> are placed)??????? Will I be using the IP address to specify the dbase
> location????
>
> We've been doing this to avoid hackers from doing nasty things on the
> dbase so the dbase is located on anther server machine. Do we need to
> install IIS on both SERVER1 & SERVER2????? What connection method is
> better to use DSN or OLE-DB?????
>
> Please advice. I need response very badly.
>
>
> Enzo
> PrintMagic Trading
> ICQ# 36446068
> http://enzoy.cjb.net
>
>
Message #7 by "Enzo" <enzo@t...> on Mon, 18 Jun 2001 22:40:14 +0800
|
|
Hello Tony!!!
In normal dbase connection we set Data source by giving the specific
path and filename (for ex, data source=3D"c:/datastores/mydbase.mdf"),
so how would I do that in my case???? How can ASP know what file to
open by just simply stating the computer's name or IP??? do I need
something else to declare aside from the name or IP address of the
machine???
Thanks =3D)
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Monday, June 18, 2001 9:06 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
If you're connecting to a SQL Server on a network, you can use the
machine
name:
oConn.Open "Provider=3Dsqloledb;" & _
"Data Source=3DMACHINE2_Name;" & _
"Initial Catalog=3DDatabaseName;" & _
"User Id=3DmyUsername;" & _
"Password=3DmyPassword;"
Tony
"Enzo" <enzo@t...> wrote in message
news:74339@a..._database_setup...
Hi Tony!
How about if I want to connect to the remote dbase server not using IP
let
say I'm in a network. MACHINE 1 contains the ASP and is a web server
machine
then MACHINE 2 is where the dbase is located but it is not a server
machine
but just one of the computers connected to the network.
Thanks in advance!!!! =3D)
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Friday, June 15, 2001 10:04 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
I got this information from
http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples.
To connect via an IP address
oConn.Open "Provider=3Dsqloledb;" & _
"Data Source=3Dxxx.xxx.xxx.xxx,1433;" & _
"Network Library=3DDBMSSOCN;" & _
"Initial Catalog=3DmyDatabaseName;" & _
"User ID=3DmyUsername;" & _
"Password=3DmyPassword;"
Note:
"Network Library=3DDBMSSOCN" tells OLE DB to use TCP/IP rather
than Named
Pipes (Q238949). And 1433 is the default port number for SQL
Server
Tony
"Enzo" <enzo@t...> wrote in message
news:74073@a..._database_setup...
>
> Greetings!!! I have a problem regarding connecting to the dbase
which =3D
> is located on the other server machine. How can I make a
connection to
=3D
> SERVER1(where the database is placed) from SERVER2(where the htm
and asp
=3D
> are placed)??????? Will I be using the IP address to specify the
dbase
=3D
> location????
>
> We've been doing this to avoid hackers from doing nasty things on
the =3D
> dbase so the dbase is located on anther server machine. Do we
need to =3D
> install IIS on both SERVER1 & SERVER2????? What connection method
is =3D
> better to use DSN or OLE-DB?????
>
> Please advice. I need response very badly.
>
>
> Enzo
> PrintMagic Trading
> ICQ# 36446068
> http://enzoy.cjb.net
>
>
Message #8 by "Tony" <one_dev@h...> on Tue, 19 Jun 2001 09:43:29 -0500
|
|
Enzo,
Are you using SQL Server or Access?
"Enzo" <enzo@t...> wrote in message news:74784@a..._database_setup...
Hello Tony!!!
In normal dbase connection we set Data source by giving the specific path
and filename (for ex, data source="c:/datastores/mydbase.mdf"), so how would
I do that in my case???? How can ASP know what file to open by just simply
stating the computer's name or IP??? do I need something else to declare
aside from the name or IP address of the machine???
Thanks =)
Enzo
Message #9 by "Enzo" <enzo@t...> on Tue, 19 Jun 2001 23:14:57 +0800
|
|
I'm using SQL oh I mean MSDE well MSDE i think is SQL 7 compatible.
Well you can give explanations for both access and sql =3D) thanks in
advance!!!
Enzo
----- Original Message -----
From: Tony
Newsgroups: asp_database_setup
To: ASP Database Setup
Sent: Tuesday, June 19, 2001 10:43 PM
Subject: [asp_database_setup] Re: Dbase separated from the asp pages
Enzo,
Are you using SQL Server or Access?
"Enzo" <enzo@t...> wrote in message
news:74784@a..._database_setup...
Hello Tony!!!
In normal dbase connection we set Data source by giving the specific
path
and filename (for ex, data source=3D"c:/datastores/mydbase.mdf"), so
how would
I do that in my case???? How can ASP know what file to open by just
simply
stating the computer's name or IP??? do I need something else to
declare
aside from the name or IP address of the machine???
Thanks =3D)
Enzo
|
|
|
View Cart
