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

ODBC & Remote Server Connection Problems

P: 3
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: '' (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

Expert Mod 15k+
P: 31,660
I would guess only a relatively small percentage of members have experience with any type of ODBC drivers. myODBC - even fewer.
I would expect that you would get more help in the MySQL forum but you've tried there :s.
Good luck.
Nov 28 '06 #2

Expert 2.5K+
P: 3,072
Hmm, indeed not much to find about this.
Guess you already explored:<br />
When you leave out the userID/Password from the connection string there should be a popup asking for it.

Did you also try with a shorter username ?

Nov 28 '06 #3

Post your reply

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