How do you utilize databases that are located on servers that are not the 
web server. I am using Dreamweaver and ASP.NET.  This looks like a 
permissions issue.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "david potter" <djpotte@p...>
Subject: [asp_database_setup] Database Permissions on other servers ....


: How do you utilize databases that are located on servers that are not the
: web server. I am using Dreamweaver and ASP.NET.  This looks like a
: permissions issue.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You haven't provided enough information.

For example when you say "databases", what type of database are you talking
about? A database server such as SQL Server or Oracle, or a filebased
database like Access .mdb files?

When you say "you" are you talking about your ASP.net pages, or your
Dreamweaver development environment?

Please be exact in what your requirements are.

Cheers
Ken

I have a MS Database on another Windows 2000 Server. I am trying to access 
it with the Dreamweaver MX software as I am building the database 
connections. I am trying to use ASP.NET pages. 

thanks

dave



> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "david potter" <djpotte@p...>
Subject: [asp_database_setup] Database Permissions on other servers ....


: How do you utilize databases that are located on servers that are not the
: web server. I am using Dreamweaver and ASP.NET.  This looks like a
: permissions issue.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You haven't provided enough information.

For example when you say "databases", what type of database are you talking
about? A database server such as SQL Server or Oracle, or a filebased
database like Access .mdb files?

When you say "you" are you talking about your ASP.net pages, or your
Dreamweaver development environment?

Please be exact in what your requirements are.

Cheers
Ken

Hi David,

a) What is an "MS Database"? A Microsoft Access database? A Microsoft SQL
Server database? A Microsoft FoxPro database? Microsoft is a company. They
have several database products.

b) When you create ASP.Net pages (or any other type of "dynamic page", eg
PHP, ASP, CF etc), you need to create a "connection string" that tells the
page how to find the database. This connection string has to be valid for
the *server* that the page is going to be hosted on. So, you need to tell us
where your ASP.Net pages are going to be running as well. It's all very well
if Dreamweaver can find the database, but your ASP.Net pages can't...

Here is a list of connection strings if that helps. Select the connection
string for your database type:
http://www.able-consulting.com/ado_conn.htm

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "david potter" <djpotte@p...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Friday, February 07, 2003 5:21 PM
Subject: [asp_database_setup] Re: Database Permissions on other servers ....


: I have a MS Database on another Windows 2000 Server. I am trying to access
: it with the Dreamweaver MX software as I am building the database
: connections. I am trying to use ASP.NET pages.
:
: thanks
:
: dave
:
:
:
: > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "david potter" <djpotte@p...>
: Subject: [asp_database_setup] Database Permissions on other servers ....
:
:
: : How do you utilize databases that are located on servers that are not
the
: : web server. I am using Dreamweaver and ASP.NET.  This looks like a
: : permissions issue.
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:
: You haven't provided enough information.
:
: For example when you say "databases", what type of database are you
talking
: about? A database server such as SQL Server or Oracle, or a filebased
: database like Access .mdb files?
:
: When you say "you" are you talking about your ASP.net pages, or your
: Dreamweaver development environment?
:
: Please be exact in what your requirements are.
:
: Cheers
: Ken

Hi..
You dont say anything about which database you are running.
*******************
Important!!!
Have you remembered to give the "aspnet" user approperiate permissions? 
******************
If it is a Access db you just store it localy in your project.
If it is a SQL db you're accessing you can store the path in 
the Webconfig file. And then you refere to the path in the page load sub.
Br: Grener


On Thu, 6 Feb 2003 18:56:47, david potter wrote
> How do you utilize databases that are located on servers that are 
> not the web server. I am using Dreamweaver and ASP.NET.  This looks 
> like a permissions issue.
> To unsubscribe send a blank email to leave-asp_database_setup-
1638229I@p...
> 
> to unsubscribe send a blank email to leave-asp_database_setup-
1638229I@p...


******** NYTTIG ***********
http://www.grener.no

MOB: 913 20 720


"Eg e no mest bare i veien.... "