List Info

Thread: Trouble connecting to a database with a dash in its name (1.0.9)




Trouble connecting to a database with a dash in its name (1.0.9)
user name
2007-02-13 14:43:19
Hellos,

I upgraded to 1.0.9 And I can't connect to databases
containing dashes 
in their names anymore. Or maybe it's because I have a dash
in my user 
name... Can anyone help me with this, please?

The errors:
Connecting to database try #1:
Error connecting to the database!
MySql.Data.MySqlClient.MySqlException: 
You have an error in your SQL syntax. Check the manual that
corresponds 
to your MySQL server version for the right syntax to use
near 
'-last_part_of_db_name_with_dash_in_it' at line 1 at...

Ok, so I enclose the db name in ``

Connecting with database name enclosed in ``:
Error connecting to the database!
MySql.Data.MySqlClient.MySqlException: 
Access denied for user: 'my-dash_username%' to
database 
'`my-dash_database`' ...

So i enclose the user name in `` also:
Error connecting to the database!
MySql.Data.MySqlClient.MySqlException: 
Access denied for user: '`my-dash_username`my_IP'
(Using password: YES) 
...




-- 
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/
dotnet
To unsubscribe:    http://lists
.mysql.com/dotnet?unsub=bondyahoo.com


[1]

about | contact  Other archives ( Real Estate discussion Medical topics )