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: http://www.ph
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 we
Good morning,
I have almost the same problem, but just with cirilic characters.
I have this state on every page, html and php:
if I try to show cirilic characters I don't have problems.
If I try to insert names in cirilic then I have problems with some
characters only. If I insert the names in
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 pro
>$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 obj
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 r
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
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 free
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. For
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
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
shows
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: Thursday
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. A
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 Ser
Otherwise, you might want to look into using DSN-less connections 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
&g
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 se
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 (yo
pages.
> Otherwise, you might want to look into using DSN-less connections 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
: [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 a problem, the DSN will not
query a Database at all, it will query 3 Fox Pro Tables, what query
should i use then? any ide
Ok, it worked on the local machine if i do
odbc_connect("telefonia","","")
But, if i'm on the remote machine, i have a problem, the DSN will not
query a Database at all, it will query 3 Fox Pro Tables, what query
should i use then? any idea?
thanks for the help :)
On Tue, 2003-10-14 at 10:21,
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:
$conn=odbc_connect("Driver={Micros
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 Dat
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.
an" <[EMAIL
PROTECTED]>, [EMAIL PROTECTED], Robert
08/11/2003 10:37 Twitty <[EMAIL PROTECTED]>
AM Subject:
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 th
PROTECTED]>, [EMAIL PROTECTED]
08/11/2003 10:35 Subject: Re: [PHP-DB] ODBC Database
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
p
[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 laye
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
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
does
> 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 Ho
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
othe
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 t
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
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 er
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
salamander <[EMAIL PROTECTED]> wrote on 08/09/2002 04:31:35 PM:
> Chip,
> I wonder if you set the ODBCINI environment variable with the putenv()?
Yep, they are there and I am getting this error when attempting to load the
web page -
Warning: SQL error: [iODBC][Driver Manager]Specified driver
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.
Chee
Thanks, that fixed that part of it, now here's the newest error message:
Warning: SQL error: [iODBC][Driver Manager]Specified driver could not be
loaded, SQL
state IM003 in SQLConnect in /usr/local/apache/htdocs/odbctest.php on line
7
Fatal error: Call to undefined function: error_handler() in
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 PHP/
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?
--
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 ru
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 s
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]
Subje
-Original Message-
From: John Lim [mailto:[EMAIL PROTECTED]]
Sent: 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
have this
solved in no time and I'd bet even they would recommend a commercial 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 PROTEC
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
mend a commercial 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
oblem 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 that would be more careful about mak
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 me
s old or more.
> >
> > Best regards,
> > Andrew Hill
> > Director of Technology Evangelism
> > http://www.openlinksw.com/virtuoso/whatis.htm
> > OpenLink Virtuoso Internet Data Integration Server
> >
> > > -Original Message-
> > >
years old or more.
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> http://www.openlinksw.com/virtuoso/whatis.htm
> OpenLink Virtuoso Internet Data Integration Server
>
> > -----Original Message-
> > From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]]
hing like 5 years old or more.
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> http://www.openlinksw.com/virtuoso/whatis.htm
> OpenLink Virtuoso Internet Data Integration Server
>
> > -Original Message-
> > From: Bruce S. Garlock [mailto
ata 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 a
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
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 4.2
Richard,
Simple example using MS SQL Server:
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Richard Black [mailto:[EMAIL PROTECTED]]
>
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 O
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 Visua
>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 Fo
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 &
riginal 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 table an
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 t
Director of Technology Evangelism
> OpenLink Software http://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
&g
nLink Software http://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"))).
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 forma
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 http://www.openlinksw.co
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 regardles
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 & Dat
Charles,
The specific error message would be helpful.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Charles F. McKnight [mailto:[EMAIL PR
> -Original Message-
> 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 ste
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 Integ
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'
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 ma
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,
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
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
[EMAI
L PROTECTED]]
> Sent: Wednesday, 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. Anyth
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 Mai
a Integration Technology 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 -
>
>
Andrew -
Could it be that the string, "Acct32_ODBC\ 0", should be "Acct32_ODBC"?
If so, how do I get rid of the terminating "\0" in PHP?
Todd
--
Todd Cary
Ariste Software
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
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
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 Soft
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 Te
logy 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
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_typ
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:
> odbc_connect("
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
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 o
IL PROTECTED]
> Subject: RE: [PHP-DB] ODBC and PHP
>
>
>
> The error message is:
>
> -
> Cadastro de Fornecedor
>
>
> Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named
> Pipes]ConnectionTrans
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:\inetpub\inventario\cadastro\forneced
Check the /etc/services if Unix/Linux or c:\windows\services if windows. In
the ODBC definition you supply a service name wich must to exist in this
file. I hope this helps.
-Original Message-
From: sdk [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 12:29 PM
To: [EMAIL PROTECTED]
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
David,
This is most likely related to an issue in the cursor library of PHP that we
are working diligently to resolve.
To assist, could you please:
1. open a support case at http://www.openlinksw.com/support/suppindx.htm
2. generate an ODBC trace by adding the following lines to y
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
kn
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
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 "Coul
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: Jel
1 - 100 of 106 matches
Mail list logo
