HEELLLPPPPP!!!!!!

[smellybigdog]

:brokenheart;

I am having real problems uploading a database, and getting very poor support
from my web host. Im using dreamweaver MX and creating a database for figurines
with prices, retirement dates ect... Ive done this in microsoft access 2003. I
have a conversion program to mysql. If anyone could answer the following
questions i would really be grateful. You will have to explain it like im a six
year old.
1. Can i upload it to any file on my server, or would it have to be in
public_htm ?
2. Do i then define my testing server as this folder on my server.
3. Instead of using my SQL can i upload an access server anywhere for a
reasonable price ?

I have an account with [url]www.bluehost.com[/url] who provide 50 database slots. The
program i use to convert the access database to mysql wants to know the
following information :
1.Host

> 2.port
> 3.username
> 4.password.

When i asked my provider, they seem to be suggesting i put in my computers ip
address for host. Are they not understanding me? Has anyone got any points or a
tutorial anywhere.

Thanks.

Very confused.

Paul.

[darrel]

> When i asked my provider, they seem to be suggesting i put in my
computers ip

> address for host. Are they not understanding me? Has anyone got any points

or a

> tutorial anywhere.

And ACCESS DB is a stand-alone file that you can upload independantly. A SQL
DB requires the SQL engine. It's not a standalone, portable file. So, as
your ISP is saying, you need to import your data into it.

You should be able to use Access...but you'd need to make sure the host will
support it.

As for the importing instructions, it sounds like your web host are idiots.
The Host is *their* server...namely the server running SQL.

-Darrel

[smellybigdog]

thanks darrel, appreciate your time. Anybody got any suggestions where i could host an access database at reasonable cost?

[rickvv1]

From what I've seen, MS Access isn't the most web-friendly database, and if
you've got a converter to take your Access data and pop it into mySQL, that
might the better way to go.
As far as getting to your mySQL database, it looks like bluehost has an
extensive FAQ section, including how to setup, get to, assign users, and
configure with DW.
You have some kind of control panel for your domain. The instructions 'seem'
pretty straigtforward:
1. Login to your control panel [url]http://yourdomain.com/cpanel[/url]
2. Click on MySQL databases
3. Add database
4. Add database users
5. Add users to new database
Once the DB is set up, use your converter tool to convert your Access to mySQL.
Then, you can upload the resulting file to your server. and import it into
your new mySQL database.

But in answer to to your converter question, it looks like:
Host would (probably) be ftp.[Your_Domain_Name].com
directory would be public_html
SQL port is typically 3306
username is whoever you're using from the steps above
password "ditto"^

DW can't connect to a DB if it doesn't exist.

Did you browse their help files? (copy the whole string that follows:
[url]http://helpdesk.bluehost.com/kb/index.php?mode=view_entry&kbid=155&kbcat=12[/url]

Good luck.

[Murray *TMM*]

> From what I've seen, MS Access isn't the most web-friendly database

Why do you say that? It's an ideal solution for the small site.

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

"rickvv1" <webforumsuser@macromedia.com> wrote in message
news:d6kqv7$jus$1@forums.macromedia.com...

> From what I've seen, MS Access isn't the most web-friendly database, and
> if
> you've got a converter to take your Access data and pop it into mySQL,
> that
> might the better way to go.
> As far as getting to your mySQL database, it looks like bluehost has an
> extensive FAQ section, including how to setup, get to, assign users, and
> configure with DW.

[chuckomalley]

Since you converted it to MySQL, do you use PHPMyAdmin to administer the
database? If so, I went through quite a bit getting mine set up for
upload/download to backup my online db to my PC as well as restoral into my
testing server's db (and vice/versa if gawd-forbid something should happen to
the online db).
Not sure if this will help you but I documented all of the steps I needed to
do and you're welcome to look at it to see if it helps you. Go to
[url]http://www.chuckomalley.net/help/[/url] and you'll see links for backup and restoral
of MySQL databases using PHPMyAdmin.

Cheers

Chuck

[darrel]

> Why do you say that? It's an ideal solution for the small site.

Acceptable, maybe. Ideal? Never. This *is* MS Access we're talking about,
here. ;o)

-Darrel

[Murray *TMM*]

<shrug>

Ideal for the small site.

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

"darrel" <notreal@hotmail.com> wrote in message
news:d6lju6$o45$1@forums.macromedia.com...

>> Why do you say that? It's an ideal solution for the small site.

>
> Acceptable, maybe. Ideal? Never. This *is* MS Access we're talking about,
> here. ;o)
>
> -Darrel
>
>

[darrel]

> Ideal for the small site.

How is it more ideal than running a SQL DB?

-Darrel