RE: [PHP-DB] extracting data

and 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 Universal Server

Re: [PHP-DB] Problems with ODBC connectivity

Bill, 1. Are you getting an error message in your PHP? 2. Can you successfully test the DSN in the ODBC Administrator? 3. Is the ODBC entry uncommented in the php.ini for your new install? Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access

Re: [PHP-DB] PHP-ODBC

to be set to connect properly. Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Thursday, October 24, 2002, at 10:24 AM, Poduval, Nithin wrote: Hi All, We are also

Re: [PHP-DB] Re: ODBC?

And if you are using ODBC from *nix, you will want to configure it --with-iodbc as per the HOWTO at www.iodbc.org. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software - http://www.openlinksw.com On Tuesday, September 24, 2002, at 10:34 AM, Ever Lopez wrote: First

RE: [PHP-DB] Problem with dsn

Gian, You need to setup a DSN, not just pass the name of the database. There are some examples in the iODBC HOWTO that may help: http://www.iodbc.org/odbc-phpHOWTO.html Pay attention to the section on putenv() and configure your DSN in the odbc.ini file. Best regards, Andrew Hill Director

RE: [PHP-DB] FW: Php database support

, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Walgamotte, David [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 8:16 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] FW

Re: [PHP-DB] obdc_pconnect problems

Have you tried with alternate drivers? Either way, you can capture an ODBC trace to see what is going on. The odbc.ini should have an entry for tracing that you can uncomment. Best regards, Andrew Hill OpenLink Software. On Friday, July 26, 2002, at 03:25 AM, Escuder Nicolas wrote: Hello, i

Re: [PHP-DB] Re: odbc data sort problem (i think) :)

Lukas, Use varchar instead of char to avoid this issue - that is the behavior you should expect regardless of the driver or ODBC use. Best regards, Andrew Hill OpenLink Software On Thursday, August 29, 2002, at 05:07 AM, Lukas Boldrino wrote: i got the problem. the odbc driver fills unuses

RE: [PHP-DB] Re: problem with php and unixODBC

Marten, Look at the output of a phpinfo() when you have the putenv()'s - you can see that there are a couple of different environments here. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server

RE: [PHP-DB] What MDAC version for MSSQL?

Salve, I can't think that the .html extension would cause this behavior, but it might cause your app to slow down a bit if it's lot lots of non-php code on the .html pages on the server. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com

RE: [PHP-DB] MSSQL functions vs. ODBC functions

functional lacks. Also, If you are going to migrate databases and have to change the database API calls in your script, do yourself a favor and use PEAR:DB with ODBC - less changes in the future. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com

RE: [PHP-DB] Re: MS Access - default value in create table

I suggest putting the column name in quotes. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Nuttzy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17

RE: [PHP-DB] obdc_pconnect problems

Nicolas, I believe the _pconnect functions all close connections if you close the script - they are most useful when you have multiple connections in a single page. Also, are you using the CGI version of PHP? Pconnects are not persistent with this version. Best regards, Andrew Hill Director

RE: [PHP-DB] PicoSQL!

If it's got an ODBC driver then you are all set - maybe port the ODBC driver to *nix using iODBC? www.iodbc.org Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message

RE: [PHP-DB] Re: Unified DB Query function

ODBC drivers are indeed week, but a proper driver provides more complete functionality than even native drivers, and is often faster. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server

[PHP-DB] HOWTO: ODBC-PHP-Apache2

://www.iodbc.org/odbc-php-apache2.html Please provide feedback and comments! Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software What is Virtuoso? http://www.openlinksw.com/virtuoso/whatis.htm -- PHP Database

RE: [PHP-DB] MS Access DB Open as file ?

, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Ivan Lam [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MS Access DB

RE: [PHP-DB] [php][odbc_connect]

the ODBC dll statement in the php.ini. Hope this helps! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] Re: Question about ODBC databases

is with regards to ODBC. Let me know if you have configuration questions. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Anthony [mailto:[EMAIL PROTECTED

RE: [PHP-DB] Re: Question about ODBC databases

Gerardo, Access can only be served by Windows - you need to connect to it remotely. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Gerardo Morales [mailto

RE: [PHP-DB] Re: Question about ODBC databases

Anthony, No, you are right. The closest you could do is to use an ODBC-ODBC Bridge, and connect to a DSN on computer A that piggybacked on a DSN on computer B. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access

RE: [PHP-DB] Sybase - MSSQL Server 2000

Tom, I suggest you use ODBC or Free-TDS. For info on linking your PHP build against an ODBC Driver Manager (necessary to use ODBC) see the PHP-ODBC HOWTO at http://www.iodbc.org. Best regards, Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML E-Business

Re: [PHP-DB] Cross DB application

ARcadius, You may use an abstraction library such as PEARDB or ADODB, or simply the unified ODBC functions. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software Hello ! I'm planning to write a database application for MySQL, and then port it to PostrgeSQL

RE: [PHP-DB] Re: ODBC and images

Bilbo, Also, if you could provide your code that might help. I'd guess you are having some problem with the data types and your driver as well; that info would be helpful to assist. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm

RE: [PHP-DB] ODBC -- Setting ApplicationID

to 4.2 Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:02 AM

RE: [PHP-DB] ODBC -- Setting ApplicationID

, based on the application. Again, I'd strongly recommend you upgrade the OpenLink UDA version as well; 1.5 is something 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

RE: [PHP-DB] ODBC -- Setting ApplicationID

somewhat off-topic for PHP. Hope this helps! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers I was thinking of using the usernames, but as people come and go, that might mean

RE: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry

Jason, Or you can use ODBC, as per the HOWTO at www.iodbc.org, which eliminates the ned to install the Oracle client and enables you to develop applications independent of database. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm

RE: [PHP-DB] [OpenLink][ODBC][Driver]No key columns found for table referenced by keyset driven cursor

case at http://www.openlinksw.com/support/suppindx.htm Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: Paulo Freitas [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] starting odbc for w2k and iis

-based PHP client. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Eduardo Cancino [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10

RE: [PHP-DB] Error insert into MS-access through ODBC not aviable

Penockio, You might find this helpful: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168 Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From

RE: [PHP-DB] Database Connection

start time. Try setting LD_LIBRARY_PATH environment variable to include the location of your DB2 Client. Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers

RE: [PHP-DB] ODBC

downloads. On Windows, only drivers need to be installed, as the Driver Manager is present (MDAC or ODBC Administrator) and PHP builds for Windows can use this by default. Hope this helps! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com

RE: [PHP-DB] odbc functions

($result_id); ? 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]] Sent: Monday, February 04, 2002 10:36 AM

RE: [PHP-DB] same connection to access two different 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: Vincent Ma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 8:46 PM To: [EMAIL

RE: [PHP-DB] iODBC module for PHP on linux

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 Message- From

RE: [PHP-DB] FreeBSD 4.2 and ODBC

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 To: [EMAIL PROTECTED

RE: [PHP-DB] How can recommend a book for SQL and DB design

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 Software http

RE: [PHP-DB] Moving from MySQL to MSSQL Server 2000

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 -Original Message- From

RE: [PHP-DB] FreeBSD 4.2 and ODBC

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, Andrew Hill Director of Technology Evangelism OpenLink Software http

RE: [PHP-DB] PHP4 + ODBC Openlink +ORACLE 8.1 on DIGITAL

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 Message- From

RE: [PHP-DB] odbc and access

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

RE: [PHP-DB] odbc date

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

RE: [PHP-DB] odbc date

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_formatbr; } Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http

RE: [PHP-DB] odbc date

___ X-Playin - Professional Web Design www.x-playin.f2s.com Andrew Hill [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... George, The ODBC date syntax is best used for to make input format unambiguous, e.g.: select * from orders where order_da

RE: [PHP-DB] php and accessconnection

at 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 Providers

RE: [PHP-DB] ODBC MS SQL Server 7

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

RE: [PHP-DB] ODBC .. ehm .. help :)

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

RE: [PHP-DB] ODBC .. ehm .. help :)

, 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 -Original Message

RE: [PHP-DB] Oracle, PHP4, BSD

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 Integration Technology

RE: [PHP-DB] PHP and MS SQL 2000 Performance

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

RE: [PHP-DB] MSSQL 2000 and PHP on Linux..

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 Providers

RE: [PHP-DB] PHP/MySQL to M$ Access

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.openlinksw.com

RE: [PHP-DB] Access with PHP on Linux?

, and there are 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 Software

RE: [PHP-DB] MSSQL Error with MSSQL 2000

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 Director

RE: [PHP-DB] Oracle, PHP4, BSD

, 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, November 09, 2001 12:52 PM

RE: [PHP-DB] PHP and Informix under Linux

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 Providers -Original

RE: [PHP-DB] Re: Newbie: odbc_prepare parameters

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

RE: [PHP-DB] help connecting to ODBC

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

RE: [PHP-DB] help connecting to ODBC

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

RE: [PHP-DB] Other ODBC driver besides an openlink one?

. 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 Integration Technology Providers

RE: [PHP-DB] updating records in ODBC with cursor

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 Director

RE: [PHP-DB] DB2 Performance issue

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 Universal

RE: [PHP-DB] connecting SQL 7.0

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 -Original Message

RE: [PHP-DB] connecting SQL 7.0

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 -Original

RE: [PHP-DB] PHP vs. 2 database softwares

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]... Scott, That is what ODBC is for. Compile --with-iodbc as per the howto at www.iodbc.org and you can use ODBC

RE: [PHP-DB] PHP and MS Access

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

RE: [PHP-DB] mssql functions on unix

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 26, 2001 12:25 PM

RE: [PHP-DB] php and mssql 8

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.openlinksw.com

RE: [PHP-DB] db's war

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, September 18, 2001 4:22 PM

RE: [PHP-DB] ODBC connection under Win32 + Apache + SQL Server

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

RE: [PHP-DB] Re: Problem with odbc_next_result

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 Hill Director

RE: [PHP-DB] ODBC connection problem

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

RE: [PHP-DB] Oracle connectivity from Linux

, 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: [EMAIL PROTECTED] Subject

RE: [PHP-DB] Oracle connectivity from Linux

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 appropriate ODBC drivers are certainly a production-quality solution. If you like

RE: [PHP-DB] Oracle connectivity from Linux

' 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, September 10, 2001 4:28 PM

[PHP-DB] search engine for database driven site?

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

RE: [PHP-DB] ODBC and SQL Server

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

RE: [PHP-DB] ODBC and SQL Server

:) 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 Data Integration Technology

RE: [PHP-DB] ODBC and SQL Server

://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:[EMAIL PROTECTED]] Sent: Wednesday

RE: [PHP-DB] Php and ODBC

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 Technology

RE: [PHP-DB] ODBC Drivers that doesn't support odbc_fetch_row

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

RE: [PHP-DB] PHP and ms Access

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, August 31, 2001 9:43 AM

RE: [PHP-DB] ODBC Woes

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

RE: [PHP-DB] ODBC Woes

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 Technology

[PHP-DB] RE: [PHP] iODBC Troubles / Troubles in ODBC Land

these 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: Jonathan Hilgeman

RE: [PHP-DB] Troubles in ODBC Land

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 PROTECTED]] Sent: Monday

RE: [PHP-DB] MS SQL connect by ODBC

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 Technology

RE: [PHP-DB] ODBC and PHP

, 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

RE: [PHP-DB] ODBC and PHP

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

RE: [PHP-DB] Oracle Client Libraries?

Tom, From Oracle :) Alternativley you can use the OpenLink Multi-Tier ODBC driver at www.openlinksw.com. It downloads with a free 2-connection license, and has free support available at www.openlinksw.com/support/suppindx.htm HTH! Best regards, Andrew Hill Director of Technology Evangelism

RE: [PHP-DB] PHP4-ODBC-MSSQL7

Micheal, If things work in Query but not PHP you can easily get an under-the-covers comparison of the ODBC calls by turning on Tracing in the ODBC Administrator (Driver Manager). Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal

RE: [PHP-DB] testing ODBC + MSSQL connection locally

SDK and using --with-iodbc=/path/to/odbcsdk Let me know if you require assistance. 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

RE: [PHP-DB] IBM DB2 on Linux with PHP is very slow

, free support is available at http://www.openlinksw.com/support/suppindx.htm Please let me know if you require assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers

RE: [PHP-DB] Looking for info on PHP 4 Ingres DB

Patrick, http://www.php.net/manual/en/ref.ingres.php Alternatively, ODBC should work just fine. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message

RE: [PHP-DB] Does PHP work with MSSQL 2000?

It also works well with ODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: snpe [mailto:[EMAIL PROTECTED]] Sent: Friday, June 22, 2001 9

RE: [PHP-DB] PHP4 ODBC after NTsp6 upgrade REALLY SLOW!!!

) to see what is happening. You are also welcome to try OpenLink's drivers, available at http://www.openlinksw.com/main/softdld.htm Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers

RE: [PHP-DB] odbc errors

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

RE: [PHP-DB] Problems with PHP / Progress / ODBC

Hi, You may wish to try OpenLink's ODBC drivers, available at http://www.openlinksw.com/. We have excellent support for Progress databases. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology

RE: [PHP-DB] ODBC and Memofields

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

  1   2   >