Welcome Guest, Not a member yet? Register   Sign In
Active Record Connect to MySQL 4.0 Database
#1

[eluser]kabbink[/eluser]
Hey guys,

I am trying to make a remote Active Record connection to an older server running MySQL 4.0.26.

The problem I am having is I keep getting the error

Quote:Unable to set client connection character set:

My connection info is as follows:

Code:
$db['npt']['hostname'] = "server.com";
$db['npt']['username'] = "remoteuser";
$db['npt']['password'] = "remotepass";
$db['npt']['database'] = "remotedb";
$db['npt']['dbdriver'] = "mysql";
$db['npt']['dbprefix'] = "";
$db['npt']['pconnect'] = TRUE;
$db['npt']['db_debug'] = TRUE;
$db['npt']['cache_on'] = FALSE;
$db['npt']['cachedir'] = "";
$db['npt']['char_set'] = "utf8";
$db['npt']['dbcollat'] = "utf8_general_ci";

I tried just not setting the char_set but then I also get a ton of errors.

Any help would be appreciated as I don't think I am going to be able to upgrade the MySQL server.

Thanks a lot for any ideas!
Kevin


Messages In This Thread
Active Record Connect to MySQL 4.0 Database - by El Forum - 06-11-2008, 01:25 PM
Active Record Connect to MySQL 4.0 Database - by El Forum - 06-11-2008, 05:16 PM
Active Record Connect to MySQL 4.0 Database - by El Forum - 06-11-2008, 05:18 PM



Theme © iAndrew 2016 - Forum software by © MyBB