SQL Anywhere database

Author

ASA 5.5

Jann

2005-08-24, 7:23 am

Hi

I have ASA 5.5 in windows server
now I want connect to SQL thru php using adaptive sql anywhere_php_module,

from other windows server,
if I enable extension=php_sybase
_ct.dll in PHP.ini apache hangs in start
I understand that important also SQLpp.exe but where I must put it

I copied dblib7.dll and dblib6.dll to windows\system32 folder but no
helping

what libraries I must copy where to get apache work with
<?
$conn = sqlanywhere_connect(
"uid=dba;pwd=sql" );

any suggestion
jann

Randy Jheeta

2005-08-24, 1:23 pm

Have you looked at the following whitepaper?
http://www.ianywhere.com/whitepapers/apache_php.html

"Jann" <jann@zzz.ee> wrote in message news:430c63b0@forums
-1-dub...
> Hi
>
> I have ASA 5.5 in windows server
> now I want connect to SQL thru php using adaptive sql anywhere_php_module,

> from other windows server,
> if I enable extension=php_sybase
_ct.dll in PHP.ini apache hangs in start
> I understand that important also SQLpp.exe but where I must put it
>
> I copied dblib7.dll and dblib6.dll to windows\system32 folder but no
> helping
>
> what libraries I must copy where to get apache work with
> <?
> $conn = sqlanywhere_connect(
"uid=dba;pwd=sql" );
>
>
> any suggestion
> jann
>
>

Jann

2005-08-25, 3:31 am

Yes put there is only instruction for unix
and no word about php.ini

jann

"Randy Jheeta" <rjheeta@sybase.com> wrote in message
news:430ca90c$1@foru
ms-1-dub...
> Have you looked at the following whitepaper?
> http://www.ianywhere.com/whitepapers/apache_php.html
>
>
>
> "Jann" <jann@zzz.ee> wrote in message news:430c63b0@forums
-1-dub...
>
>

Greg Fenton

2005-08-26, 3:23 am

Jann wrote:
> Hi
>
> I have ASA 5.5 in windows server
> now I want connect to SQL thru php using adaptive sql anywhere_php_module,

> from other windows server,
> if I enable extension=php_sybase
_ct.dll in PHP.ini apache hangs in start
> I understand that important also SQLpp.exe but where I must put it
>
> I copied dblib7.dll and dblib6.dll to windows\system32 folder but no
> helping
>

The communication mechanism and protocol changed drastically between
v5.5 and 6.0. There is no way to have a 6.x or higher client/server
communicate with a 5.5 or earlier client/server (though you can mount a
5.5 and earlier database file on a 6.x or higher server to communicate
with newer clients).

I cannot say for 100% certainty, but I do not believe there is a way to
have PHP communicate with a v5.5 server. If there are, I'd be leary of
using it in a production environment.

You *might* be able to get some type of TDS/OpenClient communications to
SA 5.5, but I've never tried it myself.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

greg.fenton_NOSPAM_@ianywhere.com

2005-08-26, 11:23 am

Here is a pretty good overview of communication with SA 5.5 using TDS
(though the author incorrectly states that ASA was "transitioning" to
OpenClient...rather ASA was "adding" OpenClient support).

http://lists.ibiblio.org/pipermail/...5q2/018501.html

This email might give you some insight.

Hope it helps,
greg.fenton

Sponsored Links