My Situation is a little different. My Apache and Oracle client exist on my Solaris server. The actual Oracle database lives on a Windows server. So I access the database using USERID@SID login.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey I had the same problem but I was using Apache and MySQL that I did was to change the path on the .htaccess file and it works, maybe it was my luck because I don't know programming I was just guessing
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Forgot to add, a page flashes up just before the blank page but it happens too quickly to see what it is. The blank page is genieConfiguration.inc.php.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I'm using Windows NT with php/IIS, and accessing a remote MSSQL server. I was getting the same problem, but I found a workaround! :)
Instead of using the Genie to access a MS SQL Server DB, I created an ODBC DSN http://www.builderau.com.au/architect/database/print.htm?TYPE=story&AT=20283164-39024547t-20000985c
& then I used the genie to access that.
My next step is to get familiar with the PCG framework...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I guess I spoke too soon, even with ODBC I just get the list of tables. It can't seem to access the table structure (no fields for the tables).
What to do next I wonder....
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I got code genie to work by modifying rubLamp.inc.php (in \web\common).
At line 19 I insert
<OPTION VALUE="odbc_mssql">odbc_mssql</OPTION>
Then when I have the "rub the lamp" form, I enter in the connection string in the 2nd field:
Driver={SQL Server};Server=xxxxx;Database=xxxxx;
Everything then works fine.
Having played around with PCG, I think I will use it for a project. However, the SQL I get is flawed
-No distinction between varchar and int : sql comes out a bit like this :
Insert into mytable (myIntField, myStringField) values ('1', 'foo')
-Can't insert or update a record so a field gets the NULL value.
I probably will end up modifying the genie at my end...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had the same problem on a WinXp machine running Apache 2.0 with PHP 5 and MySQL, I modified the path into .htaccess file but it didn't worked, then I added the include path (.../phpcodegenie3/app/settings) to the include_path into the PHP.INI file, after I restarted Apache everything was OK!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My front page comes up fine. I key in the required fields, click on the lamp, and get a blank page. My particulars:
Platform: Sun Ultra 2 running Solaris 2.8
Apache 1.3.24
PHP 4.2.1
Oracle database 8.1.7
I currently have existing php applications accessing the Oracle database, so I know the Apache and PHP are configured OK.
Any ideas??? Thanks.
did you try both the OCI8 and the Oracle option??
When I connect to oracle.. in the Hostname.. i use the oracle SID that's set on my oracle client on my machine and it works fine..
My Situation is a little different. My Apache and Oracle client exist on my Solaris server. The actual Oracle database lives on a Windows server. So I access the database using USERID@SID login.
This is Happening with me too, but i using MS SqlServer....in Local Host, using Windows.
Hey I had the same problem but I was using Apache and MySQL that I did was to change the path on the .htaccess file and it works, maybe it was my luck because I don't know programming I was just guessing
I'm getting this problem on apache and mysql. It is driving me crazy!
Truscamarusca - what did you change the path to and from in .htaccess?
Anyone got any other ideas?
Forgot to add, a page flashes up just before the blank page but it happens too quickly to see what it is. The blank page is genieConfiguration.inc.php.
Hi, I'm using Windows NT with php/IIS, and accessing a remote MSSQL server. I was getting the same problem, but I found a workaround! :)
Instead of using the Genie to access a MS SQL Server DB, I created an ODBC DSN http://www.builderau.com.au/architect/database/print.htm?TYPE=story&AT=20283164-39024547t-20000985c
& then I used the genie to access that.
My next step is to get familiar with the PCG framework...
I guess I spoke too soon, even with ODBC I just get the list of tables. It can't seem to access the table structure (no fields for the tables).
What to do next I wonder....
I got code genie to work by modifying rubLamp.inc.php (in \web\common).
At line 19 I insert
<OPTION VALUE="odbc_mssql">odbc_mssql</OPTION>
Then when I have the "rub the lamp" form, I enter in the connection string in the 2nd field:
Driver={SQL Server};Server=xxxxx;Database=xxxxx;
Everything then works fine.
Having played around with PCG, I think I will use it for a project. However, the SQL I get is flawed
-No distinction between varchar and int : sql comes out a bit like this :
Insert into mytable (myIntField, myStringField) values ('1', 'foo')
-Can't insert or update a record so a field gets the NULL value.
I probably will end up modifying the genie at my end...
I had the same problem on a WinXp machine running Apache 2.0 with PHP 5 and MySQL, I modified the path into .htaccess file but it didn't worked, then I added the include path (.../phpcodegenie3/app/settings) to the include_path into the PHP.INI file, after I restarted Apache everything was OK!