itlab
Posts: 35
|
| Posted: 11/29/2009, 7:21 PM |
|
Hello friend,
i have finis develope my system localy. And want to upload it to server. After i have upload my system and database to server and try to use my system, this message appear :
Database error: Cannot connect ot Database: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'leo' (using password: NO)
ODBC Error
Session halted.
Please anyone give sollution.
Thank You
|
 |
 |
damian
Posts: 838
|
| Posted: 11/29/2009, 9:01 PM |
|
you need to define the live server connection settings also....
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
itlab
Posts: 35
|
| Posted: 11/30/2009, 5:35 PM |
|
Thank you damian,
how to define live server connection setting? please give me step by step instruction because i am a realy newbie here.
Don't wory damian, if i can't solve my problem here, i will surely post it here as reference fo other people. Sharing is caring. :)
|
|
|
|
damian
Posts: 838
|
| Posted: 12/01/2009, 4:49 AM |
|
in ccs -
click the little drop down and change from Server 1 to Server 2 (or wgatever you have named them)
then go back into project -> settings -> connections ->
you will have been here before and set this up initially but that was only for Server 1
complete the design and server tabs
republish
something i find really useful/easy -
i have a whm/cpanel reseller account
when i create a new hosting account and i give it a username such as user1
when the user (or me) logs in and creates a new database called mydb it is actually called user1_mydb and when they create a mysql user called myuser it is actually called user1_myuser (this is because if the shared hosting - many users could create db's/users with same name).
anyways on my local development computer i also create a db called - user1_mydb and a user user1_myuser. i also create the odbc connection and save it as user1_mydb
on my design tab i nominate the odbc connection and on the server tab i use the values:
<date format>
<boolean format>
use limit
mysql
user1_mydb
localhost
3306
user1_myuser
<password>
dont use persistent
then ccs environment is always connecting to local data source but when published the local datasource is the hosted server, and if i publish manually the details are still correct.
hope this helps
damian
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
itlab
Posts: 35
|
| Posted: 12/02/2009, 7:52 PM |
|
Hello friend,
Finally my problem solve. Thank to you damian. You step by step instruction realy help.  .
From this problem, i can make conclussion that we need to make sure to configure connection and publishing setting work well. Make sure when we click test button, the connection for both was succcesfull. And if you are using ODBC, dont forget to configure it at your cpanel.
That all . Thanks for all your help. I hope this will help all newbies out there
Thak you
|
|
|
|
|
