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
this sounds a little bit like a wrong charset. I don't know which one your
database or your php is running on, but, for a start, play with this:
- charset of the file: If you open your file in an editor that allows
storing it as different kinds of charsets, try saving it as something else.
It's
Good morning,
I have almost the same problem, but just with cirilic characters.
I have this state on every page, html and php:
meta http-equiv=Content-Type content=text/html; charset=utf-8
if I try to show cirilic characters I don't have problems.
If I try to insert names in cirilic then I have
$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
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
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.
Take a look at ADODB (It's a good database library that supports a
variety of systems):
http://php.weblogs.com/ADODB
Here's a quick intro:
http://www.databasejournal.com/features/php/article.php/651
-Original Message-
From: Galbreath, Mark A [mailto:[EMAIL PROTECTED]
Sent:
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
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
odbc_connect requires three parameters: you have specified just one. PHP
takes the string between the pairs of double-quotes to be just one
parameter. You will also need to specify a username and password for access
to the DB. Assuming you have none, try this:
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.
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?
MySQL is kind of free, installs on W2K and is easy to use but it
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
Nico,
I'm using MyODBC to query MySQL (because my client want's it to work in
Access, and I don't and this leaves the least amount of code to change).
I don't get an error message if the result is empty (no records). I do a
while loop and add to a counter and if the counter 1 then its empty
No, that won't work. You need to create a system DSN. Here's what I did to
create one. My PC is running Windows XP Professional and I am using Apache
1.3.27.
* opened up the control panel
* double-clicked Administrative Tools
* double-clicked Data Sources (ODBC)
* clicked on the System DSN
Ok I tried this another way but using the ms sql functions along with:
ini_set(mssql.timeout,2);
ini_set(mssql.connect_timeout,2);
... no change, it still takes about 7-8 seconds to decide it couldn't connect.
Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Monday, March 03,
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
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
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
Try copying your .mdb to a new file and opening that one. I've seen this before. It
really has nothing to do with PHP, it's a microsoft issue.
Ryan
-Original Message-
From: Juan Angel Ringhetti [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 2:08 PM
To: [EMAIL PROTECTED]
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
mmercial hosting
service be 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
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'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 of a
work around, especially not one you can implement if you don't handle your own server.
I feel your pain man! Fortunately for
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
-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
Bruce,
I'm not sure what you are trying to do - could you clarify?
You may be able to simply use the OpenLink Rules Book to set role-based
authentication on domain, ip, application, etc.
Also, the ODBC Driver version (1.5) you are using is _very_ old and
unsupported.
I suggest you upgrade to
Sure, I'm simply trying to have PHP pass an ApplicationID to the ODBC server.
When a PHP script access the ODBC database, it does not set the application:
10:46:04 connectopts= user=webuser opsys=unix machine=linux application=
As you can see, application= is NULL. I would like the script to
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
Morten,
ODBC stands for Open Database Connectivity. It's a connection layer (API)
that is non-database-specific.
This removes application dependence on one particular database, e.g. using
ODBC instead of native functions allows you to write your application
against MySQL and then deploy on
Richard,
Simple example using MS SQL Server:
?php
$dsn=Northwind;
$usr=sa;
$pwd=;
$qual=Northwind;
$owner=dbo;
$table=Orders;
$conn_id = odbc_connect($dsn, $usr, $pwd) or die (odbc_error());
$result_id = odbc_primarykeys($conn_id, $qual, $owner, $table) or die
(odbc_error());
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a Visual
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a
Sam,
If this is Windows, ensure you are using a System DSN.
If this is *nix, ensure you have an ODBC driver installed and the odbc.ini
file pointed to via a putenv().
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access
George,
You can use the date() function in PHP to change the format:
http://www.php.net/manual/en/function.date.php
Or you can format it with odbc date syntax in your query { d '-MM-DD' }
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
i did it with date(F j, Y,strtotime(odbc_result($cur,date))).
but i very curios about the query. it must looke like..?
select date from my_table?
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
Or you can format it
://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
i did it with date(F j, Y,strtotime(odbc_result($cur,date
-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
i did it with date(F j, Y,strtotime(odbc_result($cur,date))).
but i very curios about the query. it must looke like..?
select date from
George,
Yes, using the date() example.
Cheers,
Andrew
-Original Message-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
it is right but I want to select all data from a mdbdatabase
001 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
it is right but I want to select all data from a mdbdatabase table and I
receive in '/mm/dd hh:mm:ss' format.
I told you I resolve this problem with date(F j,
Y,strtotime(odbc_result($cur,date))).
I what to know
If everything else fails, you can retrieve unix_timestamp(date) and use PHP's
date() to format the output.
HTH
Bogdan
George Nicolae wrote:
for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field,
php will automatically convert it to '/mm/dd hh:mm:ss' format regardless
Javalina,
What is the exact error message your are getting?
Also, try the odbctest sample program with the select * from frases
query - does it return results?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data
Hello,
We resolved ourselves the problem by changing the ODBC driver.
Bye.
- Original Message -
From: Christine Cameli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Katell Galard [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 5:03 PM
Subject: [PHP-DB] ODBC problem
Hello,
I'm
Bikkel,
Is ODBC enabled on your sever?
If this is a *nix server, follow the Howto at www.iodbc.org. If windows,
check your odbc.ini for the proper setting.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data
-
From: b i k k e l [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:24 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ODBC .. ehm .. help :)
Yes, i follows all the steps described at www.iodbc.org. Still no
result :(
--
Original
Alfarees,
To get the first 5 in the order they were added to the database ...
select * from tablename limit 5;
or, for the 5 topmost, highest value
select * from tablename where somefield.value somecriteria order by
tablename.somefield limit 5
Now check docs for exact synatx - TOP
Victor,
Your DSN is not being passed correctly.
Under unix this could be an envrionment variable issue, but I suspect that
you just have a reference error.
Try something like:
$dsn=MQIS;
$pwd=sa;
$conn=odbc_connect($dsn,$pwd,);
if that doesn't work, try $dsn=dsn=MQIS;
Best regards,
Andrew
Don,
Your DSN may be set to exclusive connection mode (check under options).
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: Don Jackson
Well, does the Test button on your ODBC Admininstrator shed any light? :)
If it works there, and doesn't work in your PHP, create an ODBC Trace in the
Administrator so you can see the exact parameters of the connect.
HTH
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink
Andrew -
Thank you for getting back to me...
Well, does the Test button on your ODBC Admininstrator shed any light?
:)
If it works there, and doesn't work in your PHP, create an ODBC Trace in
the
Administrator so you can see the exact parameters of the connect.
The test does give me an
Providers
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 5:42 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC and SQL Server
Andrew -
Could it be that the string, Acct32_ODBC\ 0, should be Acct32_ODBC
Andrew -
What I am trying to do is to find out if I can use PHP with my client's
MS SQL Server DB. Anything that can help me obtain that information
would be greatly appreciated.
OS: Win 2K (SP 2)
DBMS: MS SQl Server 7
Todd
--
Todd Cary
Ariste Software
[EMAIL PROTECTED]
--
PHP Database
, September 05, 2001 6:16 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC and SQL Server
Andrew -
What I am trying to do is to find out if I can use PHP with my client's
MS SQL Server DB. Anything that can help me obtain that information
would be greatly
Andrew -
Since I installed the OpenLink ODBC, the MS SQL Server Enterprise
Manager has just about become useless as well as MS SQL Server itself.
It take many minutes to do just about anything - even after I
uninstalled OL.
Do you have any suggestions?
Todd
--
Todd Cary
Ariste Software
Erich,
ODBCScan is a tool that can interrogate ODBC drivers to discover properties
they support.
It's available to download from www.openlinksw.com
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration
Nope, it depends on the driver manager you are using, and I believe the
first example has been deprecated in nearly all cases. Why do you need to
use the first?
Just use variables:
$dsn=dsnname;
$uid=user;
$pwd=password;
odbc_conenct($dsn, $uid, $pwd)
Best regards,
Andrew Hill
Director of
I am attempting to use oPAYc (www.opayc.com) as a central method of payment
processing. In order to pass information like different store configs or
certificates at runtime, I need to pass them in the DSN string area. I'm
using iODBC right now.
- Jonathan
Andrew Hill [EMAIL PROTECTED] wrote in
On Tuesday 28 August 2001 22:05, Jonathan Hilgeman wrote:
Okay, all I need to know is this:
Some people say that they can only connect with:
odbc_connect(DSN=Datasource;UID=username;PWD=password,,);
Others say that doesn't work, and that they can only connect with:
if($TFM_Doesnt_Have_Anything_About_It == 1)
{
$Shut_Yer_Unhelpful_Trap = 1;
$You-RTFM see();
}
Yves Glodt [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
if ($RTFM == 1) {
int odbc_connect (string dsn, string user, string password [, int
cursor_type])
}
Providers
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 4:15 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ODBC Woes
I am attempting to use oPAYc (www.opayc.com) as a central method
of payment
processing. In order to pass
The error message is:
-
Cadastro de Fornecedor
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact
(TransactNamedPipe())., SQL state 01000 in SQLExecDirect in
: RE: [PHP-DB] ODBC and PHP
The error message is:
-
Cadastro de Fornecedor
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionTransact
(TransactNamedPipe())., SQL state 01000 in SQLExecDirect in
c
Ariadne,
What is the exact error you get?
Among other debugging tricks, you can get an ODBC trace from the ODBC
Administrator control panel (if using Win32 on client side) and look at
where the API calls are failing.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
http://www.microsoft.com/KB/Articles/Q128/8/08.HTM
-Original Message-
From: Dalyyla [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 7:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] odbc with ms access
hi,
Access to data with ms access via odbc is kinda slow . I would like to
Jello,
It appears that your odbc_connect is not happening :)
Can you post your code?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: Jello
Jello,
You may want to look at some of the user comments on odbc_result_all manual on php.net:
http://www.php.net/manual/en/function.odbc-result-all.php
Some people mentions errors and fixes there for your problem. I think you are getting
connected or you would have got your error messages
P.S.
One of the users there mentions that she had to open the odbc_free_result INTO a
variable in order for it to work:
$free_result = odbc_free_result($sql_result); for example
Angie
Jello [EMAIL PROTECTED] 05/15/01 10:27AM
i've just upgraded my computer... running win ME ( i know), PWS
Marcel,
You should generate an ODBC trace (Tracing tab in the ODBC Administrator).
This will expose if the issue is in your Paradox driver, and what it is.
Either way, following up with the driver manufacturer would be a good idea.
Best regards,
Andrew Hill
Director of Technology Evangelism
BDY.RTF
--
PHP Database 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]
shouldn't that be:
$result1 = odbc_prepare($conn, "SELECT * FROM PERSONAS WHERE email =
'$v_mail'");
you have your double quotes at the end in the wrong place.
they should be before the ") not after )"
daevid.com
-Original Message-
From: Fernando Buitrago [mailto:[EMAIL PROTECTED]]
Sergio,
The error indicates PHP cannot find your odbc.ini file that contains your
DSNs.
Try passing its location in:
putenv("path/to/your/pesky/odbc.ini");
HTH
Best regards,
Andrew
--
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness
94 matches
Mail list logo