DSN Problems

I'm using MX to develop dynamic pages in ASP with Javascript. I'm also using
Microsoft Access Database. We've upgraded our plan with Interland (our hosting
services) and currently havinf the following problem:

When trying to open the "tables" from the DSN connection I had created a while
back in the "Databases" panel, it displays "none". The DB are abviously not
empty and the same DB on the server are working since the website is working
retrieving the data from the same DB's...

I called Interland and they obviously can't do anything since it's working
just fine on the servers.

Here's what I did:

On Server
1. Created a DSN on the server (name: Prostat_320456)
2. Selected the right database from the server
3. Driver: Microsoft Access Driver (*.mdb)

In Dreamweaver
1. In the "Databses" panel, I click the + sign and select Data Source Name
(DSN)
2. I enter a Connection Name (e.g.: connMyDatabase)
3. In the Data Source Name (DSN), I enter the DSN name I created on the server
(Prostat_320456)
4. I click the "Test" button and "Connection was made successfully" is diaplyed
5. I click the + sign next to the new connection I just created, then click
the + sign under table, and it says "none"

The database is both on my local computer and on the server. When it tries to
open the tables in Dreamweaver, does it try to open on my local machine?

I think I'm missing something here and can't figure out what!

Again, the site itself works using the data in the DB, it's just that I can't
create new Recordsets...

Thank you!

Have you established an ODBC link to the database locally?

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================


"Brachole" <webforumsuser (AT) macromedia (DOT) com> wrote

I'm using MX to develop dynamic pages in ASP with Javascript. I'm also
using
Microsoft Access Database. We've upgraded our plan with Interland (our
hosting
services) and currently havinf the following problem:

When trying to open the "tables" from the DSN connection I had created a
while
back in the "Databases" panel, it displays "none". The DB are abviously
not
empty and the same DB on the server are working since the website is
working
retrieving the data from the same DB's...

I called Interland and they obviously can't do anything since it's working
just fine on the servers.

Here's what I did:

On Server
1. Created a DSN on the server (name: Prostat_320456)
2. Selected the right database from the server
3. Driver: Microsoft Access Driver (*.mdb)

In Dreamweaver
1. In the "Databses" panel, I click the + sign and select Data Source Name
(DSN)
2. I enter a Connection Name (e.g.: connMyDatabase)
3. In the Data Source Name (DSN), I enter the DSN name I created on the
server
(Prostat_320456)
4. I click the "Test" button and "Connection was made successfully" is
diaplyed
5. I click the + sign next to the new connection I just created, then
click
the + sign under table, and it says "none"

The database is both on my local computer and on the server. When it tries
to
open the tables in Dreamweaver, does it try to open on my local machine?

I think I'm missing something here and can't figure out what!

Again, the site itself works using the data in the DB, it's just that I
can't
create new Recordsets...

Thank you!

During development, you want it to open the Access db on your local machine.
If you try to develop on a remote server, it will take forever. The
connection and dsn should be the same however. And any changes you make to
the database itself will of course require the access db to be uploaded
again.

On the connection dialogue, make sure you have DSN from my local machine
selected. When you switch to the remote site in the browser, it will pick
up the remote copy of the database because you named the DSNs the same
thing.


--
Nancy Gill
Team Macromedia Member: Dreamweaver MX/UltraDev
http://www.macromedia.com/go/team/
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development



"Brachole" <webforumsuser (AT) macromedia (DOT) com> wrote

I'm using MX to develop dynamic pages in ASP with Javascript. I'm also
using
Microsoft Access Database. We've upgraded our plan with Interland (our
hosting
services) and currently havinf the following problem:

When trying to open the "tables" from the DSN connection I had created a
while
back in the "Databases" panel, it displays "none". The DB are abviously
not
empty and the same DB on the server are working since the website is
working
retrieving the data from the same DB's...

I called Interland and they obviously can't do anything since it's
working
just fine on the servers.

Here's what I did:

On Server
1. Created a DSN on the server (name: Prostat_320456)
2. Selected the right database from the server
3. Driver: Microsoft Access Driver (*.mdb)

In Dreamweaver
1. In the "Databses" panel, I click the + sign and select Data Source
Name
(DSN)
2. I enter a Connection Name (e.g.: connMyDatabase)
3. In the Data Source Name (DSN), I enter the DSN name I created on the
server
(Prostat_320456)
4. I click the "Test" button and "Connection was made successfully" is
diaplyed
5. I click the + sign next to the new connection I just created, then
click
the + sign under table, and it says "none"

The database is both on my local computer and on the server. When it
tries to
open the tables in Dreamweaver, does it try to open on my local machine?

I think I'm missing something here and can't figure out what!

Again, the site itself works using the data in the DB, it's just that I
can't
create new Recordsets...

Thank you!

Ha!!!! My Bad....

I rebuilted my system about a month ago and therefore wiped out my ODBC! It
had been 4 or 5 years since I first created that and completely forgot...

Thanks guys, it was very helpful!

That happened to me when I reinstalled DW awhile back. Glad you figured it
out.

Nancy

"Brachole" <webforumsuser (AT) macromedia (DOT) com> wrote

Ha!!!! My Bad....

I rebuilted my system about a month ago and therefore wiped out my ODBC!
It
had been 4 or 5 years since I first created that and completely forgot...

Thanks guys, it was very helpful!