Dreamweaver MX Dynamic Applications

[BeausMom]

Hi Jeffrey.

I've made it to page 202, Lesson 8 in your book. And now I can't establish a
connection with the database. I'm temporarily using this as my training
website: [url]www.trashbagsdontwork.com[/url]. I've got it running on a GoDaddy server
with ASP. Username: newlandtours; Password: tours. When I attempt to set
up the DW DSN wizard, I'm using: Connection Name: connection; DSN:
access_newlandtours.dsn; User Name: newlandtours; Password: tours. I set
them up via my GoDaddy control panel, and have confirmed them to be correct.
Yet, I get the following message: "[Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified."

The GoDaddy technical guy said it seems I'm trying to connect remotely to my
database, and they don't allow that on a shared server. Is that truly the
problem here? (I've been led in far too many incorrect directions in the past,
I thought I would just try to verify this little tidbit first.) If this is not
the case, please help me. If it IS the case, let me know and I'll pursue
another hosting option.

Thank you.

[~Angela, TMM]

Hi,

I'm not Jeffrey ;-) but if you haven't done so already be sure to change
those usernames and passwords.

It is definitely a possibility that GoDaddy has disabled the ability for
remote connections to the database. As a general rule, testing on a live
server is discouraged. (Imagine if you made a coding error that caused an
infinite loop and crashed their server. Now imagine if you were another site
hosted on the same server and your site went down because some person wrote
some bad code.)

What you need to do is set up a local testing server that matches the
environment of your live server. That means, if your live server is Windows
with an Access Database running ASP you should have Windows and IIS running
locally and set up an Access connection to your local database. If the live
server is ColdFusion on a Unix, you're best off testing on a Unix machine
running ColdFusion. It just makes development much easier that way...

Hope this helps and good luck to you!

~Angela
--
Angela C. Buraglia, Founder:
~FAQs, Tutorials & Resources~ [url]http://www.DreamweaverFAQ.com[/url]
~My Extensions~ [url]http://www.dwfaq.com/go.asp?ID=AngelaX10[/url]
DWfaq Support Newsgroup: [url]news://support.dwfaq.com/support[/url]

Co-Author with Joseph Lowery, Dreamweaver MX 2004 Killer Tips:
[url]http://www.dwkillertips.com[/url]

Extension Developer for Cartweaver 2:
[url]http://www.cartweaver.com/features/extensionsuite/[/url]

Remove the CAPS in my E-mail to reply off list.

"BeausMom" <webforumsuser@macromedia.com> wrote in message
news:d75d8b$qsf$1@forums.macromedia.com...

> Hi Jeffrey.
>
> I've made it to page 202, Lesson 8 in your book. And now I can't
> establish a
> connection with the database. I'm temporarily using this as my training
> website: [url]www.trashbagsdontwork.com[/url]. I've got it running on a GoDaddy
> server
> with ASP. Username: newlandtours; Password: tours. When I attempt to
> set
> up the DW DSN wizard, I'm using: Connection Name: connection; DSN:
> access_newlandtours.dsn; User Name: newlandtours; Password: tours. I
> set
> them up via my GoDaddy control panel, and have confirmed them to be
> correct.
> Yet, I get the following message: "[Microsoft][ODBC Driver Manager] Data
> source name not found and no default driver specified."
>
> The GoDaddy technical guy said it seems I'm trying to connect remotely to
> my
> database, and they don't allow that on a shared server. Is that truly the
> problem here? (I've been led in far too many incorrect directions in the
> past,
> I thought I would just try to verify this little tidbit first.) If this
> is not
> the case, please help me. If it IS the case, let me know and I'll pursue
> another hosting option.
>
> Thank you.
>