-general@lists.php.net
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 georg.chamb...@telia.com wrote:
but isnt there some yum command
...@gmail.com
To: georg georg.chamb...@telia.com
Cc: David OBrien dgobr...@gmail.com; PHP General
php-general@lists.php.net
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=**28160https
-
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
@lists.php.net
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] [client 127.0.0.1] PHP Warning:
odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib
'/lib/libmimodbc.so' : file
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
georg.chamb...@telia.com
To: Serge Fonville serge.fonvi...@gmail.com
Cc: php-general@lists.php.net
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] [client 127.0.0.1] PHP Warning
access wise ?)
tnx
georg
- Original Message - From: georg georg.chamb...@telia.com
To: Serge Fonville serge.fonvi...@gmail.com
Cc: php-general@lists.php.net
Sent: Sunday, May 19, 2013 1:29 PM
Subject: Re: [PHP] ODBC
Hi Serge,
compliled some more info
Apache error log
Cc: php-general@lists.php.net
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] [client 127.0.0.1] PHP Warning:
odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib
: 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
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,
Serge Fonville
http://www.sergefonville.nl
Convince
Actually who the heck has put SELinux in my machine ?
anyone knows (is this a part of fedora ?)
/g
On Sun, May 19, 2013 at 9:06 AM, georg georg.chamb...@telia.com 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
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 you
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
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
To: la...@software-horizons.com
Cc: georg georg.chamb...@telia.com; PHP Mailinglist
php-general@lists.php.net
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
be in the distribution of fedora ?)
br georg
- Original Message - From: David OBrien dgobr...@gmail.com
To: georg georg.chamb...@telia.com
Cc: PHP General php-general@lists.php.net
Sent: Monday, May 06, 2013 11:06 PM
Subject: Re: [PHP] ODBC
On Mon, May 6, 2013 at 3:32 PM, georg
-general@lists.php.net
Sent: Monday, May 06, 2013 11:06 PM
Subject: Re: [PHP] ODBC
On Mon, May 6, 2013 at 3:32 PM, georg georg.chamb...@telia.com 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
On Mon, May 6, 2013 at 3:32 PM, georg georg.chamb...@telia.com 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
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,
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
normal query
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
then
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, try
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,
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,
Micah
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]
wrote:
If you
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
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 - WindowsXP,
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 stumped.
Set up
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 Name';
$qry =
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 issue, again
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
build an
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 code as
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
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.
[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
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
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-generalw=2
STFM |
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);
[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
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.
I've
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 at
[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
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
[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
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
[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()?
support create/drop table, insert, or
update commands (obviously), but it doesn't mention SELECT as being off limits...
-Ethan
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 11:48 AM
To: Ethan Nelson; [EMAIL PROTECTED]
Subject: RE: [PHP] ODBC
[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
-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'm going to preserve the double quotes in the third column, I
would have
[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;
?php
while(odbc_fetch_into($result, $fields)){
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 loop to print out each row? I am not sure of the exact syntax
but something like
[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] . br;
}
}
Derives the following results:
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 have examples
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 List
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:
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:
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
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 20,
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, but
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
: [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 a seat every time you
instantiate
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
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
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_fetch_into gives me an array
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_fetch_into gives me an array
: RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
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
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
, 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"" [EMAIL PROTECTED] wro
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
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 network
connection
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
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]
75 matches
Mail list logo