Re: [PHP] ODBC

2013-05-19 Thread georg
t;georg" ; "PHP Mailinglist" Sent: Sunday, May 19, 2013 5:25 PM Subject: Re: [PHP] ODBC better would be to allow apache acces to the module i.e. http://www.webhostingtalk.com/showthread.php?t=711418 Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
Again to the list 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 F

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
better would be to allow apache acces to the module i.e. http://www.webhostingtalk.com/showthread.php?t=711418 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/SQLS

Re: [PHP] ODBC

2013-05-19 Thread Ashley Sheridan
On Sun, 2013-05-19 at 17:06 +0200, georg wrote: > Actually who the heck has put SELinux in my machine ? > > anyone knows (is this a part of fedora ?) > > /g SELinux is part of Fedora install. You can disable it (not recommended) or just follow one of the options it gives you depending on what

Re: [PHP] ODBC

2013-05-19 Thread Larry Martell
On Sun, May 19, 2013 at 9:06 AM, georg wrote: > Actually who the heck has put SELinux in my machine ? > > anyone knows (is this a part of fedora ?) Never used Fedora, but it's part of Red Hat and Centos, so would guess it's also part of fedora. You can disable SELinux with this: echo 0 > /selinu

Re: [PHP] ODBC

2013-05-19 Thread georg
Actually who the heck has put SELinux in my machine ? anyone knows (is this a part of fedora ?) /g

Re: [PHP] ODBC

2013-05-19 Thread georg
--- From: Serge Fonville To: georg ; PHP Mailinglist Sent: Sunday, May 19, 2013 2:35 PM Subject: Re: [PHP] ODBC Hmm, I just noticed GMAIL no longer replies to all, so here is all my correspondence that wasn't sent to the list. Kind regards/met vriendelijke groet, S

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
bin/httpd -k start >>> >>> apache 1384 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start >>> >>> apache 1385 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start >>> >>> root 1387 0.0 0.0 4760 788 pts/0 S+ 10:51 0:00 grep --color=au &g

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
rocess come into the system access wise ?) >>> >>> tnx >>> georg >>> >>> - Original Message - From: "georg" >>> To: "Serge Fonville" >>> Cc: >>> Sent: Sunday, May 19, 2013 1:29 PM >&g

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
how does Apache process come into the system access wise ?) >> >> tnx >> georg >> >> - Original Message - From: "georg" >> To: "Serge Fonville" >> Cc: >> Sent: Sunday, May 19, 2013 1:29 PM >> >> Subject

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
m: "georg" > To: "Serge Fonville" > Cc: > Sent: Sunday, May 19, 2013 1:29 PM > > Subject: Re: [PHP] ODBC > > > Hi Serge, >> compliled some more info >> >> Apache error log as: >> --- >> [Tue May 14 17:45:11 2013] [error]

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
; 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, > >

Re: [PHP] ODBC

2013-05-19 Thread georg
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" To: "Serge Fonville" Cc: Sent: Sunday, May 19, 2013 1:29 PM Sub

Re: [PHP] ODBC

2013-05-19 Thread 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 gr

Re: [PHP] ODBC

2013-05-19 Thread Serge Fonville
/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2013/5/19 georg > 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 l

Re: [PHP] ODBC

2013-05-19 Thread georg
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

Re: [PHP] ODBC

2013-05-18 Thread Negin Nickparsa
bution of fedora ?) > > br georg > > - Original Message - From: "David OBrien" > To: "georg" > Cc: "PHP General" > Sent: Monday, May 06, 2013 11:06 PM > Subject: Re: [PHP] ODBC > > > > On Mon, May 6, 2013 at 3:32 PM, geor

Re: [PHP] ODBC

2013-05-07 Thread georg
May 06, 2013 11:06 PM Subject: Re: [PHP] ODBC On Mon, May 6, 2013 at 3:32 PM, georg 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

Re: [PHP] ODBC

2013-05-06 Thread David OBrien
On Mon, May 6, 2013 at 3:32 PM, georg 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

[PHP] ODBC

2013-05-06 Thread georg
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

[PHP] ODBC obscuring the SQL result ?

2013-03-14 Thread georg
Hi (again), Im doing a $res = odbc_prepare... with a select statement and $succ = odbc_execute($res) im missing how to get the return information on whether I got any hit or not in the table now !! the REF MAN is clearly sloppy; in writing moment i see that $succ is a boolea

Re: [PHP] PHP + ODBC

2009-12-16 Thread Philip Thompson
On Dec 16, 2009, at 9:22 AM, Andrew Ballard wrote: > On Tue, Dec 15, 2009 at 10:13 AM, Philip Thompson > wrote: >> On Dec 14, 2009, at 8:47 PM, James McLean wrote: >>> Why not just use the built in MySQL libraries or PDO? >> >> Oh, that would be "my" preference. However, the database that I >> r

Re: [PHP] PHP + ODBC

2009-12-16 Thread Andrew Ballard
On Tue, Dec 15, 2009 at 10:13 AM, Philip Thompson wrote: > On Dec 14, 2009, at 8:47 PM, James McLean wrote: >> Why not just use the built in MySQL libraries or PDO? > > Oh, that would be "my" preference. However, the database that I > really need to connect to is an MSSQL one and the allowed conne

Re: [PHP] PHP + ODBC

2009-12-16 Thread Philip Thompson
On Dec 15, 2009, at 9:50 AM, Richard Quadling wrote: > 2009/12/15 Philip Thompson : >> On Dec 14, 2009, at 8:47 PM, James McLean wrote: >> >>> On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson >>> wrote: My head hurts from hitting it on my desk all day, so I thought I'd turn to a fres

Re: [PHP] PHP + ODBC

2009-12-15 Thread Richard Quadling
2009/12/15 Philip Thompson : > On Dec 14, 2009, at 8:47 PM, James McLean wrote: > >> On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson >> wrote: >>> My head hurts from hitting it on my desk all day, so I thought I'd turn to >>> a fresher set of eyes. The issue I'm having is getting PHP to connect

Re: [PHP] PHP + ODBC

2009-12-15 Thread Philip Thompson
On Dec 14, 2009, at 8:47 PM, James McLean wrote: > On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson > wrote: >> My head hurts from hitting it on my desk all day, so I thought I'd turn to a >> fresher set of eyes. The issue I'm having is getting PHP to connect ODBC. I >> can get it to work usin

Re: [PHP] PHP + ODBC

2009-12-14 Thread James McLean
On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson wrote: > My head hurts from hitting it on my desk all day, so I thought I'd turn to a > fresher set of eyes. The issue I'm having is getting PHP to connect ODBC. I > can get it to work using isql from the command line. Can you verify my > settin

[PHP] PHP + ODBC

2009-12-14 Thread Philip Thompson
Hello all. My head hurts from hitting it on my desk all day, so I thought I'd turn to a fresher set of eyes. The issue I'm having is getting PHP to connect ODBC. I can get it to work using isql from the command line. Can you verify my settings: /etc/odbc.ini: [MySQL] Description = MySQ

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Thodoris
On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: If you need abstraction, check this out: http://us.php.net/pdo Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vi

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 5:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > You can't upgrade PHP? > > Thank you, > Micah Gersten > onShore Networks > Internal Developer > http://www.onshore.com > > > > Dan Joseph wrote: > > On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> > wrot

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Micah Gersten
You can't upgrade PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dan Joseph wrote: > On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > > >> If you need abstraction, check this out: >> http://us.php.net/pdo >> >> Thank you, >

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > If you need abstraction, check this out: > http://us.php.net/pdo > > Thank you, > Micah Gersten > onShore Networks > Internal Developer > http://www.onshore.com > > -- > PHP General Mailing List (http://www.php.net/) > To

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Micah Gersten
If you need abstraction, check this out: http://us.php.net/pdo Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dan Joseph wrote: > On Thu, Sep 18, 2008 at 3:36 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > >> If you already have your results in an array, t

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 3:36 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > If you already have your results in an array, try using count($result); > That should count the number of results returned to your result array. > > Or you could try uncommenting the mssql extension in your php.ini file and

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Shirah
On 9/18/08, Dan Joseph <[EMAIL PROTECTED]> wrote: > Hi, > > Anyone else using the odbc_* functions to interact with MS SQL Server 2005? > > I'm having a problem getting odbc_num_rows() to return anything other than > -1 when querying a stored procedure. I can get it to work using Top in a > norma

[PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
Hi, Anyone else using the odbc_* functions to interact with MS SQL Server 2005? I'm having a problem getting odbc_num_rows() to return anything other than -1 when querying a stored procedure. I can get it to work using Top in a normal query (non-stored procedure). SELECT Top 100 * FROM Tabl

Re: [PHP] odbc msaccess php5 [Giving Up]

2008-07-06 Thread Peter Jackson
Peter Jackson wrote: well thats it Ive come to the conclusion that its a driver/lib issue. From what I can see mdbtools lib only reads and only does basic select. (eg Select * from table where col =thistext But not tex* % or date. Also looks like the project has died (think the last release w

Re: [PHP] odbc msaccess php5

2008-07-05 Thread Peter Jackson
Bastien Koert wrote: On Sat, Jul 5, 2008 at 11:04 AM, Bastien Koert <[EMAIL PROTECTED]> wrote: On Sat, Jul 5, 2008 at 6:51 AM, Peter Jackson <[EMAIL PROTECTED]> wrote: $conn=odbc_connect("Database","",""); works $a = "abcd"; (this value exists in db) $stat = "Select * FROM " . '"Table Nam

Re: [PHP] odbc msaccess php5

2008-07-05 Thread Bastien Koert
On Sat, Jul 5, 2008 at 11:04 AM, Bastien Koert <[EMAIL PROTECTED]> wrote: > > > On Sat, Jul 5, 2008 at 6:51 AM, Peter Jackson <[EMAIL PROTECTED]> > wrote: > >> Hi list, >> >> I am trying to get info out of a MS Access 2000 db. So far I have >> managed to do some of it but current part has me stu

Re: [PHP] odbc msaccess php5

2008-07-05 Thread Bastien Koert
On Sat, Jul 5, 2008 at 6:51 AM, Peter Jackson <[EMAIL PROTECTED]> wrote: > Hi list, > > I am trying to get info out of a MS Access 2000 db. So far I have managed > to do some of it but current part has me stumped. > > Set up > Machine 1 - Debian 4, Apache, PHP5 unixodbc, mdbtools > Machine 2 - W

[PHP] odbc msaccess php5

2008-07-05 Thread Peter Jackson
Hi list, I am trying to get info out of a MS Access 2000 db. So far I have managed to do some of it but current part has me stumped. Set up Machine 1 - Debian 4, Apache, PHP5 unixodbc, mdbtools Machine 2 - WindowsXP, MS-Access Database is in a windows share that is smfs mounted on the linux

Re: [PHP] ODBC and long text fields

2007-01-08 Thread Jochem Maas
Larry Garfield wrote: > On Sunday 07 January 2007 8:26 pm, Jochem Maas wrote: > ... >> >> with regard to wanting results returned in a 'named' fashion, does the new >> setup still not allow use of odbc_fetch_array() instead of >> odbc_fetch_row()? not that I see any logic in that solving the iss

Re: [PHP] ODBC and long text fields

2007-01-07 Thread Larry Garfield
On Sunday 07 January 2007 8:26 pm, Jochem Maas wrote: > > Now I'll be honest and say I don't quite follow what they're talking > > about. I do not claim to be an ODBC guru, but SQLGetData is a lower-level > > operation, SQL level or C level I don't know, but not something that > > happens in PHP c

Re: [PHP] ODBC and long text fields

2007-01-07 Thread Jochem Maas
no real answer, but ... Larry Garfield wrote: > Hi all. I've a question regarding PHP's ODBC support. > > Here's the situation: > > We've a PHP app that uses ODBC to talk to a MS SQL server. Its original home > was on a server that used the OpenLink ODBC driver, which was a POS, so we > bui

[PHP] ODBC and long text fields

2007-01-07 Thread Larry Garfield
Hi all. I've a question regarding PHP's ODBC support. Here's the situation: We've a PHP app that uses ODBC to talk to a MS SQL server. Its original home was on a server that used the OpenLink ODBC driver, which was a POS, so we build an abstraction wrapper around the subset of PHP's ODBC fun

[PHP] odbc remote

2006-06-07 Thread Benjamin Adams
how do I do a remote connection for odbc? Everything that I see is on the local machine. Can you do an odbc to a remote database? Benjamin Adams / Lord of the Root / Ambrosia Software, Inc. -- http:// www.AmbrosiaSW.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] ODBC question

2005-12-28 Thread Kristen G. Thorson
similar set up, but with windows installed on drive c: Thanks in advance, Jeremy Schreckhise I did a search on that error + OpenLink and came up with this: http://support.openlinksw.com/support/print_opie_article.vsp?OP_ID=299 I did this once a long time ago (PHP/ODBC/Progress), but I

[PHP] ODBC question

2005-12-28 Thread Jeremy Schreckhise
  I have an Openlink Single Tier Driver on an XP pro machine with windows installed on drive f: because I have a dual boot with Red Hat.  Database is Progress 8.3c on a SCO Unixware 7.1.4 Dell Server.  I can connect to all progress databases and pull data utilizing a System DSN via Openlink, how

Re: [PHP] ODBC and DB2 functions (PDO_ODBC)

2005-09-28 Thread Oscar Gosdinski
Check this article, it will help you using PDO and DB2: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505furlong/index.html However, you can access a DB2 server using the unified ODBC extension which actually i configured on a production enviroment. http://www-128.ibm.com/devel

[PHP] ODBC and DB2 functions (PDO_ODBC)

2005-09-28 Thread Dan McCullough
Anyone have any experience with DB2 over ODBC or JDBC from PHP on Linux? Looking for some idea of what I will need to be able to connect to a DB2 server on our network. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] ODBC Errors and Undefined functions

2005-03-21 Thread Philip Olson
> Oh and Jay... since no one else has found the answer it would be nice if > you could post your solution here when / if you find it. Accoding to the source, these two functions require something to exist: #ifdef PHP_ODBC_HAVE_FETCH_HASH PHP_FUNCTION(odbc_fetch_array); PHP_FUNCTION(odbc_fetch_

Re: [PHP] ODBC Errors and Undefined functions

2005-03-21 Thread Jason Barnett
Oh and Jay... since no one else has found the answer it would be nice if you could post your solution here when / if you find it. -- Teach a man to fish... NEW? | http://www.catb.org/~esr/faqs/smart-questions.html STFA | http://marc.theaimsgroup.com/?l=php-general&w=2 STFM | http://php.net/manual

Re: [PHP] ODBC Errors and Undefined functions

2005-03-21 Thread Jason Barnett
Jay Blanchard wrote: > [snip] > Okie dokie. I have an odbc data and I can use odbc_result_all() to > return data in an HTML table format. If I switch to odbc_fetch_array() > or odbc_fetch_object() I get a call to an undefined function even though > TFM says that these are available in 4.3.7 running

RE: [PHP] ODBC Errors and Undefined functions

2005-03-21 Thread Jay Blanchard
[snip] Okie dokie. I have an odbc data and I can use odbc_result_all() to return data in an HTML table format. If I switch to odbc_fetch_array() or odbc_fetch_object() I get a call to an undefined function even though TFM says that these are available in 4.3.7 running phpinfo() shows that ODBC is e

[PHP] ODBC Errors and Undefined functions

2005-03-21 Thread Jay Blanchard
Okie dokie. I have an odbc data and I can use odbc_result_all() to return data in an HTML table format. If I switch to odbc_fetch_array() or odbc_fetch_object() I get a call to an undefined function even though TFM says that these are available in 4.3.7 running phpinfo() shows that ODBC is enabled

RE: [PHP] odbc fetch array issues

2004-11-16 Thread Jay Blanchard
[snip] $sql = "SELECT * FROM users WHERE username='$username' AND password='$password'"; $result = odbc_exec($dbConnection, $sql); while ($rows = odbc_fetch_array($result)) { //This doesn't work with odbc_fetch_object either print $rows->COLUMNNAME; } [/snip] For odbc_fetch_array you wo

[PHP] odbc fetch array issues

2004-11-16 Thread Adil
Hey people, Anyone know much about odbc_fetch_array() or odbc_fetch_object() functions in php. My while loop keeps breaking while using this function. I'm trying to grab a row from the result returned by the database query and for testing purposes, just printing out each item in the row as follo

[PHP] odbc question

2004-11-16 Thread Adil
>$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'"; >$result = odbc_exec($dbConnection, $sql); > >while ($rows = odbc_fetch_array($result)) { > //This doesn't work with odbc_fetch_object either > print $rows->COLUMNNAME; >} It's returning an array, not an obj

[PHP] ODBC, PHP and Pervasive

2004-03-15 Thread William Nettmann
G'day! I am trying to access data in a Pervasive database which is of quite an old version, not sure which, but using the Pervasive Software ODBC-32 driver, version 2.04.02.10, which comes with the application I am trying to share data with, Pastel Partner 5. I am running PHP 4.3 on Windows 2000 P

[PHP] PHP, ODBC and Pervasive SQL

2004-03-10 Thread William Nettmann
I am trying to connect from PHP to Pervasive SQL using ODBC, and I am experiencing difficulty. My PHP looks like this: $dsn = "GruffTrading"; // Datasource $dsu = ""; // User $dsp = ""; // Password if(!$odbc = odbc_connect($dsn,$dsu,$dsp)) die("Unable to connect to Data Source $dsn".odbc_error().

[PHP] PHP ODBC and Pervasive.SQL

2004-02-26 Thread Pascal Schaedeli
Hi, I am executing a SELECT query from PHP (4.3.4) through ODBC on a Pervasive 2000SP4 (all on Windows). odbc_result_all, odbc_fetch_into, and all other php odbc function stop returning records before the end of the effective resultset. Here is what is happening : * In Pervasive: SELECT * FROM

Re: [PHP] ODBC with SQL Server

2004-02-16 Thread Juan Torres
Hi, Functions mssql_* and odbc_* don't allow write/read unicode fields. But ODBTP Extension allows it. The url is: http://odbtp.sourceforge.net/. Greetings, Juan Torres. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] ODBC with SQL Server

2004-02-15 Thread David Otton
On Fri, 13 Feb 2004 12:30:42 +0100, you wrote: >I have a connectoin ODBC with a SQL Server database. A table has a field of >type 'nvarchar'. This field contains japanese characters. >How can I read these japanese characteres? When I read (with: "select name >from data") only read '?' character.

[PHP] ODBC with SQL Server

2004-02-13 Thread Juan Torres
Hello, I have a connectoin ODBC with a SQL Server database. A table has a field of type 'nvarchar'. This field contains japanese characters. How can I read these japanese characteres? When I read (with: "select name from data") only read '?' character. Thaks very much. Juan Torres. -- PHP Gener

[PHP] ODBC connection..

2004-02-10 Thread Andrew Kwiczola
Heya, I was wondering if its possible to create a odbc connection with php, using a User DSN.. (not a system DSN)? Everytime I try to connect with this code.. $connect = odbc_connect("userdsnhere", "user", "password") or die(odbc_errormsg());; I get... [Microsoft][ODBC Driver Manager

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread memoimyself
Check out the message below, which a user added to the online version of the PHP manual. Could this have anything to do with your problem? ** FROM http://br2.php.net/manual/en/function.mysql-escape-string.php ** sp4m_only at hotmail dot com 02-Apr-2003 10:07 I found out another very curiou

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread John Nichel
[EMAIL PROTECTED] wrote: Hello CC, On 26 Jan 2004 at 12:47, C C wrote: Hi, I'm trying to insert binary data into a MS SQL Server database. Text files are added fine, but binary files with null bytes are not. The field I'm adding the binary data to is image type. I get an error about unclosed qu

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread memoimyself
Hello CC, On 26 Jan 2004 at 12:47, C C wrote: > Hi, > > I'm trying to insert binary data into a MS SQL Server database. Text > files are added fine, but binary files with null bytes are not. The > field I'm adding the binary data to is image type. I get an error about > unclosed quotation marks

[PHP] odbc functions - not binary safe?

2004-01-26 Thread C C
Hi, I'm trying to insert binary data into a MS SQL Server database. Text files are added fine, but binary files with null bytes are not. The field I'm adding the binary data to is image type. I get an error about unclosed quotation marks at the null byte, but I've replaced ' with ''. I tried esca

[PHP] ODBC in PHP4.3.4 crashes when used with Mysql 4

2004-01-14 Thread Nico Sabbi
Hi, I have Mysql-4.0-14, MyODBC 3.51.06 and unixODBC 2.2.0. They are working perfectly together (isql works correctly) but php-4.3.x always crashes when I try odbc_connect() on the same DSN I use with isql (env vars are correctly set). Is this a known bug? This is a bt of a simplified example th

RE: [PHP] ODBC for MS Access

2003-09-18 Thread Jay Blanchard
[snip] I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions: 1 What software/driver do I need in Linux box as well as in Windows box? Where to find such a software/driver? 2. Do I need compile PHP to be able to connec

[PHP] ODBC for MS Access

2003-09-18 Thread Muhammad Fikri
Dear All, I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions: 1 What software/driver do I need in Linux box as well as in Windows box? Where to find such a software/driver? 2. Do I need compile PHP to be able to co

[PHP] ODBC in PHP: setting SQL_ATTR_TRACE

2003-06-27 Thread Jeff Stewart
I've been reading about ways to help secure an application against database hacking, and I've read more than once now that it's wise to turn off tracing within the ODBC drivers when issuing sensitive commands, by setting SQL_ATTR_TRACE to SQL_ATTR_OFF. But I can't figure out how to do that with th

RE: [PHP] ODBC

2003-06-04 Thread Jay Blanchard
Have you RTFM at http://us3.php.net/manual/en/ref.odbc.php HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] ODBC

2003-06-04 Thread Tomá¹ Kubi¹
Hello, I need to connect from my Linux server to DSN (MS Access) on WindowsXP via ODBC. Would you helo me? Thanks Toma Kubis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] ODBC Problem

2003-03-13 Thread Kiswa
Hi. I have a problem, Been writing a site in php that uses ODBC systemlink to a Access DB The server is apache The problem is that the final server is win2000 IIS and the thing doesent work. It seems that the odbc connect doesent output any info. It works fine on apache cant figure out what the di

[PHP] PHP ODBC

2003-03-06 Thread Patrick LOK
Is there ODBC for PHP4 for LINUX to connect MS-SQL? p.s. other than openlink software rgds ./pl

[PHP] PHP ODBC Problem

2003-02-14 Thread Mike
Hi, I've installed PHP 4.3.0 on a Win2k (SP3) IIS 5 server, as we were moving the site to another server (old server was also win2k, php 4.3.0), and ODBC calls no longer function correctly when served from the webserver, however they work perfectly when called from the command line. So http://sit

[PHP] odbc..

2003-01-21 Thread Edward Peloke
Hello all, I know I can connect to another db through an odbc connection in php. Can I use php to create the connection initially? I will be uploading an access db from the users and then moving the data over into my mysql db. Since this will all be done automatically, I will need php to upload

[PHP] odbc

2002-12-19 Thread Edward Peloke
Ok, I am lost now, I am just trying to read the documentation on odbc...here is what I have so far. This seems to work...or at least not give any errors. How do I know get to the result set in the select statement to move this data somewhere else? I just want to get the entire result set so I can

Re: [PHP] ODBC connectivity

2002-10-29 Thread Jonathan Sharp
First test that you can connect to the db server outside of php through an odbc connection...then come back if that doesn't work. -js Bill Hudspeth wrote: > I have developed a PHP application that accesses a Microsoft Access database > through ODBC. The application works well using PHP version

[PHP] ODBC connectivity

2002-10-29 Thread Bill Hudspeth
I have developed a PHP application that accesses a Microsoft Access database through ODBC. The application works well using PHP version 4.1. I have recently installed the newest version of PHP (4.2.3) on another machine running NT4, and IIS 4. Again, I am using an ODBC connection, and have given th

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Jay Blanchard
[snip] $odbc = odbc_connect("cvalcoinput","","") OR die("There is an error connecting to the CSV file."); $result = odbc_tables($odbc); while(odbc_fetch_into($result, $fields)){ for ($i = 0; $i < sizeof($fields); $i++) { echo $fields[$i] . ""; } } Derives the following results: D:\INETPU

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Ethan Nelson
D]] Sent: Tuesday, September 10, 2002 12:29 PM To: Ethan Nelson; [EMAIL PROTECTED] Subject: RE: [PHP] ODBC text file connection problem [snip] // ODBC commands to explore connection: $result = odbc_tables($odbc); odbc_fetch_into($result,$row); print_r($row); [/snip] Have you tried a WHILE loo

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Jay Blanchard
[snip] // ODBC commands to explore connection: $result = odbc_tables($odbc); odbc_fetch_into($result,$row); print_r($row); [/snip] Have you tried a WHILE loop to print out each row? I am not sure of the exact syntax but something like; \n"); //at end of row } ?> Jay ***

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Ethan Nelson
in \ ***:\***\***\***\basecsv2.html on line 53 -Ethan -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 12:03 PM To: Ethan Nelson; [EMAIL PROTECTED] Subject: RE: [PHP] ODBC text file connection problem [snip] As you can see, If I'

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Jay Blanchard
[snip] As you can see, If I'm going to preserve the double quotes in the third column, I would have to come up with a script that would deal with escaped characters. I was hoping that I could just establish an ODBC connection to the text file, which it appears that I can, and then select stuff fr

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Ethan Nelson
Tuesday, September 10, 2002 11:48 AM To: Ethan Nelson; [EMAIL PROTECTED] Subject: RE: [PHP] ODBC text file connection problem [snip] I've got one for ya. I've been trying to conenct to a csv text file = (comma delimited, \r\n row separators, and " text qualifiers) using the = od

RE: [PHP] ODBC text file connection problem

2002-09-10 Thread Jay Blanchard
[snip] I've got one for ya. I've been trying to conenct to a csv text file = (comma delimited, \r\n row separators, and " text qualifiers) using the = odbc_connect command and then run simple select statements through it. = It doesn't work and I'm at a loss for why. [/snip] Why not use fopen()?

[PHP] ODBC text file connect problem

2002-09-10 Thread Ethan Nelson
Good morning... I've got one for ya. I've been trying to conenct to a csv text file (comma delimited, \r\n row separators, and " text qualifiers) using the odbc_connect command and then run simple select statements through it. It doesn't work and I'm at a loss for why. Here's the meat (I re

[PHP] ODBC text file connection problem

2002-09-10 Thread Ethan Nelson
Good morning... I've got one for ya. I've been trying to conenct to a csv text file = (comma delimited, \r\n row separators, and " text qualifiers) using the = odbc_connect command and then run simple select statements through it. = It doesn't work and I'm at a loss for why. Here's the meat (I

[PHP] odbc sql php

2002-08-16 Thread Saci
This question is more on odbc sql than on php, since I'm sure everthing is working on php side I have a php form who fills on ODBC database ( Visual Foxpro) , everthing is working except with one detail, I have a text area field on my form and when the user fill this area with to many characters

Re: [PHP] ODBC

2002-08-03 Thread John Lim
Have a look at http://php.weblogs.com/adodb_csv "Bob Lockie" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > >Can PHP be used on an Apache server (linux) to connect to a (remote) MS > >Access server (NT) through ODBC? > > Yes. > > > > If so, does anyone

Re: [PHP] ODBC

2002-08-02 Thread Bob Lockie
>Can PHP be used on an Apache server (linux) to connect to a (remote) MS >Access server (NT) through ODBC? Yes. > If so, does anyone have examples of how this >is done? Nope, never done it. It'll use the same PHP database commands probably. Read www.php.net -- PHP General Mailing Lis

[PHP] ODBC

2002-08-02 Thread Ashley M. Kirchner
Can PHP be used on an Apache server (linux) to connect to a (remote) MS Access server (NT) through ODBC? If so, does anyone have examples of how this is done? And if not, what other choices do I have? -- W | I haven't lost my mind; it's backed up on tape somewhere. +-

[PHP] ODBC under linux + PHP + Apache problem.

2002-08-02 Thread Jose Morales
I write a few days ago to the list with a problem trying to find my ODBC DSN under linux debian. Well, i solve the problem, now i can find my dsn from PHP code, but its seems like it crash when i do a odbc_connect(...) I know that unixodbc works becouse i test it with isql. I have no warnings

RE: [PHP] ODBC Failures

2002-07-25 Thread Andrew Hill
php-general Subject: [PHP] ODBC Failures List, My ODBC connection is failing it seems...I can run this code just fine...odbc_connect and odbc_pconnect seem to work...the odbc_prepare even works just fine...but as soon as I execute (with odbc_execute, odbc_exec, or odbc_do it fails...any i

[PHP] ODBC Failures

2002-07-01 Thread David Busby
List, My ODBC connection is failing it seems...I can run this code just fine...odbc_connect and odbc_pconnect seem to work...the odbc_prepare even works just fine...but as soon as I execute (with odbc_execute, odbc_exec, or odbc_do it fails...any ideas? "; $sql = odbc_prepare($db, "exe

[PHP] ODBC driver 4 MS access

2002-06-26 Thread Renaldo De Silva
does anyone know of any ODBC driver for access that allows me to use odbc_num_rows. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] odbc

2002-06-25 Thread Analysis & Solutions
On Tue, Jun 25, 2002 at 04:05:10PM +0700, sonjaya wrote: > i just newbie how to use odbc in php i have ready craete odbc in window > like this Step 1: http://www.php.net/manual/en/function.odbc-connect.php Step 2: http://www.php.net/manual/en/function.odbc-exec.php Step 3: http://www.php.net/m

  1   2   >