Re: [PHP-DB] Access MS SQL idnetical thru ODBC ??

if I am wrong. I'm also not sure about 'top'. I believe you have OpenLink's drivers installed? I'll open up access to an SQLServer database for you tomorrow if you want to test the relevant queries yourself. Let me know. Best regards, Andrew -- Andrew Hill

RE: [PHP-DB] failure notice

Mike, Just a hunch, but lots of garbage emails are getting posted to the list ... I wonder if everything in your PHP-DB folder is going to come back out :) Regards, Andrew -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 4:58 PM To: [EMAIL

Re: [PHP-DB] PHP and PROGRESS

Hector, OpenLink has broad support for Progress in our Multi-Tier ODBC drivers. There is a HOWTO available at http://www.iodbc.org/odbc-phpHOWTO.html and the drivers are available at http://www.openlinksw.com Best regards, Andrew -- Andrew Hill Director

[PHP-DB] Re: [PHP] Passing vars

0 lines of code is html that needs to be generated on the fly, break it up into common blocks and drop them in using either method above. You can also do things like passing a hidden form field instead of using a link. Best regards, Andrew ------- Andrew Hill - Op

Re: [PHP-DB] overall db solution anyone?

systems sustaining 8000 concurrent database hits. Virtuoso also works great with PHP; I'd be happy to speak with you about the details of a migration project and how Virtuoso could fit your needs. Best regards, Andrew --- Andrew Hill - OpenLink Software

RE: [PHP-DB] Can PHP read View in stead of Table?

-- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com -Original Message- From: WC Ip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 11:22 PM To: [EMAIL PROTECTED

RE: [PHP-DB] Any word about PHP and PROGRESS?

Hi Hector, You may use OpenLink's ODBC drivers to do this. The drivers are available at http://www.openlinksw.com and a HOWTO on ODBC and PHP is at www.iodbc.org. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism

RE: [PHP-DB] odbc and ibm-db2

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

Re: [PHP-DB] SQL Select?

need to do something with $result. also, if you use mysql_fetch_array instead of mysql_query, you get a row-matched array. Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology Evangelism Virtuoso, eBusinss iNtegration http://www.openlinksw.

RE: [PHP-DB] how do I connect to MSSQL2000 and mySQL with PHP4 and Linux?

e linking against (we maintain iODBC). It should take you about 30 minutes all told. Let me know if you need help. Best regards, Andrew ------ Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinks

Re: [PHP-DB] RE: [PHP] RE: what exactly are /path/to/blah lookingfor? .h? .so? .a? what?!

5127 Mar 7 14:42 odbc.doc -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 2:57 PM To: Daevid Vincent; [EMAIL PROTECTED]; PHP General Subject: [PHP] RE: what exactly are /path/to/blah looking for? .h? .so? .a? what?! Daevi

[PHP-DB] Re: [PHP] RE: [PHP-DB] help with compiling ODBC into PHP4

/l3ko.taz (also available from iODBC.org). If you need other platforms, go to: http://www.iodbc.org/opliodbc.htm (iODBC) or http://www.openlinksw.com/main/softdld.htm (OpenLink) Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology

Re: [PHP-DB] PHP4.0.4 segfaults with odbc_pconnect

now if you need additional assistance. Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] iODBC Mac OS X HOWTO

Okay, so no attachments to the lists :) Here is the HOWTO: http://www.iodbc.org/osxphp_iodbc.htm Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com office

[PHP-DB] iODBC Mac OS X HOWTO

relational database. I'll be uploading it to the www.iodbc.org site, but if anyone would like to comment on the initial draft, it's attached to the post. Any and all feedback is welcome - tell me anything is not clear! Best regards, Andrew -- Andrew Hill - OpenLink

RE: [PHP-DB] Microsoft Access DB PHP

James, Sure - just connect via ODBC and use the odbc_functions in PHP. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com -Original Message- From

RE: [PHP-DB] mysql_result()

-- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:46 AM To: PHP Database Mailing List; PHP General Mailing List

Re: [PHP-DB] Code bombs connecting to MSSQL 7

John, The quotes are throwing it. Try single or no quotes. Best regards, Andrew --- Andrew Hill - Director Technology Evangelism OpenLink Software - http://www.openlinksw.com Internet Data Integration Technology On 4/6/01 4:30 PM, "John A DAVIS&qu

Re: [PHP-DB] odbc_fetch_row

Randall, Try something like: if (!(odbc_result($result_identifier)) echo "result is null"; Best regards, Andrew -------- Andrew Hill . Director Technology Evangelism OpenLink Software . http://www.openlinksw.com Internet Data Integration Technolo

Re: [PHP-DB] 2-Table query

ndrew Andrew Hill . Director Technology Evangelism OpenLink Software . www.openlinksw.com Internet Data Integration Technology On 4/9/01 8:31 PM, "Randall Barber" [EMAIL PROTECTED] wrote: I would like to update two tables at the same time. Currently I update each one separately, like

Re: [PHP-DB] 2-Table query

Whups, that should be a backslash. \; Regards, Andrew On 4/15/01 8:05 PM, "Andrew Hill" [EMAIL PROTECTED] wrote: Randall, Try making $qryStr contain something like "insert into table1 (col1, col2) values ($val1, $val2) /; insert into table2 (col1, col2) values

RE: [PHP-DB] PHPNuke 4 error. Got any clues?

-- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com Ok.. I recently uploaded all the files, followed the readme exactly, set permissions, uploaded the mySQL file, created the database, and all necessary steps to my

RE: [PHP-DB] ibm db2

ODBC access to DB/2 works just fine via PHP. For a HOWTO on enabling ODBC in PHP, see www.iodbc.org. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com

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

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

[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] 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

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] 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] 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] 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] 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 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 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] 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] 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] 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] 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 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] [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] 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] 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] 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

  1   2   >