New Patient Reports

[sunnyreddy]

I am using OD 6.6. I am trying to get the New Patient Report. But I am keep getting this following error.

an unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' Occured in MySql.Data.dll

Additional Information:Illegal Mix of Collations(Latin1_swedish_ci,IMPLICIT),
(utf8_general_ci,COERCIBLE),(Latin1_swedish_ci,IMPLICIT) for operation'concat'

I am not sure what is wrong. your help is greatly appreciated.

thanks
sunny reddy

[prav_n]

Iam not your support person..so can't be sure this will fix your issue..

fromhttp://www.google.com/url?sa=t&source=web&ct=r ... NW8n7Dr0yw


You will need to download the latest nightly snapshot of Connector/J 3.1 from
http://downloads.mysql.com/snapshots.php to see the fix, or wait for the release of
Connector/J 3.1.2.

[jordansparks]

I am using OD 6.6. I am trying to get the New Patient Report. But I am keep getting this following error.

an unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' Occured in MySql.Data.dll

Additional Information:Illegal Mix of Collations(Latin1_swedish_ci,IMPLICIT),
(utf8_general_ci,COERCIBLE),(Latin1_swedish_ci,IMPLICIT) for operation'concat'

I am not sure what is wrong. your help is greatly appreciated.

thanks
sunny reddy

Could this be the problem?:
http://www.opendental.com/manual/mysqls ... ables.html

[sunnyreddy]

Thanks for the help.
Dr.Jordan. I am using windows 2008 Server for my Mysql Data Base. Clients are connecting to this server. here is what I have in my.ini.


[mysqld]
basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.0/"
datadir="C:/mysql/data/"
skip-innodb

[jordansparks]

Are you possibly located outside the US? If so, what country?