Paul Hussey
|
| Posted: 05/06/2002, 8:44 AM |
|
I love this product. I have used Cold Fusion and find it too cumbersome. I
like the way it handles forms/subforms. Anyhow - here's the catch:
Warning: SQL error: , SQL state 00000 in SQLConnect in f:\program
files\apache group\apache\htdocs\asyscare\db_odbc.inc on line 35
Database error: Link-ID == false, odbc_connect failed
ODBC Error: 0 ()
Session halted.
Line 35 if where the odbc_pconnect() function executes but all the
parameters for the connection are empty. Doesn't the properties page set
this up?
Here's the code:
class DB_Sql {
var $Host = "";
var $Database = "";
var $User = "";
var $Password = "";
var $UseODBCCursor = 0;
var $Link_ID = 0;
var $Query_ID = 0;
var $Record = array();
var $Row = 0;
var $Errno = 0;
var $Error = "";
var $Auto_Free = 0; ## set this to 1 to automatically free results
/* public: constructor */
function DB_Sql($query = "") {
$this->query($query);
}
function connect() {
if ( 0 == $this->Link_ID ) {
$this->Link_ID=odbc_pconnect($this->Database, $this->User,
$this->Password, $this->UseODBCCursor);
if (!$this->Link_ID) {
$this->halt("Link-ID == false, odbc_connect failed");
}
}
}
Any takers (i know this is probably - hopefully - a real simple one)
I wonder how many other product evaluators are getting stuck on this and
just giving up?
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/07/2002, 5:28 AM |
|
See common.php file, there should be lines with
data from Site/Properties/Database tab , if you've populated it.
Something like this :
define("DATABASE_NAME","bookstore");
define("DATABASE_USER","");
define("DATABASE_PASSWORD","");
define("DATABASE_HOST","");
--
Alex
CodeCharge Developer
"Paul Hussey" <mhussey@hfx.eastlink.ca> wrote in message
news:ab68cq$mhs$1@news.codecharge.com...
> I love this product. I have used Cold Fusion and find it too cumbersome. I
> like the way it handles forms/subforms. Anyhow - here's the catch:
>
> Warning: SQL error: , SQL state 00000 in SQLConnect in f:\program
> files\apache group\apache\htdocs\asyscare\db_odbc.inc on line 35
> Database error: Link-ID == false, odbc_connect failed
> ODBC Error: 0 ()
> Session halted.
>
> Line 35 if where the odbc_pconnect() function executes but all the
> parameters for the connection are empty. Doesn't the properties page set
> this up?
>
>
> Here's the code:
>
> class DB_Sql {
> var $Host = "";
> var $Database = "";
> var $User = "";
> var $Password = "";
> var $UseODBCCursor = 0;
>
> var $Link_ID = 0;
> var $Query_ID = 0;
> var $Record = array();
> var $Row = 0;
>
> var $Errno = 0;
> var $Error = "";
>
> var $Auto_Free = 0; ## set this to 1 to automatically free results
>
> /* public: constructor */
> function DB_Sql($query = "") {
> $this->query($query);
> }
>
> function connect() {
> if ( 0 == $this->Link_ID ) {
> $this->Link_ID=odbc_pconnect($this->Database, $this->User,
> $this->Password, $this->UseODBCCursor);
> if (!$this->Link_ID) {
> $this->halt("Link-ID == false, odbc_connect failed");
> }
> }
> }
>
> Any takers (i know this is probably - hopefully - a real simple one)
> I wonder how many other product evaluators are getting stuck on this and
> just giving up?
>
>
>
|
|
|
|
Paul Hussey
|
| Posted: 05/09/2002, 5:16 PM |
|
Thought this should be reported here:
There are 2 sections for the database setup, one for 'design time' and one
for 'run time'.
Both need to be configured properly. I wasnt sure from your description
which this was ...
but look at your Properties -> Database page and make sure every field is
filled in.
Note: I refreshed the ODBC connection to the database and that was also part
of the problem, methinks
Many thanks to David Lee
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ab8h9l$rit$2@news.codecharge.com...
> See common.php file, there should be lines with
> data from Site/Properties/Database tab , if you've populated it.
>
> Something like this :
>
> define("DATABASE_NAME","bookstore");
> define("DATABASE_USER","");
> define("DATABASE_PASSWORD","");
> define("DATABASE_HOST","");
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "Paul Hussey" <mhussey@hfx.eastlink.ca> wrote in message
>news:ab68cq$mhs$1@news.codecharge.com...
> > I love this product. I have used Cold Fusion and find it too cumbersome.
I
> > like the way it handles forms/subforms. Anyhow - here's the catch:
> >
> > Warning: SQL error: , SQL state 00000 in SQLConnect in f:\program
> > files\apache group\apache\htdocs\asyscare\db_odbc.inc on line 35
> > Database error: Link-ID == false, odbc_connect failed
> > ODBC Error: 0 ()
> > Session halted.
> >
> > Line 35 if where the odbc_pconnect() function executes but all the
> > parameters for the connection are empty. Doesn't the properties page set
> > this up?
> >
> >
> > Here's the code:
> >
> > class DB_Sql {
> > var $Host = "";
> > var $Database = "";
> > var $User = "";
> > var $Password = "";
> > var $UseODBCCursor = 0;
> >
> > var $Link_ID = 0;
> > var $Query_ID = 0;
> > var $Record = array();
> > var $Row = 0;
> >
> > var $Errno = 0;
> > var $Error = "";
> >
> > var $Auto_Free = 0; ## set this to 1 to automatically free results
> >
> > /* public: constructor */
> > function DB_Sql($query = "") {
> > $this->query($query);
> > }
> >
> > function connect() {
> > if ( 0 == $this->Link_ID ) {
> > $this->Link_ID=odbc_pconnect($this->Database, $this->User,
> > $this->Password, $this->UseODBCCursor);
> > if (!$this->Link_ID) {
> > $this->halt("Link-ID == false, odbc_connect failed");
> > }
> > }
> > }
> >
> > Any takers (i know this is probably - hopefully - a real simple one)
> > I wonder how many other product evaluators are getting stuck on this and
> > just giving up?
> >
> >
> >
>
>
|
|
|
|
|
