[MySQL][ODBC 3.51 Driver]Acess denied for user

Forum|Forum|19 years ago
July 7, 2007
5 replies
3071 views

After some major connection problems I was able to successfully test my connection but I noticed that my tables aren't showing up. I can't edit or add a record set because every time I do I get a "no tables found" message when my tables seem to work fine online. I can't really do much without seeing and using my tables.

So I cleared my script files and connection files and re-established them after researching fixes. Well now I can't connect at all. I get a "[MySQL][ODBC 3.51 Driver]Acess denied for user 'ODBC'@'p3swh044.shr.phx3.secureserver.net'(using password: YES)" message. My password and user name are correct. I don't know SQL and I am not writing it by hand. It is all through dreamweaver.

I am using Dreamweaver MX I believe. can anyone help? Thanks!

Server side applications

This topic has been closed for replies.

N

Newsgroup_User

Inspiring

yes the server could be the problem. call who ever is hosting your site and
ask them have they configured something on the server to give you these
issues.

"Lithriel" <webforumsuser@macromedia.com> wrote in message
news:f6tifh$1tm$1@forums.macromedia.com...
> Yes, I've tried option three in the past and I tried it today and it still
> doesn't work.
>
> The connection string is perfectly fine. It is not the problem. Is there
> anything else that might be causing this? Could the server be the
> problem? I
> have no idea.
>

L

LithrielAuthor

Participant

Yes, I've tried option three in the past and I tried it today and it still doesn't work.

The connection string is perfectly fine. It is not the problem. I am actually using asp, by the way. Is there anything else that might be causing this? Could the server be the problem? I have no idea.

N

Newsgroup_User

Inspiring

Hi yea,

open your connection string directory, then open your connection page.

compare your connection sting with one of these

http://www.connectionstrings.com/?carrier=mysql

k

ps dont forget you have to upload your connections dir to your server.

"Lithriel" <webforumsuser@macromedia.com> wrote in message
news:f6p921$s18$1@forums.macromedia.com...
> After some major connection problems I was able to successfully test my
> connection but I noticed that my tables aren't showing up. I can't edit
> or add
> a record set because every time I do I get a "no tables found" message
> when my
> tables seem to work fine online. I can't really do much without seeing
> and
> using my tables.
>
> So I cleared my script files and connection files and re-established them
> after researching fixes. Well now I can't connect at all. I get a
> "[MySQL][ODBC 3.51 Driver]Acess denied for user
> 'ODBC'@'p3swh044.shr.phx3.secureserver.net'(using password: YES)" message.
> My
> password and user name are correct. I don't know SQL and I am not writing
> it
> by hand. It is all through dreamweaver.
>
> I am using Dreamweaver MX I believe. can anyone help? Thanks!
>

L

LithrielAuthor

Participant

For your information, I grabbed my connection string directly from my host. It's worked before so the string below is not the problem, it's something else. Just so you can see it:

DRIVER={MySQL ODBC 3.51 Driver}; SERVER=p41mysql13.secureserver.net; PORT=3306; DATABASE=lithriel USER=lithriel; PASSWORD=(removed for security); OPTION=0;

It has worked fine in the past. I uploaded my files to overwrite my working ones like you said and now nothing works. Great... final is due in a week....

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'p3swh044.shr.phx3.secureserver.net' (using password: YES)

/acme/catalog.asp, line 26

I think it may have something to do with my server. My host is using an ODBC 3.51.10-2 Driver which refused to let me connect after I changed the name of my database from conAcme to ConAcme and put the file (just changed it to a capital and it had catastrophic errors everywhere). I had to call them up and my professor emailed them the fix. The site started working but since then Dreamweaver has not been able to connect successfully and completely to my database. And now after I uploaded it just to be sure, the site doesn't work all over again. I get the error above when I try to access my page.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.