Jaz
Posts: 7
|
| Posted: 06/15/2004, 1:11 PM |
|
In evaluating CodeChargeStudio I'm attempting to get the TaskMan example running on either IIS5 or Apache w/ PHP. Neither will work for me.
On Apache I get the following when I try to publish: (note that I simply created the database and enabled access from the PC where I'm running CodeChargeStudio on the remote Linux server using mysql> create database taskman; grant privileges ... -- I didn't create any tables, etc.)
Generating "index"
Error:Record search -> ListBox assign_to : The specified connection does not exist.
Error:Record search -> ListBox project_id : The specified connection does not exist.
Error:Record search -> ListBox priority_id : The specified connection does not exist.
Error:Record search -> ListBox status_id : The specified connection does not exist.
Error:Record search -> ListBox type_id : The specified connection does not exist.
Error:Grid tasks : The specified connection does not exist.
Error:Error occurred while generating the "index" page. (1)
From a browser I see the same errors in another format: This happens also with the CCS_PHPupload example:
Source: ListBox assign_to
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'employees'. (Microsoft OLE DB Provider for ODBC Drivers)
...
etc.
On IIS, I get similar results.
On both IIS and Apache I see curly braces arounf variable names, despite having scripts enabled for ASP and PHP (I have extensive website running on both platforms. Executing any form results in a Page Not Found error, with the URL landing in something like http://server/employees/{Alt_name_Src} (note the curly braces.)
I've come to the end of my ability to muddle through.
Any advise or suggestions?
Thanks
Jaz
|
 |
 |
peterr
Posts: 5971
|
| Posted: 06/15/2004, 1:23 PM |
|
When working with the examples CCS uses the MS Access database that is included by default., but since you're using mysql you'd have to change your connection settings to connect to your MySQL database instead.
See "Server-Side Connections for PHP" section of the documentation at
http://docs.codecharge.com/studio/html/UserGuide/Workin...Connection.html
If using our examples you will also need to create the sample databases using MySQL scripts found in C:\Program Files\CodeChargeStudio\Examples\Internet and C:\Program Files\CodeChargeStudio\Examples\Intranet
Finally, it seems that you're opening the .html pages instead of .php.
Please make sure that your URL contains ".php" at the end. Most servers are configured to open .php first, then open .html if .php was not found. Your server seems to be configured in an opposite way.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jaz
Posts: 7
|
| Posted: 06/15/2004, 2:07 PM |
|
I did create and test ODBC database server connections for the three attempts.
For IIS, all the tables were created and the files uploaded during the Publish process.
For Apache on Linux, only one of them uploaded the files, and neither of them populated the database. I imported the Intranet_MySQL.sql script, but no sql script came with the CCS_PHPupload example -- shoud I try the same Intranet_MySQL.sql script?
As far as .php/.asp loading after .html -- on Apache I've reversed "index.html index.php" to read "index.php index.html" in http.conf DirectoryIndex directive; but on IIS they were already in the proper order: .aspx .asp .html
I went ahead and put Intranet_MySQL.sql into database "emploees" (which I've set as the database to use in the ODBC connection)
Generating "AdvSearch"
Error:Record AdvancedSearch -> ListBox department : The specified connection does not exist.
Error:Error occurred while generating the "AdvSearch" page. (1)
and
Generating "Default"
Error:Grid emps : The specified connection does not exist.
Error:Error occurred while generating the "Default" page. (1
Any other advise?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/15/2004, 2:18 PM |
|
Hi,
Re: "For IIS, all the tables were created and the files uploaded during the Publish process."
I think that this could be true only if you used MS Access because MS Access database consist of files that we provide.
Only MySQL requires that the database is first created, and CCS doesn't create database tables or populates them.
I suspect that since you're talking about IIS then you used ASP with MS Access?
I think that the CCS_PHPupload example uses the 2 sample databases provided with CCS, but it could be best to leave that example till last, until you can get to work the standard examples included with CCS.
I think that now the main problem is that you need to have 2 database connections: InternetDB and IntranetDB (or one of them depending on the example). The database name can be "employees" and can be specified in the Connection settings, but the Connection name itself should not be changed. It should be either InternetDB or IntranetDB (while CCS Example Pack uses both of them).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jaz
Posts: 7
|
| Posted: 06/15/2004, 2:45 PM |
|
Your right... I'm now trying to figure out to import a .sql file -- it's af if M$ thinks they invented SQL and is too proud to recognize the standard format (e.g. no method of importing the data). Some out there in Google land recommends using Query Analizer... this must be a tool that M$ thinks deemed optional because I can't find it on my MS SQL server.
No, I'm not using Access -- our internal website (intranet) is on MS SharePoint, and this would be a subweb (e.g. it's a simple standalone asp application served via IIS and storing its data in an MS SQL server).
The database connection seems to be fine, I think perhaps these are the issues:
1. On Linux/Apache/PHP:
a. when I test the DB connection (through MySQL ODBC driver)
it claims Success!", but what is this error from CCS during Publish:??
Generating "Default"
Error:Grid emps : The specified connection does not exist.
Error:Error occurred while generating the "Default" page. (1)
what is "Grid emps" and why does CCS refer to it as a connection?
I can only find that string in two places file:
<!-- BEGIN Grid emps -->
<!-- END Grid emps -->
Since this is unmodified example code, shouldn't it compile/run?
b. Do all ofthese examples use the same structured SQL database?
c. You said that I only need to initialize the database for MySQL ...
did you mean I just need to create the database and publishing will create the
tables? (I think not, since I was told to import the .sql file).
2. On IIS:
a. How do I import the Intranet_MSSQL.sql file? Which I assume is a problem
due to the below browser output:
Source: ListBox assign_to
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'employees'. (Microsoft OLE DB Provider for ODBC Drivers)
Source: ListBox project_id
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'projects'. (Microsoft OLE DB Provider for ODBC Drivers)
Source: ListBox priority_id
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'priorities'. (Microsoft OLE DB Provider for ODBC Drivers)
Source: ListBox status_id
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'statuses'. (Microsoft OLE DB Provider for ODBC Drivers)
Source: ListBox type_id
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'types'. (Microsoft OLE DB Provider for ODBC Drivers)
Thanks again.
Jaz
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/15/2004, 4:08 PM |
|
Hi,
Well, this begins to look more like a support case than a message to the user community therefore I'd have to send you to our support at http://support.codecharge.com. But let me still answer your last questions:
Re: 1. The connection is created only so that it is available. It then needs to be used within the application and from your error message it looks like it wasn't used/specified in some of the pages/forms.
And besides the Design connection you also need to specify the Server connection, so that the generated programs can also connect to the same or different database.
I'm somewhat puzzled by this problem though and I'm not even sure now if it is related to the database or the server (IIS) or the project, or something else. I just did these 3 steps and the application worked for me out of the box:
1. In CCS selected File -> New -> Project
2. Clicked on Solution -> Task Manager -> Language=ASP3.0 with Templates -> OK
3. Clicked OK to select the default Theme.
4. Opened the "Default" page and clicked "Live Page".
This is it. and I can see the working application.
I recommend that you do the same and only after you do this then you can go a step further and change the database to MS SQL or MySQL, or use PHP instead of ASP.
Re: 1a
The error "Error:Grid emps : The specified connection does not exist." means that the connection name is not specified in the grid called "emps". I cannot even find such grid in our standard Task Management example, therefore I'm not sure where you obtained that example from...
Re: 1b
All our examples use the 2 databases: CCSIntranet and CCSInternet
Re: 1c
You need to create & load any database that is not MS Access.
You only mentioned MySQL previously and I didn't know that you were asking about MS SQL as well.
Although I see now that even though you talked about mysql your error showed "ODBC SQL Server Driver", which indicates that you possibly connected to a wrong database (MS SQL instead of mysql) from PHP.
I'm probably more confused now than you are 
Re: 2
I'd have to ask our database administrator, but I believe that you can load and run the .sql in the Query Analyzer and/or Profiler. I see both of them in Windows -> Start -> Programs -> Microsoft SQL Server, at least on the server I have limited access to.
Hope this helps. Again, try starting with the simple example that utilizes MS Access and works by default.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jaz
Posts: 7
|
| Posted: 06/16/2004, 12:53 PM |
|
Thanks -- I was able to get it mostly working after importing the Intranet .sql file into SQL.
I admit that I now tried to add a column to the database, but after spending hours tweaking the data set, editing code and using the CCS tools, the resulting output from Default.asp is not the Task table -- instead it's a bunch of rows, including several for each Porject type, etc. (I have two tasks but the table is about 50 records long or more.)
CCS is quite a tool, but it's so complicated that I may just need that full 20 days! 
Thanks all
Jaz
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/16/2004, 9:27 PM |
|
This looks good. Now you probably just need to modify your SQL to use "LEFT JOIN" (or do this in the Visual Query Builder as shown at http://docs.codecharge.com/studio/html/UserGuide/Forms/ug282.png - just select "Left Join"), or experiment with joins.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jaz
Posts: 7
|
| Posted: 06/17/2004, 12:13 PM |
|
Boy, I'm trying, but I'm baffled. I can't figure out how to bring up Querry Builder on an existing object. Again, the Default view queries the database and returns a large number of rows when there should be only two. Nothing in the first column (Tasks). I think I've been thourogh enough on the code and the database, but alas, adding a column is not easy.
Perhaps there's an easier way?
Jaz
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/17/2004, 2:10 PM |
|
Take a look at the animation at http://forums.codecharge.com/posts.php?post_id=48203
It's not directly related, but shows specifically how to bring up the Query Builder.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jaz
Posts: 7
|
| Posted: 06/17/2004, 3:55 PM |
|
What I've done now is to create a new grid. Before I have been painstakingly hand-editing field names in the properties section, so I'll avoid that from now on.
The problem I have now is this. As soon as I add additional db tables in the grid Data Source feild, the output blows up -- I get two lines for every record in the new table.
(I'm just trying to mimick the original Task table.)
Very confusing.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/17/2004, 7:49 PM |
|
Jaz,
Again, here is the Support URL: http://support.codecharge.com.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
