By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,457 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

ODBC & Remote Server Connection Problems

P: 3
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
Share this Question
Share on Google+
2 Replies


sashi
Expert 100+
P: 1,754
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

P: 3
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.