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
site, select the driver bits with your
Linux box selected as client, and your Win box as server.
Free support is available at http://www.openlinksw.com/support/suppindx.htm
if you run into problems.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinks
again I have to remove
> the configuration
> from the ODBC and create again.
>
> []s
>
> Ariadne
>
>
>
> Mensagem original
>
> >Ariadne,
> >
> >What is the exact error you get?
> >Among other debugging tricks, you can get an ODBC trace from th
-Tier Drivers if you like, which download with a
free 2-connection license and do not expire.
They are available at our website, and free support is available at
http://www.openlinksw.com/support/suppindx.htm if you need assistance.
Hope this helps!
Best regards,
Andrew Hill
Director of Techn
ction license that does not expire. You may also use any
other ODBC driver that you like, or use the iODBC SDK to write your own ODBC
driver if you feel strongly that this should be a free item.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Univ
Gabe,
ODBC does not require IPX. It's a layer above and dosn't care.
Creating a DSN in your odbc.ini on the linux box (after building
PHP --with-iodbc) should work fine.
Check out the HOWTO at www.iodbc.org.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Sof
ailable at
http://www.openlinksw.com/support/suppindx.htm
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
"Adam Oliver" <[EMAIL PROTECTED]> wrote in message
with diagnostic tools such as odbctest.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Jonathan Hilgeman [mailto:[EMAIL PROTECTE
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
Jonathan,
Passing different configs should be as simple as passing different $dsn
values in, and configure the info in your odbc.ini file.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Techno
question on the DB list - the cross
post to the general list isn't necessary.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Jo
It's pretty easy.
Compile using --with-iodbc as in the HOWTO at www.iodbc.org.
You will need ODBC drivers as well - you may download free, non-expiring
2-connection ones from OpenLink and we will provide any support needed to
get you running.
Best regards,
Andrew Hill
Director of Techn
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 In
That's a yes.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
> Sent: Friday,
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 Evan
inly get our working :) much better logging, etc if you have a
problem. If you want to try ours it should be fairly straightfoward :) You
can use either Lite or MT.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Dat
roducts at
http://www.openlinksw.com/support/suppindx.htm.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Todd Cary [mailto:[EMAI
Hi,
Can anyone recommend either a general approach or sample scripts to create a
search-box on my site?
It's an existing site being dynamically generated from a database - I want
to specify a couple of fields in my main page table to be searched on.
cheers,
duirfire
__
,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Danny Nguyen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 1:04 PM
> To:
Oracle connectivity from Linux
>
>
>
> Does the configuration only necessary on the client end or I need
> cofiguration done on the server side as well for iODBC & Oracle
> Driver to work?
>
> Andrew Hill <[EMAIL PROTECTED]> wrote: Danny,
>
> iODBC and
yback' architecture.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Danny Nguyen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, Sep
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-
&g
t doesn't work, try $dsn="dsn=MQIS";
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Victor Espina [mailto:[
Daniel,
What driver are you using?
I'll check your code against another one for comparison's sake, and do some
property queries.
Actually, if you want to query the driver for it's features yourself, you
can download a trial of ODBCScan from our site.
Best regards,
Andrew H
Not sure, but possibly it's an ORACLE_HOME not being set issue.
Best regards,
Andrew
> -Original Message-
> From: Brian Ofsthus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:17 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] NEED HELP WITH ORACLE & PHP PLZ.
>
>
> I
s - fun to work with in
PHP :)
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Szii [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday
Sure, just use ODBC - it'll insulate you from issues like changing database
versions and platforms.
You can use native drivers or download ones from our site.
Let me know if I can help.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinks
this helps.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Ricky Theil [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September
Scott,
That is what ODBC is for.
Compile --with-iodbc as per the howto at www.iodbc.org
and you can use ODBC drivers for multiple database platforms at the same
time.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access
any
> databases but it failed to meant to say that only "with" one
> databases, but
> not multiple databases at the same time.
>
> Scott
> "Andrew Hill" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> &
On Windows, PHP can access Access via ODBC.
On Linux, PHP can also hit a Windows Access server via ODBC, but a two-tier
connection is needed whereby a Linux DSN talks to a Windows DSN.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Also, ensure that this is a System DSN.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Frank M. Kromann [mailto:[EMAIL PROTECTE
lacking
a primary key (e.g. views).
To verify that this performance is directly the result of the default cursor
setting, change SQL_CURSOR_DYNAMIC to SQL_CURSOR_STATIC in php_odbc.c and
recompile.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
If you attempt to echo out a Resource Id it tells you it's name :)
This should still work in an exec.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Orig
Does this DSN test successfully in the ODBC Administrator?
If so, try an odbc trace - see what's going on.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -
matched exactly. Overall our drivers
work quite well with PHP.
If there is any issue I can help resolve, please don't hesitate to contact
me.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integrat
If your drivers suppport Cursors, then sure :)
You can download OpenLink's for free - they come with a non-expiring 2-user
license.
There are 5 different cursor implementations in OpenLink's drivers, from
Foward Only through Bidirectional to Dynamic.
Best regards,
Andrew Hill
D
Michael,
Have you generated an ODBC trace?
You can see what values are being passed into ODBC and where the error is
occurring.
Also, knowing what driver/database/platform would help :)
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Hmm! Sometimes tracing needs to be turned off and then back on. The driver
manager in Windows can be buggy.
Also, select some drive level file to be safe, like c:/sql.log
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data
Anthony,
Is the DSN usable from the ODBC Administrator control panel?
E.g. test it there first. Also, you mention File DSNs? PHP can only use
System DSNs on Windows, AFAIK.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data
Anthony,
Then enable ODBC tracing in the ODBC Administrator and see where the calls
are failing.
Or try a different ODBC driver - you can download free ones from our site
for most databases.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
a 2-connection
license from our site.
Free support for installation is available at
http://www.openlinksw.com/support/suppindx.htm.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Provide
.
5. again, from Oracle :)
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: D. Witten [mailto:[EMAIL PROTECTED]]
> Sent: Friday,
Jacob, Ryan
MSSQL functions use the Sybase OpenClient or FreeTDS,
Some ODBC drivers do impose this restriction, however OpenLink's 4.1 ODBC
drivers allow return of the full overloaded data.
Please let me know if you require any assistance in configuring ODBC.
Best regards,
Andrew Hill
Dir
Hi,
DB-Library based drivers don't fully support SQLServer 2000.
If you are on Windows, use ODBC with the native driver or download the
OpenLink Single or Multi-Tier driver.
If you are on Linux, you can use the OpenLink Multi-Tier driver for
SQLServer.
Best regards,
Andrew Hill
Direct
HOWTO's on that site
for linking --with-iodbc.
Also, you will need ODBC drivers; OpenLink provides a free download of our
commercial drivers at www.openlinksw.com.
Please let me know if you require further assistance.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Sof
Chris,
You'll need a Windows OS to hit MS Access.
OpenLink's Multi-Tier drivers can affect this connection for you if you have
a Windows box, but without Windows you may be out of luck.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.open
www.openlinksw.com. You will get better
support for SQLServer2000 (e.g. datatypes) via ODBC than if you use either
option above.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Provi
Ruprecht,
SQLServer from Linux is pretty straightfoward.
If you want full SQLServer2000 support, you will want to use ODBC.
There is a HOWTO at www.iodbc.org for linking PHP --with-iodbc.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
e in the ODBC Administrator (the ODBC Driver Manager) using the MS
Driver for Access and you should be all set.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
--
PHP Database
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Philippe Saladin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 27, 2001
Dave,
This is easily accomplished via ODBC.
Check out the PHP ODBC HOWTO's at www.iodbc.org, and let me know if you have
further questions.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data In
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 &
art.
Also, check the output of your phpinfo(); to verify ODBC is enabled - the
link you gave to info.php is 'forbidden'.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
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 [mai
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
U
www.openlinksw.com.
If you require assistance, free support is available at
http://www.openlinksw.com/support/suppindx.htm
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Provi
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 Soft
table and
then use the PHP date() function to convert, e.g.:
while (list ($timestamp) = each ($result_array))
{
$new_format = date(Y-m-d, $timestamp);
echo "$new_format";
}
Best regards,
Andrew Hill
Director of Technology Evangelism
Ope
date
> from my_table"
>
> --
>
>
> Best regards,
> George Nicolae
> IT Manager
> ___
> X-Playin - Professional Web Design
> www.x-playin.f2s.com
>
>
>
> "Andrew Hill" <[EMAIL PROTECTED]> wrote in message
> [EMA
Hi Christian,
Could you please open a support case at
www.openlinksw.com/support/suppindx.htm?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original
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
ivers are available as a free download (2-connection license) from
www.openlinksw.com
Hope this helps!
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Orig
on
dropdowns)
"foo" - DSN configured with the Microsoft driver for Excel that can open the
spreadsheet
All components are available as free downloads from OpenLink's website.
Free support is available at http://www.openlinksw.com/support/suppindx.htm
Hope this helps!
Best regards,
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Paul G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 6:08 PM
>
Matt,
The forthcoming Wrox book "Professional PHP4" covers database normalization,
database design, etc., as well as specific PHP, and designs a sample
application so you can put it into practice.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Soft
Thomas,
You can use the HOWTO at www.iodbc.org for assistance in recompiling
PHP --with-iodbc.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original
explanations in the
HOWTO at www.iodbc.org. It's *nix geared, but just remove the putenv()'s
at the beninning of the examples and they will work fine.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Virtuoso Univer
101 - 168 of 168 matches
Mail list logo
