Re: [PHP] 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: [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



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



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>




--
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