Ryan Lim
|
Posted: 05/27/2001, 4:17 AM |
|
I have been trying but to no success, maybe someone can help me.
I am running Apache, with PHP4 with Mysql on my Win98 machine.
1) What is the setting of the Server Database setting to use the examples
on codecharge? I was trying the YellowPages.cc and bugtrack, error
as below.
Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or
buffer length, SQL state S1090 in SQLConnect in c:\program files\apache
group\apache\htdocs\db_odbc.inc on line 30
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
2) I build a simple application to try out and I used PHP with templates.
The test.php pages
would show my MysQl records correctly but the test.html would show no
records. Basically,
I figured that test.html should be edited using Dreamweaver or something,
but how do I show
my test.php records?
Thank you
|
|
|
CodeCharge
|
Posted: 05/27/2001, 1:43 PM |
|
Re: 1
Since you are asking about the Server Database, I'm assuming that you can
connect to the database from within CC and the error happens after you
generate the programs.
Your best bet is to run the programs on the same machine where MySQL is
installed. You only need to specify the Database Name, Login and Password
(plus "MySQL" as type) If the database is on another server, you need to
specify in addition the "Host", which is the IP address to your database.
Re: 2
If you generate "PHP & Templates", you will generate both test.php and
test.html, but "test.php" is the only program that you should run. Please do
not run or open test.html. This is a file that is opened in the background
by test.php. Basically, test.php opens test.html, replaces {bracketed}
sections with database values and outputs it to the browser.
You may modify test.html in Dreamweaver only if you want to change the
layout or colors, add some graphics, or move fields around. In the test
phase there should not be a need to do this.
"Ryan Lim" <ideasmiths@yahoo.com> wrote in message
news:9eqnp6$ji$1@mail.tankhill.com...
> I have been trying but to no success, maybe someone can help me.
> I am running Apache, with PHP4 with Mysql on my Win98 machine.
>
> 1) What is the setting of the Server Database setting to use the examples
> on codecharge? I was trying the YellowPages.cc and bugtrack, error
> as below.
>
> Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or
> buffer length, SQL state S1090 in SQLConnect in c:\program files\apache
> group\apache\htdocs\db_odbc.inc on line 30
> Database error: Link-ID == false, odbc_pconnect failed
> ODBC Error: 0 ()
> Session halted.
>
> 2) I build a simple application to try out and I used PHP with templates.
> The test.php pages
> would show my MysQl records correctly but the test.html would show no
> records. Basically,
> I figured that test.html should be edited using Dreamweaver or something,
> but how do I show
> my test.php records?
>
> Thank you
>
>
|
|
|
|