Staring at it myself; should there be xr in the last position of the access
definitions ?
(how does Apache process come into the system access wise ?)
tnx
georg
----- Original Message -----
From: "georg" <georg.chambert@xxxxxxxxx>
To: "Serge Fonville" <serge.fonville@xxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Sunday, May 19, 2013 1:29 PM
Subject: Re: ODBC
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: 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
2013/5/19 georg <georg.chambert@xxxxxxxxx>
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" <nickparsa@xxxxxxxxx>
To: "georg" <georg.chambert@xxxxxxxxx>
Cc: "David OBrien" <dgobrien@xxxxxxxxx>; "PHP General"
<php-general@xxxxxxxxxxxxx>
Sent: Saturday, May 18, 2013 7:56 PM
Subject: Re: ODBC
do you have the driver in linux?
https://www.microsoft.com/en-us/download/details.aspx?id=28160
On Tue, May 7, 2013 at 11:46 AM, georg <georg.chambert@xxxxxxxxx> 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" <dgobrien@xxxxxxxxx>
To: "georg" <georg.chambert@xxxxxxxxx>
Cc: "PHP General" <php-general@xxxxxxxxxxxxx>
Sent: Monday, May 06, 2013 11:06 PM
Subject: Re: ODBC
On Mon, May 6, 2013 at 3:32 PM, georg <georg.chambert@xxxxxxxxx> 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>
--
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
--
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
