Frans
|
| Posted: 06/25/2003, 5:45 AM |
|
Hello,
I've setup the examplepack for Codecharge Studio. The problem is that the CCS examplepack will not use my defined Mysql ODBC driver.
This is what i did so far.
Made an internetDB and intranetDB database in MySQL Front. Imported the internet_MySQL.sql and intranet_MySQL.sql files in the my SQL Query tab. All went succesfull. Specified the privileges for the user who will connect to these databases and then logged in as that account in MySQL Front. So far so good.
Then i've made the MySQL ODBC drivers for these 2 databases. All went well, because the TEST DATASOURCE BUTTON said Data Source 'internetDB'and 'intranetDB'
Connected Succesfully to 'Mysqld-4.0.1-alpha-nt'!!!
The problem is now when i click on Publish Project i get the following output and errors.
Generating "EditableGridAutoRows\EditableGridAutoRows_desc"
Generating "Default"
Generating "Directory\Directory"
Generating "Directory\Directory_desc"
Generating "DirectoryMaintenance\DirectoryMaintenance"
Generating "DirectoryMaintenance\DirectoryMaintenance_desc"
Generating "EditableGridAddButton\EditableGridAddButton"
Error:EditableGrid departments -> ListBox manager_id : The specified connection does not exist.
Error:Error occurred while generating the "EditableGridAddButton" page. (1)
The connection names in Codecharge Studio are internetDB and intranetDB pointing to the databases i've setup for this.
I use WinXP, Mysql ODBC driver 3.51, Apache with PHP4 and Codecharge Studio 2.1.20
Thanks,
Frans
|
|
|
 |
Jon Phipps
|
| Posted: 06/25/2003, 10:03 AM |
|
Hi Frans,
You're using my exact setup. 
Each CCS connection has two parts:
an ODBC connection defined for the CCS GUI
and another connection that's specific to the needs of your chosen language's dbms package.
I'm going to guess that you're missing that second part of the connection. Even if you're not, here's all of the entires from my setup that's working...
If you select 'Connections' from the Project Explorer and then select the connection for InternetDB you should see the following entries in the 'Data' Properties on the right hand side of the screen:
Name
InternetDB
Desiqn Data Base Type
MySQL
Connection Type
Connection Strinq
Connection String
Provider=MSDASQL.1;Password=phipj;Persist Security Info=True;
User ID=root;Extended Properties="DSN=CCSInternet_mysql;
DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=Internet;SERVER=localhost;
UID=<your userid>;PASSWORD=<your password>;PORT=3306;OPTION=3;STMT=;"
Login
<your userid>
Password
<your password>
Server Data Base Type
MySQL
Date Format
yyyy-mm-dd HH:nn:ss
Boolean Format
true, false
Catalog
Schema
Views
Yes
Synonyms
Yes
System Tables
No
System Views
No
Aliases
No
PHP 4.0 with Templates
PHP Data Base Library
MySQL
Server Data Base Name
Internet
Server Host
localhost
Server Port
3306
Server Login
<your userid>
Server Password
<your password>
Server Persistent Connection
No
You can either edit these directly in the 'Properties' page or display the connection dialog box by clicking on the 'Connection String' property, clicking on the elipsis that appears and then selecting the 'advanced' tab in the dialog box.
Hope this helps,
Jon
|
|
|
|
|
