469,926 Members | 1,497 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

ODBC & Remote Server Connection Problems

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: 'username@ipaddress.serviceprovider.net' (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
Nov 28 '06 #1
2 5733
sashi
1,754 Expert 1GB
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: 'username@ipaddress.serviceprovider.net' (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.
Nov 28 '06 #2
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.
Nov 29 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Todd Huish | last post: by
12 posts views Thread by Remco Groot Beumer | last post: by
5 posts views Thread by Alec | last post: by
1 post views Thread by pradeep | last post: by
2 posts views Thread by bcbrock | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.