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

Report · Jul 07, 2007

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!

Report · Jul 08, 2007

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!
>

In Response To Newsgroup_User · Jul 08, 2007

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.

In Response To Newsgroup_User · Jul 09, 2007

did you try setting the option at 3,

if it was wodking before and not now did you speak to your host.

did you compare your connection sting with any of these.

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

"Lithriel" <webforumsuser@macromedia.com> wrote in message
news:f6sg2d$jcl$1@forums.macromedia.com...
> For your information, I grabbed my connection string directly from my
> host.
> It's worked before. Just so you can see it:
> DRIVER={MySQL ODBC 3.51 Driver}; SERVER=p41mysql13.secureserver.net;
> PORT=3306; DATABASE=lithriel USER=lithriel; PASSWORD=(I took this part
> out);
> 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
>

Report · Jul 09, 2007

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.

Report · Jul 09, 2007

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.
>