Also, is PHP installed as a module or otherwise? 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 Serge Fonville <serge.fonville@xxxxxxxxx> > x on directories is required to navigate to a directory. > r is needed to read the file > > 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> > >> 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<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<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> >>> <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 >>> >>> >> >
