** Using WeBWorK **

Hi Rodrique,

I haven't tried this, but it seems to me that it should work to set $database_dsn in the global.conf file to dbi:mysql:database=webwork:host=hostname, or whatever the appropriate string is. If you have it available, then I'd be tempted to try and if it doesn't work post a follow-up so that we can figure out why it doesn't.

Mike or Sam would be a better source for an answer to this, however.

Gavin

As Gavin points out, you can do this with DBD::mysql (which is the only driver that WeBWorK supports at the moment). There's no need to resort to ODBC. The complete syntax for DSNs is documented in the connect method of DBD::mysql. The complete syntax is supported by WeBWorK's $database_dsn. For example:

$database_dsn = "dbi:mysql:database=webwork;host=db.math.yourschool.edu";

Hope this helps!
-sam