ynapky
|
| Posted: 10/19/2002, 11:20 AM |
|
I build the project and make the connection1 in windows, then i created the
database on the sever with MySql, and i install the MyODBC in the client
(windows), test sucessful.
well, i publish the project, but the database tables doesn't created at the
server.
then, i convert the access file to mysql, and run the query for test the
database, but equal.
I apply all the settings to the project and test the connection but always
the same anwers (Database error: cannot use database
MySQL Error: 1046 (No Database Selected)
Session halted.)
Sorry about my English
Thanks for Help.
|
|
|
 |
Nicole
|
| Posted: 10/21/2002, 5:02 AM |
|
Hello,
Looks like the problem is related rather to mysql than to CC (or CCS). Have you crated tables for the DB? Test them directly from mysql first, then connection to it from CC. You can try using MySQL Front, available at http://www.anse.de/mysqlfront/ , which makes it easier to work with MySQL.
As for error you’re getting, it means that you haven’t specified DB name in DSN settings (if you’re using DSN connection). Please check it.
|
|
|
|
Ralph
|
| Posted: 10/24/2002, 5:52 PM |
|
Hello,
I must say I have the same problem, I have created the DSN connection and tested my connection. I can create the tables manually, but I thought that CC can do that during design-publish time. If I must to create the tables manually, where can I see a listing of all the tables that I need to create?..Thanks in advance.
Ralph
|
|
|
|
|
