Sybase ODBC - PHP - ODBC - Sybase-Database

Author

PHP - ODBC - Sybase-Database

Jens Reinartz

2005-04-15, 7:23 am

Hello,

we want to connect to an Microsoft SBS 2003 with the
"Adaptive Server Anywhere 8.0" installed. This database
belongs to a third party software, so we are not firm in the
database system.

Our webserver should host pages for comfortable queries. The
Apache software and the php module are installed and
functional. The whole server bases on the Suse distribution.

This large problems exist:
- What drivers must be installed?
- How must the odbc environment be configured
- it is not clear, how a connection to the sybase server
must be programmed in php

Does an howto or guide exist for our program?

Thanks
Jens

Millard F. Brown III

2005-04-15, 8:23 pm

Hi,

Let's start with the easy stuff - are you able to set up an
ODBC data source that connects to your database? You can
test this right from the ODBC configuration dialog with the
"Test Connection" button.

Regards,
Millard[TeamSybase]

> Hello,
>
> we want to connect to an Microsoft SBS 2003 with the
> "Adaptive Server Anywhere 8.0" installed. This database
> belongs to a third party software, so we are not firm in
> the database system.
>
> Our webserver should host pages for comfortable queries.
> The apache software and the php module are installed and
> functional. The whole server bases on the Suse
> distribution.
>
> This large problems exist:
> - What drivers must be installed?
> - How must the odbc environment be configured
> - it is not clear, how a connection to the sybase server
> must be programmed in php
>
> Does an howto or guide exist for our program?
>
> Thanks
> Jens

Jens Reinartz

2005-04-18, 3:23 am

Hello,

> Let's start with the easy stuff - are you able to set up
> an ODBC data source that connects to your database? You
> can test this right from the ODBC configuration dialog
> with the "Test Connection" button.

thank you for response.

Well, until now, there is nothing installed beside the
apache server and php.

Pressing any button could be a problem, the server has no
gui (only shell).

I have no idea, where to start.

Is it possible to set up a ODBC connection with this data?

database name: ts (not sure)
IP of server: 192.168.0.12
Servername: hsab_sbs2003 (is this important?)
Serverport:2639
Filename: e:\windvsw1\HS_Data\
AB\ts.ab
Username: [known]
Password:[known]

There is a module for php called unixODBC. I bet, that can
be used for data access.

Best regards
Jens Reinartz

Millard F. Brown III

2005-04-19, 8:23 pm

Hello, Jens,

I'm not terribly familiar with connecting from Unix, but you'll probably need to
install a ASA client on the Unix box. The windows implementation of ODBC for ASA
is two-tier and I would guess that the Unix implementation is the same.

Regards,
Millard[TeamSybase]

On 18 Apr 2005 00:30:24 -0700,
in sybase.public.connectivity.odbc
<Jens Reinartz> wrote:
>Hello,
>
>
>thank you for response.
>
>Well, until now, there is nothing installed beside the
>apache server and php.
>
>Pressing any button could be a problem, the server has no
>gui (only shell).
>
>I have no idea, where to start.
>
>Is it possible to set up a ODBC connection with this data?
>
>database name: ts (not sure)
>IP of server: 192.168.0.12
>Servername: hsab_sbs2003 (is this important?)
>Serverport:2639
>Filename: e:\windvsw1\HS_Data\
AB\ts.ab
>Username: [known]
>Password:[known]
>
>There is a module for php called unixODBC. I bet, that can
>be used for data access.
>
>Best regards
>Jens Reinartz

Regards,
Millard[TeamSybase]

Sponsored Links