Don Gollahon
|
| Posted: 04/07/2002, 9:19 AM |
|
I'm new to web development and CodeCharge. It looks like CodeCharge prefers
to use ODBC to get to most databases other than MySql. Is there a way to
access Interbase 6, using PHP, and not using the ODBC? IB will be on a
Linux server so will not have ODBC.
--
Don Gollahon
(dlgllhn@theinter.com)
|
|
|
 |
Val Raemaekers
|
| Posted: 04/07/2002, 9:47 AM |
|
Don,
It doesn't matter if Interbase is on Linux or not, th odbc driver is
installed on the windows computer you run codecharge on. When you deploy
your php program to your linux box, it will use a direct connection to IB,
whilst you develop on windows, codecharge uses odbc to connect to it ....
"Don Gollahon" <dlgllhn@theinter.com> wrote in message
news:a8prit$cnn$1@news.codecharge.com...
> I'm new to web development and CodeCharge. It looks like CodeCharge
prefers
> to use ODBC to get to most databases other than MySql. Is there a way to
> access Interbase 6, using PHP, and not using the ODBC? IB will be on a
> Linux server so will not have ODBC.
>
>
> --
>
> Don Gollahon
> (dlgllhn@theinter.com)
>
>
|
|
|
|
Don Gollahon
|
| Posted: 04/07/2002, 11:26 AM |
|
I can't seem to get things to connect, locally or from my web page. The
ODBC connection works when I open it using Borland's database explorer.
CodeCharge set up the fields, etc, but the web page returns:
Fatal error: Call to undefined function: odbc_pconnect() in
/home/sites/site26/web/TestWeb/db_odbc.inc on line 35
"Val Raemaekers" <val@valtronics.co.za> wrote in message
news:a8pt6a$fsg$1@news.codecharge.com...
> Don,
>
> It doesn't matter if Interbase is on Linux or not, th odbc driver is
> installed on the windows computer you run codecharge on. When you deploy
> your php program to your linux box, it will use a direct connection to IB,
> whilst you develop on windows, codecharge uses odbc to connect to it ....
> "Don Gollahon" <dlgllhn@theinter.com> wrote in message
>news:a8prit$cnn$1@news.codecharge.com...
> > I'm new to web development and CodeCharge. It looks like CodeCharge
> prefers
> > to use ODBC to get to most databases other than MySql. Is there a way
to
> > access Interbase 6, using PHP, and not using the ODBC? IB will be on a
> > Linux server so will not have ODBC.
> >
> >
> > --
> >
> > Don Gollahon
> > (dlgllhn@theinter.com)
> >
> >
>
>
|
|
|
|
Don Gollahon
|
| Posted: 04/07/2002, 11:59 AM |
|
Also, what is the database type in the server section supposed to be for
Interbase? ODBC?
"Val Raemaekers" <val@valtronics.co.za> wrote in message
news:a8pt6a$fsg$1@news.codecharge.com...
> Don,
>
> It doesn't matter if Interbase is on Linux or not, th odbc driver is
> installed on the windows computer you run codecharge on. When you deploy
> your php program to your linux box, it will use a direct connection to IB,
> whilst you develop on windows, codecharge uses odbc to connect to it ....
> "Don Gollahon" <dlgllhn@theinter.com> wrote in message
>news:a8prit$cnn$1@news.codecharge.com...
> > I'm new to web development and CodeCharge. It looks like CodeCharge
> prefers
> > to use ODBC to get to most databases other than MySql. Is there a way
to
> > access Interbase 6, using PHP, and not using the ODBC? IB will be on a
> > Linux server so will not have ODBC.
> >
> >
> > --
> >
> > Don Gollahon
> > (dlgllhn@theinter.com)
> >
> >
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 04/08/2002, 2:00 AM |
|
Let's say Interbase is not supported by "Database Type" listbox in
Site/Props/Database,
this can be simply worked around by going to Modules/Common event ,
obtaining
generated code, and replacing include("./db_odbc.inc"); line with
include("./db_pgsql.inc");
So, it's a matter if there is InterBase support in PHPLIB rather than in CC,
since the latter
uses db independent functions. Although I don't know if there is any good
php lib
"driver" for Interbase, I used to come accross ones in internet.
--
Alex
CodeCharge Developer
"Don Gollahon" <dlgllhn@theinter.com> wrote in message
news:a8q4u9$ujv$1@news.codecharge.com...
> Also, what is the database type in the server section supposed to be for
> Interbase? ODBC?
>
> "Val Raemaekers" <val@valtronics.co.za> wrote in message
>news:a8pt6a$fsg$1@news.codecharge.com...
> > Don,
> >
> > It doesn't matter if Interbase is on Linux or not, th odbc driver is
> > installed on the windows computer you run codecharge on. When you deploy
> > your php program to your linux box, it will use a direct connection to
IB,
> > whilst you develop on windows, codecharge uses odbc to connect to it
.....
> > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> >news:a8prit$cnn$1@news.codecharge.com...
> > > I'm new to web development and CodeCharge. It looks like CodeCharge
> > prefers
> > > to use ODBC to get to most databases other than MySql. Is there a way
> to
> > > access Interbase 6, using PHP, and not using the ODBC? IB will be on
a
> > > Linux server so will not have ODBC.
> > >
> > >
> > > --
> > >
> > > Don Gollahon
> > > (dlgllhn@theinter.com)
> > >
> > >
> >
> >
>
>
|
|
|
|
Don Gollahon
|
| Posted: 04/08/2002, 3:30 PM |
|
InterBase was added to PHP in version 4. I just downloaded the most recent
(v 4.1.2) but still can't get the web pages to work with the data on my
local Apache (1.3) with Windows XP Home edition.
See:
http://www.phpbuilder.com/columns/glodt20020212.php3
and
http://www.php.net/
I'm had to use the CGI install method for PHP because I couldn't get the
ISAPI dll method to work.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a8rm7r$s49$2@news.codecharge.com...
> Let's say Interbase is not supported by "Database Type" listbox in
> Site/Props/Database,
> this can be simply worked around by going to Modules/Common event ,
> obtaining
> generated code, and replacing include("./db_odbc.inc"); line with
> include("./db_pgsql.inc");
> So, it's a matter if there is InterBase support in PHPLIB rather than in
CC,
> since the latter
> uses db independent functions. Although I don't know if there is any good
> php lib
> "driver" for Interbase, I used to come accross ones in internet.
>
> --
> Alex
> CodeCharge Developer
>
>
> "Don Gollahon" <dlgllhn@theinter.com> wrote in message
>news:a8q4u9$ujv$1@news.codecharge.com...
> > Also, what is the database type in the server section supposed to be for
> > Interbase? ODBC?
> >
> > "Val Raemaekers" <val@valtronics.co.za> wrote in message
> >news:a8pt6a$fsg$1@news.codecharge.com...
> > > Don,
> > >
> > > It doesn't matter if Interbase is on Linux or not, th odbc driver is
> > > installed on the windows computer you run codecharge on. When you
deploy
> > > your php program to your linux box, it will use a direct connection to
> IB,
> > > whilst you develop on windows, codecharge uses odbc to connect to it
> ....
> > > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> > >news:a8prit$cnn$1@news.codecharge.com...
> > > > I'm new to web development and CodeCharge. It looks like CodeCharge
> > > prefers
> > > > to use ODBC to get to most databases other than MySql. Is there a
way
> > to
> > > > access Interbase 6, using PHP, and not using the ODBC? IB will be
on
> a
> > > > Linux server so will not have ODBC.
> > > >
> > > >
> > > > --
> > > >
> > > > Don Gollahon
> > > > (dlgllhn@theinter.com)
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 04/09/2002, 1:37 AM |
|
Did you get phplib file with a definition of db_sql class for InterBase ?
Do you mean it didn't work at php (built-in IB functions) level or phplib
level ?
--
Alex
CodeCharge Developer
"Don Gollahon" <dlgllhn@theinter.com> wrote in message
news:a8t5m8$2nb$1@news.codecharge.com...
> InterBase was added to PHP in version 4. I just downloaded the most
recent
> (v 4.1.2) but still can't get the web pages to work with the data on my
> local Apache (1.3) with Windows XP Home edition.
>
> See:
>
> http://www.phpbuilder.com/columns/glodt20020212.php3
>
> and
>
> http://www.php.net/
>
> I'm had to use the CGI install method for PHP because I couldn't get the
> ISAPI dll method to work.
>
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:a8rm7r$s49$2@news.codecharge.com...
> > Let's say Interbase is not supported by "Database Type" listbox in
> > Site/Props/Database,
> > this can be simply worked around by going to Modules/Common event ,
> > obtaining
> > generated code, and replacing include("./db_odbc.inc"); line with
> > include("./db_pgsql.inc");
> > So, it's a matter if there is InterBase support in PHPLIB rather than in
> CC,
> > since the latter
> > uses db independent functions. Although I don't know if there is any
good
> > php lib
> > "driver" for Interbase, I used to come accross ones in internet.
> >
> > --
> > Alex
> > CodeCharge Developer
> >
> >
> > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> >news:a8q4u9$ujv$1@news.codecharge.com...
> > > Also, what is the database type in the server section supposed to be
for
> > > Interbase? ODBC?
> > >
> > > "Val Raemaekers" <val@valtronics.co.za> wrote in message
> > >news:a8pt6a$fsg$1@news.codecharge.com...
> > > > Don,
> > > >
> > > > It doesn't matter if Interbase is on Linux or not, th odbc driver is
> > > > installed on the windows computer you run codecharge on. When you
> deploy
> > > > your php program to your linux box, it will use a direct connection
to
> > IB,
> > > > whilst you develop on windows, codecharge uses odbc to connect to it
> > ....
> > > > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> > > >news:a8prit$cnn$1@news.codecharge.com...
> > > > > I'm new to web development and CodeCharge. It looks like
CodeCharge
> > > > prefers
> > > > > to use ODBC to get to most databases other than MySql. Is there a
> way
> > > to
> > > > > access Interbase 6, using PHP, and not using the ODBC? IB will be
> on
> > a
> > > > > Linux server so will not have ODBC.
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Don Gollahon
> > > > > (dlgllhn@theinter.com)
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Don Gollahon
|
| Posted: 04/09/2002, 10:11 PM |
|
There is a PDF document that lists the function definitions for InterBase.
I am new to PHP and have never used it before.
As I browsed PHP's directories I found an ibase.php with the definitions.
It was in the php\pear\DB directory. I'll experiment with it.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a8u97j$69r$2@news.codecharge.com...
> Did you get phplib file with a definition of db_sql class for InterBase ?
> Do you mean it didn't work at php (built-in IB functions) level or phplib
> level ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Don Gollahon" <dlgllhn@theinter.com> wrote in message
>news:a8t5m8$2nb$1@news.codecharge.com...
> > InterBase was added to PHP in version 4. I just downloaded the most
> recent
> > (v 4.1.2) but still can't get the web pages to work with the data on my
> > local Apache (1.3) with Windows XP Home edition.
> >
> > See:
> >
> > http://www.phpbuilder.com/columns/glodt20020212.php3
> >
> > and
> >
> > http://www.php.net/
> >
> > I'm had to use the CGI install method for PHP because I couldn't get the
> > ISAPI dll method to work.
> >
> >
> > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> >news:a8rm7r$s49$2@news.codecharge.com...
> > > Let's say Interbase is not supported by "Database Type" listbox in
> > > Site/Props/Database,
> > > this can be simply worked around by going to Modules/Common event ,
> > > obtaining
> > > generated code, and replacing include("./db_odbc.inc"); line with
> > > include("./db_pgsql.inc");
> > > So, it's a matter if there is InterBase support in PHPLIB rather than
in
> > CC,
> > > since the latter
> > > uses db independent functions. Although I don't know if there is any
> good
> > > php lib
> > > "driver" for Interbase, I used to come accross ones in internet.
> > >
> > > --
> > > Alex
> > > CodeCharge Developer
> > >
> > >
> > > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> > >news:a8q4u9$ujv$1@news.codecharge.com...
> > > > Also, what is the database type in the server section supposed to be
> for
> > > > Interbase? ODBC?
> > > >
> > > > "Val Raemaekers" <val@valtronics.co.za> wrote in message
> > > >news:a8pt6a$fsg$1@news.codecharge.com...
> > > > > Don,
> > > > >
> > > > > It doesn't matter if Interbase is on Linux or not, th odbc driver
is
> > > > > installed on the windows computer you run codecharge on. When you
> > deploy
> > > > > your php program to your linux box, it will use a direct
connection
> to
> > > IB,
> > > > > whilst you develop on windows, codecharge uses odbc to connect to
it
> > > ....
> > > > > "Don Gollahon" <dlgllhn@theinter.com> wrote in message
> > > > >news:a8prit$cnn$1@news.codecharge.com...
> > > > > > I'm new to web development and CodeCharge. It looks like
> CodeCharge
> > > > > prefers
> > > > > > to use ODBC to get to most databases other than MySql. Is there
a
> > way
> > > > to
> > > > > > access Interbase 6, using PHP, and not using the ODBC? IB will
be
> > on
> > > a
> > > > > > Linux server so will not have ODBC.
> > > > > >
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Don Gollahon
> > > > > > (dlgllhn@theinter.com)
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
