Devart Forums

G'day Guys,

Sorry if this is a Noob Question, I'll shoot anyway....

I'm trying to use MySQLDirect for the first time and can successfully connect to a database with a name such as 'my_Database'

The problem arrises when I try to connect to a database with a name that includes an underscore followed by a lower case character. eg. 'my_database'. The database name property of the connection is automatically chaned to an uppercase character after the underscore. ie. 'my_Database' and as this is the incorrect database name, I can't connect !

I tested this on a database with an underscore and then a Uppercase letter and I can connect fine, if I try to connect to a database with an underscore followed by a lowercase letter, MySQLDirect seems to change the database name automatically to an uppercase after the underscore.

Am I doing something really dumb ??

We improved connection pooling in MySQLDirect .NET.
Don't use database names that differ only in case, or do not use pooling until we release next build.

Unfortunately the database is already in existence so changing it's name would throw a heap of web sites that access it into a real pile of trouble. So that's not an option...

What do you mean by 'do not use pooling' ?

I haven't come across that before

I played with it again and found the 'spooling' property. Which I set to false and that seems to have fixed it.

Thanks for the quick response, I don't know what it means, but hey ?? It worked right ??

Cheers,

Hammo