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
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
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
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
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
Actually who the heck has put SELinux in my machine ?
anyone knows (is this a part of fedora ?)
/g
---
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
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
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
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
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]
; 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,
>
>
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
- 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
iginal Message - From: "Negin Nickparsa"
> To: "georg"
> Cc: "David OBrien" ; "PHP General" <
> php-general@lists.php.net>
> Sent: Saturday, May 18, 2013 7:56 PM
>
> Subject: Re: [PHP] ODBC
>
>
> do you have
the ODBC would be in the distribution 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, georg wrote:
Hi,
Id
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
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
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
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
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
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,
>
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
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
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
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
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
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
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
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
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
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
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
Jeremy Schreckhise wrote:
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 Sy
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
> 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_
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
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
[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
[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
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
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.
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
[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
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
[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
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
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
[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
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
[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
***
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'
[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
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
[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()?
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
>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
How does it fail?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server
-Original Message-
From: David Busby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 4:29 PM
To: php-gener
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
Brian,
This returns -1 for most drivers in a Select, but should return
appropriate info in an Update, Alter, Insert, etc.
If you need the feature when returning rows of data, you may simply
create a loop and increment a counter variable as you iterate over the
result se5t.
Best regards,
Andrew
Fernando,
check http://www.php.net/odbc
>From Windows you can just create a System DSN and then use it in an
odbc_connect() function.
>From some *nix flavor, you will need to build PHP --with-iodbc as per the
howto at www.iodbc.org, and then install OpenLink's Multi-Tier ODBC driver
with the ser
Paul,
Use a System DSN.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Paul Roberts [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November
"Jaxon" <[EMAIL PROTECTED]> wrote:
> Has anyone seen an ODBC version of PHPMyAdmin, or something similar; I
want
> to use it with more than just MySQL (e.g. Postgres and SQLServer)
Not ODBC, but phpMyAdmin has a PostgreSQL cousin, phpPgAdmin. You used to
be able to find it at www.greatbridge.org
t: RE: [PHP] ODBC for UniVerse Database
So I'm _not_ the only one still running UV :-)))
Do you have the UV PDF's handy? There's a section on setting up the ODBC.
If you don't have it, I'll mail you a copy.
UV's ODBC works reasonably well, except that it takes
So I'm _not_ the only one still running UV :-)))
Do you have the UV PDF's handy? There's a section on setting up the ODBC.
If you don't have it, I'll mail you a copy.
UV's ODBC works reasonably well, except that it takes a seat every time you
instantiate a connect. Perhaps a better way of goin
> > > Sent: Wednesday, July 11, 2001 10:39 AM
> > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > Subject: RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
> > >
> > >
> > > odbc_fetch_into gives me an array but it doesn't give the
Data Integration Technology Providers
>
> > -Original Message-
> > From: Bob Horton [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 11, 2001 10:39 AM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: [PHP] ODBC Function equivalent to MySql_Fe
Data Integration Technology Providers
> -Original Message-
> From: Bob Horton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 10:39 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
>
>
> odbc_
odbc_fetch_into gives me an array but it doesn't give the column names.
While many might consider that a small point I find that it helps
substantially in making my code self documenting.
$row[2] is much less readable than $row[Name]
> -Original Message-
> Bob,
>
> Why doesn't odbc_fetch
Bob,
Why doesn't odbc_fetch_into give you what you want?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Bob Horton [mailto:[EMAIL PROTECT
Andy,
What information are you trying to get? If "nr" and "name" are fields that
you want values for, then odbc_fetch_row() or odbc_fetch_into() should work
fine. If you are looking for column information, check out odbc_field_name()
and odbc_field_num()
http://www.php.net/manual/en/ref.odbc.php
: Thursday, March 22, 2001 5:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] ODBC & Oracle
There is a timeout, that should halt a script if it runs too long. If you
can, check
php.ini
set max_execution_time to something greater than 30 seconds, see if that
helps.
""Brooks, Ken"
There is a timeout, that should halt a script if it runs too long. If you
can, check
php.ini
set max_execution_time to something greater than 30 seconds, see if that
helps.
""Brooks, Ken"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I thought maybe the php
grab more than 6000 records from a database.
right?
thanks,
ken
-Original Message-
From: Brooks, Ken [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 4:21 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] ODBC & Oracle
I thought maybe the php script was running to fast for the
I thought maybe the php script was running to fast for the network
connection.
So i put in a sleep(1)
It still only ran for about the same amount of time (less records pulled of
course).
Could it be losing the connection instead because of lack of activity?
Would a persistent connection make any
Nevermind.
I got smart and used CREATE TABLE with a *really* long creation_definition
specifying all fields.
Works a millions times better/faster.
-Original Message-
From: Brooks, Ken [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 12:28 PM
To: Brooks, Ken; [EMAIL PROTECTED]
there is an article on devshed.com thats details this
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
77 matches
Mail list logo
