?php
$txt.=h1TEST CONNECT/h1;
// to have this working:
// 1- u have first to creat ur access database using MS
// Access (i asume u know how to do this). My database
// that i used in my example is called Questionaire.mdb.
// the table in it is called Results
//
// 2- then u have to
I am accessing a Microsoft Access 2000 database using the Unified ODBC
functions. My problem is that some SQL field types are not recognised and
cause the database driver to a (generic) syntax error. For instance
odbc_exec($odbc,'CREATE TABLE FormData (formid LONG,dataphp LONG VARCHAR)');
Subj: Connect Oracle 10g using ODBC on Linux platform
I found message when I connect to ORACLE through my Explorer. Here:
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source
name not found,
and no default driver specified, SQL state IM002 in SQLConnect in
Hi all,
I have an elusive problem with PHP and ODBC.
I want to use ODBC to contact a MSSQL server on an NT box, from a linux
machine.
FreeTDS driver, no problem
unixODBC, no problem
I can contact the correct database on the NT box through isql and tsql, no
problem
I can make a command-line
Julien Bonastre a écrit :
and relation to Ronald Rivest??
As in the Ronald Rivest, Leonard Adleman, Adi Shamir? RSA Encryption
Rivest?
Just curious :-)
No! :)
--
Alain -- http://www.vivahate.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Christopher Jones a écrit :
Alain Rivest wrote:
Hi, which one is the fastest: odbc or oci8?
I use PHP 5 with IIS on Windows Server 2003 with Oracle 8 and 9 on
several Alpha Servers with OpenVMS. Which one should I choose, odbc
or oci8? Does oci8 works with Oracle 9i?
For now I wrote my
Hi, which one is the fastest: odbc or oci8?
I use PHP 5 with IIS on Windows Server 2003 with Oracle 8 and 9 on
several Alpha Servers with OpenVMS. Which one should I choose, odbc or
oci8? Does oci8 works with Oracle 9i?
For now I wrote my web applications with odbc support because the other
-
From: Rodrigo Haces [mailto:[EMAIL PROTECTED]
Sent: 10 October 2005 23:13
To: php-db@lists.php.net
Subject: [PHP-DB] ODBC Problem
Hi all:
Im currently using php to connect to a database in another server, this is
a
intersystems cache database.
if i do a query to my database and the result has
,
Matthias
-Original Message-
From: Rodrigo Haces [mailto:[EMAIL PROTECTED]
Sent: 10 October 2005 23:13
To: php-db@lists.php.net
Subject: [PHP-DB] ODBC Problem
Hi all:
Im currently using php to connect to a database in another server, this
is a
intersystems cache database
Hi all:
Im currently using php to connect to a database in another server, this is a
intersystems cache database.
if i do a query to my database and the result has special spanish characters
like ´ (á,é,í,ó,ú) it returns me another character, this one changes from
time to time, i just tried to
Hi all,
I have an application that needs to connect to an ODBC datasource which
requires additional parameters to allow the connection.
In VB the connection string takes the following form:
DSN=DATASOURCE;GR_UID=USERNAME;GR_PWD=PASSWORD
I can see no way to pass the GR_UID and GR_PWD parameters.
Hey people,
Again, thanks to anyone whose answered my questions, its helping out a great
deal.
I figured out the sessions issues thanks to some of the replies I received
but if its not one thing its the other it seems.
Anyone know much about odbc_fetch_array() or odbc_fetch_object() functions
$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
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9, the
column names are being truncated to 31 characters. --
?php
$DBN = 'thedbn';
$UID = 'theuid';
$PWD = 'thepws';
$CONN = odbc_connect( $DBN, $UID, $PWD ) or die( Cannot connect to
$DBN.); $sql = select * from crap; $result =
The reason is because the buffer used by the odbc extension to store field
names is only 32 bytes. You can try using the sybase or odbtp extension.
Otherwise, you will have to submit it as a bug, so that it will be fixed.
-- bob
On Thu, 9 Sep 2004, Anthony Robins wrote:
When retrieving ODBC
You will have much better results if you use the odbtp extension instead
of the odbc extenstion, especially on Linux. The odbtp_field_type()
function will give you the correct type name.
Also, you could use the mssql extension. However, mssql_field_type()
returns type names that are not exact.
Hi
Thanks for your answer but :
What is odbtp extension I don't find it on www.php.net ???
I use ADOdb to database abstraction and I can't change all the ADOdb code.
Do you know why the function odbc_field_type don't give me the good result
?
Is is a PHP error, an unixODBC error or a
The latest version of ADODb supports odbtp. You can get it at
http://odbtp.sourceforge.net. There are 2 versions of the ADODb driver:
odbtp and odbtp_unicode. The problem you are having is caused by the
inability of the ODBC driver to provide what the desired information. The
FreeTDS ODBC driver
Hi Mark
An alternative solution for connecting to MS Access is odbtp. Details are
available at http://odbtp.sourceforge.net. It provides better support for
ODBC, especially in regards to MS Access. Take a look at the
storedqry.php example at http://odbtp.sourceforge.net/examples.html. It
This looks really great, Bob...thx!
Mark
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 10:19 AM
To: Galbreath, Mark A
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] ODBC support
Hi Mark
An alternative solution for connecting to MS Access
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm
psyched.
My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x
but I can't figure out how to use it. I would like to access the M$ Access
JET engine directly from a PHP page. Any clues?
tia,
Mark
--
Galbreath, Mark A wrote:
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm
psyched.
My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x
but I can't figure out how to use it. I would like to access the M$ Access
JET engine directly from a PHP page.
: Thursday, March 11, 2004 2:04 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] ODBC support
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm
psyched.
My problem is, the PHP docs and API mention that ODBC is built into PHP
4.x
but I can't figure out how to use it. I would like
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
You cannot use the odbc mssql extensions to read nvarchar ntext
fields. You will have to use the odbtp extension located at
http://odbtp.sourceforge.net. It provides support for UNICODE data.
-- bob
On Fri, 13 Feb 2004, Juan Torres wrote:
Hello,
I have a connectoin ODBC with a SQL Server
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
Hello Ricardo,
I have see an litle class on phpclasses.org that open dbase files. Now on your
main problem to connect foxpro data base with php via ODBC you must be made
the next step:
1) Check if your Foxpro data base have ODBC drivers installed
2) Made the ODBC connex to create the DSN
Hi,
The only stuff i have found about foxpro and PHP is this:
hertz:~# apt-cache search foxpro
libphp-adodb - The 'adodb' database abstraction layer for php
or do you mean something else?
thanks for the help.
On Wed, 2003-10-15 at 08:20, Luis M Morales C wrote:
Hello Ricardo,
I have see
instead.
-Original Message-
From: Ricardo C. Fernandez de C. [mailto:[EMAIL PROTECTED]
Sent: 14 October 2003 16:22
To: php-db
Subject: RE: [PHP-DB] ODBC
Ok, it worked on the local machine if i do
odbc_connect(telefonia,,)
But, if i'm on the remote machine, i have
Hi all,
I have been trying to connect to a windows ODBC controller with PHP, and
after reading some of the documentation, I can't make the connection
This is the Code I'm using:
?
$conn=odbc_connect(Driver={Microsoft Fox Pro Driver};Server=
127.0.0.1;Database=telefonia,,);
if(!$conn) { echo Not
={Microsoft Fox Pro Driver};Server=
127.0.0.1;Database=telefonia,,);
-Original Message-
From: Ricardo C. Fernandez de C. [mailto:[EMAIL PROTECTED]
Sent: 14 October 2003 15:16
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC
Hi all,
I have been trying to connect to a windows ODBC controller with PHP
What do I need and where can I get it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You should use the mssql extension for this purpose. Another alternative
is odbtp.
-- bob
On Thu, 9 Oct 2003, rick rice wrote:
What do I need and where can I get it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database
I solved my problem (here). IBM came out with new drivers and they sovled
the problem.
THanks
-Original Message-
From: Simpson, Doug
Sent: Monday, September 29, 2003 11:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] odbc
I am trying to connect to an AS/400 from a Linux box running RH9
I am trying to connect to an AS/400 from a Linux box running RH9.
I have installed unixODBC and the iSeries drivers.
I can run cwbping that tell me that I am connecting to the AS400.
I have made a scipt the following script -
HTML
HEADTITLEODBC Data Source/TITLE/HEAD
BODY
?php
//odbc_query.php
Robert Twitty wrote:
Unless I am mistaken, but isn't there an ODBC driver available for MySQL
called MyODBC?
-- bob
I haven't a clue. Ill look, maybe it will help me create drivers for my
DB layer, as I already know MySQL.
Last night I successfully connected to IBM's DB2, but I didnt get far
Larry E.Ullman wrote:
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is easy to
understand/get into from a novice point of view, that installs on
windows 2k,
and is free?
MySQL is kind of free, installs on W2K and is
i have read an article on IBM's developerWorks website.
its title should be Leverage your Microsoft SQL Server 2000 Skills to Learn
DB2 UDB Version 8
that should help you.
Gerard Samuel [EMAIL PROTECTED] ??:[EMAIL PROTECTED]
Robert Twitty wrote:
Unless I am mistaken, but isn't there an
], [EMAIL PROTECTED], Robert
08/11/2003 10:37 Twitty [EMAIL PROTECTED]
AM Subject: Re: [PHP-DB] ODBC Database
Unless I am mistaken, but isn't there an ODBC driver available for MySQL
called MyODBC?
-- bob
On Sun, 10 Aug 2003, Gerard Samuel wrote:
Larry E.Ullman wrote:
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is
[EMAIL PROTECTED] wrote:
whoops, meant to include
thishttp://www.mysql.com/downloads/api-myodbc-3.51.html
Unless I am mistaken, but isn't there an ODBC driver available for MySQL
called MyODBC?
-- bob
I haven't a clue. Ill look, maybe it will help me create drivers for my
DB
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is easy to
understand/get into from a novice point of view, that installs on
windows 2k,
and is free?
Thanks for your suggestions.
--
PHP Database Mailing List
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is easy to
understand/get into from a novice point of view, that installs on
windows 2k,
and is free?
MySQL is kind of free, installs on W2K and is easy to use but it
Hi all,
Just finishing off a site using odbc and Access and it's thrown up a problem
that wasn't there yesterday.
I have a simple login with a username and password. If either are blank, the
user gets bumped to the login page. otherwise the user table is searched for
the username and password.
Hi, I need to do a ODBC conexión with DB2 over AS400 for a php aplication, my
aplication is in a web server wiht linux red hat 7.0, I´ve
already downloaded the unixODBC driver and the iSeriesODBC from IBM page, but when I
run the installation
command: rpm -ivh iSeriesODBC-5.1.0-0.xx..rpm.
Hi,
I am connecting to MySQL (4.1) using ODBC (I have my reasons) and am looking
for an equivalent to the mysql_insert_id() function so that I can get the ID
of the record just created.
Cheers
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
I am connecting to MySQL (4.1) using ODBC (I have my reasons) and am
looking
for an equivalent to the mysql_insert_id() function so that I can get the
ID
of the record just created.
You could always just issue a SELECT LAST_INSERT_ID() query and get the
resulting number that way.
---John
Hi,
reading both the documentation and the MARC I found two serious
misbehaviours:
1) it seems that it's impossible to tell a query that is correct but has no
records
from a query which is syntactically wrong (and consequently has no records);
or at least it seems to be impossibile to
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC and error management
Hi,
reading both the documentation and the MARC I found two serious
misbehaviours:
1) it seems that it's impossible to tell a query that is correct
but has no
records
from a query which is syntactically wrong
Hi,
Is there any free ODBC Driver for ORACLE 9i to use with PHP, APACHE, LINUX ?
Regards
Alain
Does anyone know how to join cursors after having successfull query ie:
I have multiple queries that get data from different sources and now I need
to join the results, how can I achieve this in PHP (Do I need to write into
a temporary table and then requery? is that the only way? I am using
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
I'm trying to extract one record that has largest sequence ID number for an
employee, so I've tried below but doesn't work. Help.
$mQuery = EmployeeID = '$user';
$mCur = odbc_exec( $mCnx, select ID=max(ID),Date,TimeIn,TimeOut,StationIP
from Clocks where $mQuery );
Hi.
Is their anyway to connect to a Access Db using only the filesystem like
$connect = odbc_connect(\Db\Webdb.mdb, nobody, nobody);
thus pointing directly to the file not using drivers???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
result);
--
Beverly Steiner
[EMAIL PROTECTED]
-Original Message-
From: Kiswa [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC
Hi.
Is their anyway to connect to a Access Db using only the filesystem like
Hi,
I am trying access DB Paradox via php/odbc.
Only get in W98/PWS or WME/PWS. And without success in Linux/php/odbc and
Windows 2K/php/odbc.
In W2K's Case, it appears following message:
Warning: SQL error: [Microsoft][ODBC DRIVER for Paradox] The table
external is not in the waited format.,
Does anyone know a reliable way to set an ODBC connection to timeout after a very
short time? I've tried set_time_limit but when the query is running PHP does not drop
out, I've also tried odbc_setoption on the connection before executing. Basically, I
want it to just fail quicker if it is
, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC Timout for MS SQL Driver
Does anyone know a reliable way to set an ODBC connection to timeout after a very
short time? I've tried set_time_limit but when the query is running PHP does not drop
out, I've also tried odbc_setoption
Hi all,
I have a system PHP4+LINUX+DB2. I'm using stored procedure on IBM DB2 7.1,
and in PHP(4.23) I can execute the procedure but I can't get the return
values. Does anyone know why? Below is my source code.
Thank you,
Renato Preti
The 1st one didn't work, but the 2nd one did work. Fantastic! Thanks alot,
you saved me from frustrations.
Quoting John W. Holmes [EMAIL PROTECTED]:
I'm having problem querying a table with a field value containing an
appostropy, please help. Using ODBC to connect MSAcess database.
I'm having problem querying a table with a field value containing an
appostropy, please help. Using ODBC to connect MSAcess database.
$mQuery = CustomerID='$mCust';
$mCur2 = odbc_do( $mCnx, select Login from Emails where $mQuery );
When it hits O'Donald, James, I get error in
I'm having problem querying a table with a field value containing an
appostropy, please help. Using ODBC to connect MSAcess database.
$mQuery = CustomerID='$mCust';
$mCur2 = odbc_do( $mCnx, select Login from Emails where $mQuery
);
When it hits O'Donald, James, I get error in
Does anybody know, what does it mean:
SQL error: [Microsoft][ODBC Visual FoxPro Driver]File 'datum_format.prg' does not
exist., SQL state S0002 in SQLExecDirect
I'm using DATUM_FORMAT function in SQL command and this error is shown.
Thank you, Radim
Hi all,
I have an apache server with PHP 4.2.3 on it that works perfectly.
How can i install the odbc drivers ?
Thanks,
Hacook
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi i need advice
I want to run my PHP script on Linux, but i want to use FoxPro database
(.dbf) through ODBC.
I didn't find such ODBC driver for Linux and i don't know how to connect
with the script to the some machine with Windows system,where the data are
stored and where ODBC is working.
Can
Hi there everyone,
I have always used MySQL with PHP without any problems using the standard MySQL
connection functionality. Is it possible to connect to a MySQL DB via ODBC? If so,
what would the PHP Connection string be? I am curious as my email server allows you
to use external
Hello,
I'm having trouble connecting via ODBC using the Microsoft text driver on a win2k box.
I read the KB article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178717 and it seems to
suggest that I should be able to select data from a text source. Here is what I have
so
hey guys !
I´m trying to use a if syntax to compare data and preselect radiobuttons.
I tried it like that:
if ($checked == Patch)
$checked6 = bla;
With numbers it works great but with char my $checked6 variable is empty !
I know php is case sensitive and I´m sure that problem is not the case
resource *odbc_primarykeys* ( resource connection_id, string qualifier,
string owner, string table)
resource *odbc_foreignkeys* ( resource connection_id, string
pk_qualifier, string pk_owner, string pk_table, string fk_qualifier,
string fk_owner, string fk_table)
int *odbc_tables* ( resource
Hi Chip,
Looks okay at first brush - I suspect your odbc.ini DSN config.
Have you been able to test your DSN outside the PHP environment? e.g
with the odbctest app that comes with iODBC?
Can you post your odbc.ini / DSN info?
Warning: SQL error: [iODBC][Driver Manager]Specified driver could
I am attempting for the first time, to connect from freebsd/mysql/php box
to a NT box running MAS200. I am able
to connect from another NT workstation with Access and download data, so I
am trying from FreeBSD now.
When I run the code below I get error:
Fatal error: Call to undefined function:
It looks like you didn't build php with odbc support.
Try putting in a call to
phpinfo ();
and see if it says that odbc support is compiled in.
(Another) Chip
On Fri, 9 Aug 2002 [EMAIL PROTECTED] wrote:
I am attempting for the first time, to connect from freebsd/mysql/php box
to a NT box
Yeah, you're right, I see I need to add --with-iodbc. Now another question
- when I recompile to add
this support, do I have to add all the other options that I originally had
listed? Or can I add just this one
and everything else will be left the same? What about php.ini? Will it be
changed?
--
Chip,
You are going to have to rebuild the dso with the options you specified
before - try cutting and pasting the configure that shows up in your
phpinfo() to make it easier.
Also, you can get the necessary iODBC header files at www.iodbc.org, as
well as find a HOWTO there for compiling
Chip,
I wonder if you set the ODBCINI environment variable with the putenv()?
If you could show the code in your odbctest.php file that would be
helpful.
Actually, I'll be traveling to Linuxworld on Monday - anyone wants to
chat about ODBC who will be there feel free to drop me an email.
Jaz,
http://www.php.net/manual/en/function.odbc-primarykeys.php
Best regards,
Andrew Hill
On Wednesday, July 17, 2002, at 08:16 AM, j.a.z. wrote:
How can i get the information if a field on a database (in my case
Access2000) is primary key via a php-odbc-function?
or does i have to use sql
How can i get the information if a field on a database (in my case
Access2000) is primary key via a php-odbc-function?
or does i have to use sql for that?
thanx j.a.z.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi all!
Is it possible to fetch the odbc results into an associative array?
Regards,
Gabor
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
How can i get the information if a field on a database (in my case
Access2000) is primary key via a php-odbc-function?
or does i have to use sql for that?
thanx j.a.z.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I have an app developed with PHP+Apache+MySQL on a NT Server, but I have
data in a MSAccess file on a another LAN server (with NT) that I want to
display.
The response is always the same:
Warning: SQL error: [Microsoft][Controlador ODBC Microsoft Access 97] The
Microsoft Jet database
: [PHP-DB] ODBC Remote
Hi,
I have an app developed with PHP+Apache+MySQL on a NT Server, but I have
data in a MSAccess file on a another LAN server (with NT) that I want to
display.
The response is always the same:
Warning: SQL error: [Microsoft][Controlador ODBC Microsoft Access 97
willing and able to step back if a problem like this occurs. This
is, however, just an opinion.
-Original Message-
From: Ryan Jameson (USA)
Sent: Monday, April 29, 2002 8:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ODBC problem in 4.2.0
I'd recommend finding a hosting service th
om: Ryan Jameson (USA)
Sent: Monday, April 29, 2002 8:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ODBC problem in 4.2.0
I'd recommend finding a hosting service that would be more careful about
making upgrades. There seems to be some problems with ODBC in 4.2 and I have
yet to hear o
: [PHP-DB] ODBC problem in 4.2.0
Hi Ryan,
It's not true that this can happen to any product. PHP is a fantastic
language, but
there are well-known ways to manage QA. All it needs is to include ODBC
in the standard php regression test suite (and run the suite regularly!)
Regards, John
Ryan Jameson
Tuesday, April 30, 2002 2:50 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC problem in 4.2.0
Hi Ryan,
It's not true that this can happen to any product. PHP is a fantastic
language, but
there are well-known ways to manage QA. All it needs is to include ODBC
in the standard php regression te
i work on a website that runs on php with MSSQL through ODBC.
until 4.2.0 everything was ok. but my hosting provider just upgraded to 4.2.0
the error message i get is :
SQL error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt, SQL state S1000 in
for me I can just stay at 4.1.1 until there's a
release that works.
Ryan
-Original Message-
From: Mihai Tache [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 7:11 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC problem in 4.2.0
i work on a website that runs on php with MSSQL
this occurs. This is, however, just an opinion.
-Original Message-
From: Ryan Jameson (USA)
Sent: Monday, April 29, 2002 8:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ODBC problem in 4.2.0
I'd recommend finding a hosting service that would be more careful about making
upgrades
If this is easy for anyone could someone verify that:
odbc_fetch_row($rs,0);
...does not reset the result set in version 4.2? From what I can tell it doesn't work
at all. I want to be certain that we cannot upgrade to 4.2. If someone has another way
to reset an ODBC result set I'd love to
Hi. I'm looking at compiling one of the odbc function sets into php on
my Mac OSX machine (I eventually want to be able to talk to MAS90 on a
Windows machine -- if that's feasible). I'm finding the ODBC situation a
bit confusing though. Should I use iodbc or unixodbc? Any suggestions?
And
When connecting to database (Sybase) through ODBC it takes some time to
establish odbc connection with:
$cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw);
And only after that I am able to access data through SQL Selects
The problem is that every time the script is finished this connection
Hi,
I'm working with PHP and ODBC to get images stored in a database (Blob fields). But I
experiment little problems to display these pics. Has anyone any information about
PHP/ODBC/images ?
Thanks,
Bilbo
-Original Message-
From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID
Sure, I'm simply trying to have PHP pass an ApplicationID to the
ODBC server.
When
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC -- Setting ApplicationID
I am trying to set the ApplicationID, when connecting to an ODBC
datasource. I have tried:
odbc_setoption ($conn, 1, 1053, PHPAPP);
And get a:
SQL error: [iODBC][Driver Manager]Option type out of range, SQL state
S1092
11:02 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC -- Setting ApplicationID
I am trying to set the ApplicationID, when connecting to an ODBC
datasource. I have tried:
odbc_setoption ($conn, 1, 1053, PHPAPP);
And get a:
SQL error: [iODBC][Driver Manager]Option type out
Server
-Original Message-
From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID
Sure, I'm simply trying to have PHP pass an ApplicationID to the
ODBC server.
When a PHP
Evangelism
http://www.openlinksw.com/virtuoso/whatis.htm
OpenLink Virtuoso Internet Data Integration Server
-Original Message-
From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID
Integration Server
-Original Message-
From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID
Sure, I'm simply trying to have PHP pass an ApplicationID to the
ODBC server
I am trying to set the ApplicationID, when connecting to an ODBC
datasource. I have tried:
odbc_setoption ($conn, 1, 1053, PHPAPP);
And get a:
SQL error: [iODBC][Driver Manager]Option type out of range, SQL state
S1092 in SetConnectOption
Basically, I want my PHP script to pass the
I know you can do an SQL LIMIT 0, 30 on MySQL Is there any way to do this
kind of limit (ie select only the first 30 rows) on an Access database? I
want to lower the overhead of having to select all the database rows only to
show the first 30
Any help is appreciated Thanks,
Mike
1 - 100 of 172 matches
Mail list logo