jmartin
Posts: 26
|
| Posted: 01/19/2010, 12:14 PM |
|
[Resolved] ... Can anyone recommend a windows installer for Windows XP Pro using IE 8 Apache PHP MySQL DB2 ODBC to iSeries to support CodeCharge Studio 4.3
Thanks.
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail:jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 01/19/2010, 8:25 PM |
|
jmartin,
Is this for development or production??
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/20/2010, 4:32 AM |
|
Its for both.
I have since this question installed XAMPP but I see it is for development.
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail:jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
datadoit
|
| Posted: 01/20/2010, 5:51 AM |
|
You can use things like XAMMP or WAMP for a production environment, you
just have to go through the configs and tighten things up a bit. It
will get you in the door, now you just have to lock the door behind you.
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/20/2010, 8:19 AM |
|
I understand.
I generated a example PHP Forum using Application Builder. It has
Publishing to "C:\Inetpub\wwwroot\FORUM"
Publish Project - 0 critical error(s), 0 error(s), 0 warning(s)
but when I click on home page in a browser the URL is: http://localhost/FORUM/Default.php
and it displays:
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
1/20/2010 8:39:06 AM
Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
localhost goes to: http://localhost/xampp/
and displays: XAMPP for Windows
I can find where I change http://localhost\ to C:\Inetpub\wwwroot\
Any thoughts>
Thanks.
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail:jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
ckroon
Posts: 869
|
| Posted: 01/20/2010, 11:00 AM |
|
If you used wamp you have to publish to C:\wamp\www\
So change C:\Inetpub\wwwroot\ to C:\wamp\www\
Not sure how Xamp works but it may be similar.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 01/21/2010, 4:54 AM |
|
jmartin
For XAMPP (assuming you kept the default installation) you should post all web files to "c:\xampp\htdocs". XAMPP out of the box is for development but if you wish to use it for Production then read the "readme_en.txt" file in the XAMPP directory. It will give you information on harding the installation for Production use.
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/21/2010, 6:22 AM |
|
mamboBROWN:
I republished the example to: C:\xampp\htdocs\ and it works.
I have an iSeries 270 that I have a ODBC setup for telnet sessions. I created another ODBC connection called JMALIB. I tested it with winsql using: select * from jmalib.progdef and it worked OK.
In CodeCharge Studio 4.3 I have in the Design:
connection name: JMALIB
Database: DB2
use ODBC Data Source Name: JMALIB
JMALIB is configured using Client Access ODBC driver(32-bit) assigning Data Source Name: JMALIB
System: 192.168.1.107
Server
Naming Convention: SQL naming convention(*SQL)
SQL default library: QGPL
Library list: JMALIB
Connect type: Use ODBC access mode
Connection Server has:
PHP Library: ODBC Database: DB2
Database or ODBC connection name: JMALIB
When I click OK on the connection, I get no errors.
When I publish the application I get:
Generating "PROGDEF_list"
Publishing to "C:\xampp\htdocs\JMADOCS"
Generating "PROGDEF_list"
Generating Common Files
Generating "Header"
Generating "Footer"
Publishing to "C:\xampp\htdocs\JMADOCS"
Generating "PROCCMT_list"
Generating "PROCDFL_maint"
Generating "PROGDEF_maint"
Generating "PROGDEF_list"
Generating "FFDEFTEXT_list"
Generating "FFDEFTEXT_maint"
Generating "FFDEFWKEY_list"
Generating "FFDEFWKEY_maint"
Generating "FFPCOMNT_list"
Generating "FFPCOMNT_maint"
Generating "FILEDEF_list"
Generating "FILEDEF_maint"
Generating "FILEDUC_list"
Generating "FILEDUC_maint"
Generating "Footer"
Generating "Header"
Generating "PROCCMT_maint"
Generating "PROCDFL_list"
Generating "PSDEFWKEY_list"
Generating "PSDEFWKEY_maint"
Generating Common Files
Publishing to "C:\xampp\htdocs\JMADOCS"
Publish Project - 0 critical error(s), 0 error(s), 0 warning(s)
but when I take the selection: Live PROGDEF_list in a browser I get the error:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\JMADOCS\db_odbc.php on line 58
Database error: Cannot connect ot Database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ODBC Error
Session halted.
In the
function connect() {
if (!$this->Connected)
{
$this->Query_ID = 0;
if ($this->Persistent)
$this->Link_ID=odbc_pconnect($this->DBDatabase, $this->DBUser, $this->DBPassword, $this->UseODBCCursor);
else
--line 58-- $this->Link_ID=odbc_connect($this->DBDatabase, $this->DBUser, $this->DBPassword, $this->UseODBCCursor);
if (!$this->Link_ID) {
$this->Halt("Cannot connect ot Database: " . odbc_errormsg());
return false;
}
foreach ($this->Options as $option) {
@odbc_setoption($this->Link_ID, $option[0], $option[1], $option[2]);
}
$this->Connected = true;
}
}
I get the error in --line58-- above. It is like its not passing the right signon and database parms.
Any ideal what could be wrong.
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail:jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 01/21/2010, 2:16 PM |
|
jmartin,
It appears that you have everything setup correctly. Do you also have "use ODBC cursor" checked as well?? If you do uncheck it and try it again or if you don't then check it and try again. Let me know what happens.
I'm also assuming that you have the ODBC (JMALIB) created on the computer where you uploaded the code.
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/21/2010, 3:12 PM |
|
I found out that I needed to setup the DSN in the ODBC configuration.
everything works Ok now.
I do wish it was easier to add a background image to the style sheet or somewhere for the body of each document to have a certain look. Like my website has a textured background. I use a RAD tool that has a template that I modify to obtain the look I want. It generates:
as an example the body statement <body background="Brown_bg.gif"> or like the statement:
<body onload="na_preload_img(false, 'nav_17_network_chr.gif', 'nav_19_business_cvr.gif', 'nav_17_personal_chr.gif', 'nav_19_synopsis_cvr.gif', 'nav_19_summary_cvr.gif', 'nav_19_resume_cvr.gif');" background="Brown_bg.gif">
Have a great day.
Thanks.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
joejac
Posts: 242
|
| Posted: 01/21/2010, 3:19 PM |
|
Hello Martin,
Have you tried this one?
http://www.uniformserver.com/
I have used for years with no problem, very nice, simple, unobtrusive and stable.
Regards
joejac
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/21/2010, 3:51 PM |
|
I found where you can change the background on a docment.
when you click on the document in the project explorer it opens the document in the document window. There you can do a right click on the document and go to the background tab and it will let you select a image for the background which is what I wanted.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
damian
Posts: 838
|
| Posted: 01/21/2010, 4:20 PM |
|
james - set the background in the style sheet - you dont need to update every page then.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/21/2010, 6:42 PM |
|
I tried to find where you could modify the style sheet but the background selection does not give you the option of using a image?
Is there another place?
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
damian
Posts: 838
|
| Posted: 01/22/2010, 5:08 PM |
|
body {background-image:url('../../images/image.jpg')}
please note that the path is relative to the STYLE SHEET....
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/23/2010, 8:13 AM |
|
This worked.
By editing the Style.css and the Style_doctype.css
I replaced ..... :
.PageBgColor {
background-color: #e6decf;
}
with.....:
.PageBgColor {
background-image:url('Images/Brown_bg.gif');
}
and I added to.....:
body {
font-family: Arial; font-size: 80%;
}
This.....:
body {
background-image:url('Images/Brown_bg.gif');
font-family: Arial; font-size: 80%;
}
Thanks for the help.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 01/24/2010, 3:23 PM |
|
jmartin
Assuming that your question(s) has been answered, could you please add [Resolved] or [Solved] to this threads title. Thanks.
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/26/2010, 1:28 PM |
|
[Resolved]
Thanks everybody
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
jmartin
Posts: 26
|
| Posted: 01/27/2010, 2:01 PM |
|
Quote jmartin:
[Resolved] ... Can anyone recommend a windows installer for Windows XP Pro using IE 8 Apache PHP MySQL DB2 ODBC to iSeries to support CodeCharge Studio 4.3
Thanks.
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 02/03/2010, 5:50 AM |
|
jmartin
Sorry to be a bother but If possible can you put [Resolved] in the title of this thread instead of the body. Thanks.
|
|
|
|
jmartin
Posts: 26
|
| Posted: 02/03/2010, 6:08 AM |
|
mamboBROWN:
No bother.
Have a great day.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
