warmowski
|
| Posted: 08/25/2005, 8:46 PM |
|
hi all
i'm evaluating ccs 2.3.2.27. i have installed the mysql odbc 3.51 driver.
the driver configuration panel "test" button works fine. i am connecting to a remotely hosted mysql db
but back at ccs connection window, hitting ok errors with
Test connection failed with provider initialization error.
[MySQL][ODBC 3.51 Driver]Access Denied for user 'username@this-isp-blah-blah.net' to database 'thedatabase'
the hosting company says that i don't need grant() to be turned on. they are getting me connection logs so i can see what exactly is going on. in the meantime... anybody have any idea?
thanks
-r
|
|
|
|
Walter Kempees
|
| Posted: 08/25/2005, 11:12 PM |
|
When you use a local tool to access your remote MySQL Database, does it
connect ?
It seems like a username/password/databaseinstance problem.
Await your ISP logs
"warmowski" <warmowski@forum.codecharge> schreef in bericht
news:5430e907a7d9b5@news.codecharge.com...
>
> hi all
>
> i'm evaluating ccs 2.3.2.27. i have installed the mysql odbc 3.51 driver.
>
> the driver configuration panel "test" button works fine. i am connecting
> to a
> remotely hosted mysql db
>
> but back at ccs connection window, hitting ok errors with
>
> Test connection failed with provider initialization error.
> [MySQL][ODBC 3.51 Driver]Access Denied for user
> 'username@this-isp-blah-blah.net' to database 'thedatabase'
>
> the hosting company says that i don't need grant() to be turned on. they
> are
> getting me connection logs so i can see what exactly is going on. in the
> meantime... anybody have any idea?
> thanks
>
> -r
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
warmowski
|
| Posted: 08/26/2005, 8:17 AM |
|
hi:
i just used mysql administrator 1.1 to connect: it worked outside of complaining about the mysql version being prior to v4 (the hosted db is mysql v 3.2.3.58. connection was established.
i have noticed that ccs error reporting under the 'connection' object is not great. for example, (under server tab) i changed the ip address in the host field and hit ok and i got an identical error.
Posted: 08/25/2005, 11:12 PM
--------------------------------------------------------------------------------
When you use a local tool to access your remote MySQL Database, does it
connect ?
It seems like a username/password/databaseinstance problem.
Await your ISP logs
|
|
|
|
warmowski
|
| Posted: 08/26/2005, 8:23 AM |
|
suppose ill post all the values i have in this failing connection
design side:
connection name: connection1
database: mysql
use odbc dsn: nameofdb
username: correct username
password: correct password
server side:
php database library: mysql
database or odbc conn name: nameofdb
host: xx.xx.xx.xx
port: blank (tried 3306 no difference)
login: correct username
passwd: correct pw
persistent connection: yes
|
|
|
|
Damian Hupfeld
|
| Posted: 08/28/2005, 5:15 AM |
|
I would double check that your database is actually called NAMEOFDB and not
USERNAME_NAMEOFDB
I would also change your hostname to localhost
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
"warmowski" <warmowski@forum.codecharge> wrote in message
news:5430f340706653@news.codecharge.com...
> suppose ill post all the values i have in this failing connection
>
> design side:
>
> connection name: connection1
> database: mysql
> use odbc dsn: nameofdb
> username: correct username
> password: correct password
>
> server side:
> php database library: mysql
> database or odbc conn name: nameofdb
> host: xx.xx.xx.xx
> port: blank (tried 3306 no difference)
> login: correct username
> passwd: correct pw
> persistent connection: yes
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Langston Campbell
|
| Posted: 08/28/2005, 6:30 PM |
|
First I would like to point out that ccs has 2 connections to a database.- design time and run time.
At design time the database connection is used to retrieve table names, field names, attributes, etc.
At run time you actually manipulate the data in the database set up under the "server" tab of the project set up on CCS.
Believe it or not, and not that I suggest it, but the 2 databases don't even have to be of the same kind!!! You can use a local Access database at dersign time and a remote MySQL database at run time. As long as the table names, field names and attributes are the same and compatible it will work.
Now, the database you are having trouble with is the design time database. I have a copy of MySQL on my local computer and always build an image of the database (without data) on my local computer and point to it. The frequent problem I have with remote MySQL databases is that sometimes ISP's don't allow remote access to their MySQL databases (GoDaddy is one of those ISP's). Because the database request comes from the localhost (hosting computer) at runtime, your application will run. But at design time, the request comes from your local PC and some ISP's don't allow remote connection to MySQL server.
I have a virtual hosting account with MySQL which DOES allow remote connection. In this instance, for security sake I am forced to log onto my MySQL server and set up permissions for user, database and sometimes location (IP address) in order to connect.
In conclusion, my suggestion is to download a free copy of MySQL from their site to run on your computer (Linux or Windows). Build your database tables locally and connect CCS via ODBC to your local database.
|
|
|
|
|
 |
|
|
|
