Re: [PHP] ODBC

could you su to the user apache runs as (possibly specifying the shell to
use) and navigate to the directory?

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table


2013/5/19 georg <[email protected]>

> Hi Serge,
> compliled some more info
>
> Apache error log as:
> ---
> [Tue May 14 17:45:11 2013] [error] [client 127.0.0.1] PHP Warning:
> odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib
> '/lib/libmimodbc.so' : file not found, SQL state 01000 in SQLConnect in
> /var/www/html/my2.php on line 19, referer: http://127.0.0.1/
> ----
> File that is deemed missing:
> ---
> [root@this ge]# ls -alF /lib/libmimodbc.so
> lrwxrwxrwx. 1 root root 39 Apr 29 22:21 /lib/libmimodbc.so ->
> /opt/MimerSQL-10.0.6J/lib/**libmimodbc.so*
>
> --- and since this seem to be a link rather than the file (for some
> reason, think I actually moved lib there....---
>
> [root@this ge]# ls -alF /opt
> total 12
> drwxr-xr-x. 3 root root 4096 Apr 29 22:20 ./
> dr-xr-xr-x. 18 root root 4096 May 16 19:15 ../
> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 MimerSQL-10.0.6J/
> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/
> total 40
> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 ./
> drwxr-xr-x. 3 root root 4096 Apr 29 22:20 ../
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 bin/
> drwxr-xr-x. 8 root root 4096 Apr 29 22:20 DbVisualizer/
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 doc/
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 examples/
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 include/
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 lib/
> drwxr-xr-x. 5 root root 4096 Dec 21 2011 man/
> drwxr-xr-x. 2 root root 4096 Apr 29 22:21 misc/
> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/lib
> total 12516
> drwxr-xr-x. 2 root root 4096 Dec 21 2011 ./
> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 ../
> -rwxr-xr-x. 1 root root 515740 Dec 20 2011 compat.a*
> -rwxr-xr-x. 1 root root 1051162 Dec 20 2011 libmimcomm.so*
> -rwxr-xr-x. 1 root root 1346488 Dec 20 2011 libmimdbi.so*
> -rwxr-xr-x. 1 root root 5397415 Dec 20 2011 libmimdbs.so*
> -rwxr-xr-x. 1 root root 1922776 Dec 20 2011 libmimer.so*
> -rwxr-xr-x. 1 root root 6416 Dec 20 2011 libmimerS.so*
> -r-xr-xr-x. 1 root root 1693640 Dec 20 2011 libmimodbc.so*
> -rwxr-xr-x. 1 root root 507386 Dec 20 2011 libqsqlmimer.so*
> -rwxr-xr-x. 1 root root 136312 Dec 20 2011 mimjdbc3.jar*
> -rwxr-xr-x. 1 root root 1252 Dec 20 2011 mimsqlxa.o*
> -rwxr-xr-x. 1 root root 212423 Dec 20 2011 psmdebug.jar*
> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/lib/**libmimodbc.so
> -r-xr-xr-x. 1 root root 1693640 Dec 20 2011 /opt/MimerSQL-10.0.6J/lib/**
> libmimodbc.so*
> [root@this ge]#
>
> ---- so that seem to be in place ?? --
>
> Tnx
> Georg
>
>
> ----- Original Message ----- From: Serge Fonville
>
> To: georg
> Cc: Negin Nickparsa ; PHP Mailinglist
> Sent: Sunday, May 19, 2013 12:45 PM
>
> Subject: Re: [PHP] ODBC
>
>
>
> Hi,
>
> I'm not really clear on what you have and haven't done, but did you check
> permissions?
>
>
> HTH
>
>
>
> Kind regards/met vriendelijke groet,
>
>
> Serge Fonville
>
>
> http://www.sergefonville.nl
>
> Convince Microsoft!
> They need to add TRUNCATE PARTITION in SQL Server
> https://connect.microsoft.com/**SQLServer/feedback/details/**
> 417926/truncate-partition-of-**partitioned-table<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table>
>
>
>
> 2013/5/19 georg <[email protected]>
>
> Hi Negin, tnx for advice,
>
> now however I have successfully downloaded and installed ODBC and
> the things needed to connect PHP-ODBC (yum on the same actually)
>
> however, the llinked library file that the odbcinit.ini file points to in
> order to
> link the libmimodbc.so library is not found, though the file is obviously
> at that location
>
> (apache error_log contains a complaint file not found )
>
> so Im still not through completely
>
> /g
> ----- Original Message ----- From: "Negin Nickparsa" <[email protected]>
> To: "georg" <[email protected]>
> Cc: "David OBrien" <[email protected]>; "PHP General" <
> [email protected]>
> Sent: Saturday, May 18, 2013 7:56 PM
>
> Subject: Re: [PHP] ODBC
>
>
>
> do you have the driver in linux?
> https://www.microsoft.com/en-**us/download/details.aspx?id=**28160<https://www.microsoft.com/en-us/download/details.aspx?id=28160>
>
>
>
> On Tue, May 7, 2013 at 11:46 AM, georg <[email protected]> wrote:
>
>
> but isnt there some yum command that will fix things for me (download if
> necessary, but I actually think
> the ODBC would be in the distribution of fedora ?)
>
> br georg
>
> ----- Original Message ----- From: "David OBrien" <[email protected]>
> To: "georg" <[email protected]>
> Cc: "PHP General" <[email protected]>
> Sent: Monday, May 06, 2013 11:06 PM
> Subject: Re: [PHP] ODBC
>
>
>
> On Mon, May 6, 2013 at 3:32 PM, georg <[email protected]> wrote:
>
>
> Hi,
>
>
> Id like to get ODBC connection to SQL from PHP going. Ive done that on
> XP,
> but now Im switching
> to Linux (Fedora).
>
> My impression in that the connecting part is per the DB designers
> responsibility. Im using Mimer-SQL,
> but cant find any information on how to set up ODBC for that. Any advice
> welcome.
>
> BR georg
>
>
>
>
> http://developer.mimer.com/****howto/howto_57.htm<http://developer.mimer.com/**howto/howto_57.htm>
> <http://**developer.mimer.com/howto/**howto_57.htm<http://developer.mimer.com/howto/howto_57.htm>
> >
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>