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
/feedback/details/417926/truncate-partition-of-partitioned-table
2013/5/19 georg georg.chamb...@telia.com
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
-
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
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
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
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
On Dec 15, 2009, at 9:50 AM, Richard Quadling wrote:
2009/12/15 Philip Thompson philthath...@gmail.com:
On Dec 14, 2009, at 8:47 PM, James McLean wrote:
On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson
philthath...@gmail.com wrote:
My head hurts from hitting it on my desk all day, so I
On Tue, Dec 15, 2009 at 10:13 AM, Philip Thompson philthath...@gmail.com
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
On Dec 16, 2009, at 9:22 AM, Andrew Ballard wrote:
On Tue, Dec 15, 2009 at 10:13 AM, Philip Thompson philthath...@gmail.com
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
On Dec 14, 2009, at 8:47 PM, James McLean wrote:
On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson
philthath...@gmail.com 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
2009/12/15 Philip Thompson philthath...@gmail.com:
On Dec 14, 2009, at 8:47 PM, James McLean wrote:
On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson
philthath...@gmail.com 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
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 =
On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson
philthath...@gmail.com 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
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,
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
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
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
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
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
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
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:
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,
with a 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
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
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.
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
[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);
$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 object (I
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
[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
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
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 $dsnbr.odbc_error().:
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
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,
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
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]
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
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
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
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
[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
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
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
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
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
Is there ODBC for PHP4 for LINUX to connect MS-SQL?
p.s. other than openlink software
rgds
./pl
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
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
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
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
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
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
[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:
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
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
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
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.
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
-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 ideas
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?
?php
$db =
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
i just newbie how to use odbc in php i have ready craete odbc in window
like this
odbc name= data
user = tes
password=
i want read some data in password.db and put ini un the screen
strukture database password.db like this
password
name
level
allos some exsample to use to get in
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:
1 - 100 of 159 matches
Mail list logo