ODBC & Remote Server Connection Problems

[dronkanoki]

I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error:

[MySQL][ODBC 3.51 Driver]Access denied for user: '[e-mail]' (Using password: YES)

I had MySQL installed locally for testing, and myODBC worked fine. All the other apps I use locally (Dreamweaver, PHPmyAdmin, MySQL Front) work great on the remote server with the same login info.

This is my thought (patience, please). My username for the remote db provider is 22 characters long. in the error message above my username is clipped to 16 characters. So here (finally) are the questions:

1. Does MyODBC have a character limit and if so is there a work around?
2. Can I get MyODBC to prompt me for username & password?

By the way, I downloaded OpenLink ODBC, Installed it and received this one:

S1000: (OpenLink)(ODBC)Unable to allocate server handle

Apparently my remote db doesn't want to talk to me.

I didn't get a response from OpenLink, and MySQL Forums are silent on the subject. Please guys, any help would be greatly appreciated

[sashi]

I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error:

[MySQL][ODBC 3.51 Driver]Access denied for user: '[e-mail]' (Using password: YES)

I had MySQL installed locally for testing, and myODBC worked fine. All the other apps I use locally (Dreamweaver, PHPmyAdmin, MySQL Front) work great on the remote server with the same login info.

This is my thought (patience, please). My username for the remote db provider is 22 characters long. in the error message above my username is clipped to 16 characters. So here (finally) are the questions:

1. Does MyODBC have a character limit and if so is there a work around?
2. Can I get MyODBC to prompt me for username & password?

By the way, I downloaded OpenLink ODBC, Installed it and received this one:

S1000: (OpenLink)(ODBC)Unable to allocate server handle

Apparently my remote db doesn't want to talk to me.

I didn't get a response from OpenLink, and MySQL Forums are silent on the subject. Please guys, any help would be greatly appreciated

Hi there,

Since you are dealing with Linux, am sure the Linux server is behind firewall. Make sure remote connection is accepted by the Linux server.

[dronkanoki]

Hi there,

Since you are dealing with Linux, am sure the Linux server is behind firewall. Make sure remote connection is accepted by the Linux server.

Thanks Sashi-I was getting lonesome

Is there a difference between an ODBC connection and connections from Dreamweaver, MySQL Front or PHP? All are using the same Port and Login info., but at this point nothing would surprise me.