James McKenzie wrote:
Doug Thompson wrote:
Hello:
OOo2.0.4 /Win98
First, I haven't had prior need to use JDBC. Thus, I'm in unfamiliar
territory.
Mysql is running and I use SQLyog as my primary admin tool. No
problems there.
When going through the steps in the OOo database wizard, everything is
fine up to the point of testing the database connection, which is to
say, the jdbc driver loads. I just installed
mysql-connector-java-5.0.4 in order to ensure the driver is most up to
date. I'm using Mysql 4.1.12
When I attempt to test the database connection, I get one of two errors.
(1)
"Unknown initial character set index '48' received from server.
Initial client character set can be forced via the 'characterEncoding'
property."
or
(2)
"Access denied for user [EMAIL PROTECTED] using password XXX where XXX is
either Yes or No depending on what was tried. Passwords are used on
all user accounts.
I have specified "?characterEncoding=utf8" as part of the datasource
URL which partly eliminated the first error. It used to be thrown
every attempt. Now the error changes with the username and I suspect
it relates to mysql privileges, but that isn't the trouble I'm
shooting at the moment.
Any guidance and insight about accomplishing jdbc connections are
appreciated.
Doug:
Some questions on your use of the MySQL JDBC connector:
1. Where is your MySQL server located? Local or Remote machine?
2. If the database is remote, what is the operating system of the
remote machine?
Thank you.
James McKenzie
Mac OS X QA/Test Team Lead
It's local for now, but once I get the bugs worked out, normal service
will use a remote database on a linux server.
DT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
