sweiss
Posts: 22
|
| Posted: 02/03/2005, 4:46 AM |
|
Hi,
i have a problem connection from CCS to MySQL via ODBC on a new Workstation:
XP Pro
local MySQL 4.1.8
I tried MyODBC-3.51.10-2 and MyODBC-3.51.10
with both versions i can create a ODBC-Connection, Test says everything is ok, ODBC-Connection from Office programs (i. E. Excel, Acccess) is ok.
If i try to setup a Connection in CCS i get a errormessage:
Access denied for User "@'%' to database 'my_database'
Any Idea?
Regards
Stefan
|
 |
 |
peterr
Posts: 5971
|
| Posted: 02/03/2005, 10:57 AM |
|
Did you enter a login and password in CCS connection dialog? If so, try removing it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
sweiss
Posts: 22
|
| Posted: 02/04/2005, 1:05 AM |
|
Hello Peter,
i tried both. I tried to setup the connection new.
On the Design Tab - i check "Use ODBC Datasource Name", on the Server Tab i setup the Connection Data for the Server. This is a older Project, i tried to generate the Files an they are running fine but i cannot create new Pages (PHP).
Help please
Stefan
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/04/2005, 11:35 AM |
|
This could mean that the acess is denied from this computer (although maybe not from the server).
Unfortunately I don't have ideas why this doesn't work, but possibly this could help: http://www.google.com/search?hl=en&q=mysql+%22Access+denied+for+User%22
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
sweiss
Posts: 22
|
| Posted: 02/06/2005, 11:33 PM |
|
Hello Peter,
this is a problem from CCS, because i can connect from the same machine with any other program. F. E. Excel, Access!
Any idea?
Stefan
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/06/2005, 11:43 PM |
|
Sorry I don't have ideas, but hopefully either Google or our support can help with this.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Nicole
Posts: 586
|
| Posted: 02/07/2005, 2:45 AM |
|
Hello,
Please note that when you moved to MySQL4.1 the database passwords were changed. Please check your project settings (both Design time and Server side) to make sure database password is updated there too.
_________________
Regards,
Nicole |
|
|
|
sweiss
Posts: 22
|
| Posted: 02/07/2005, 2:58 AM |
|
Ok,
no i have a solution. I've changed the connection type in the Design to 'Use Connection String'
Provider=MSDASQL.1;Persist Security Info=False;Data Source=mydatabase
without username and password - now it works.
Stefan
|
|
|
|
