RE: [PHP-DB] extracting data
You can actually do this from any machine, although you will need an ODBC driver on the Linux/Mac OS X/Unix side. Another alternative is to dump the .mdb to mysql format and move it over. But ODBC is the way to go. Beginning PHP Databases from Wrox cover this a lot, but you can get started with just a DSN and a basic odbc_connect. Create it as a System DSN - it will cause less problems. If you are on a *nix or Mac OS X, then you will want to tell the PHP script where the files are that contain the DSN (odbc.ini) and the ODBC Driver Manager (libiodbc.so). There are basic examples 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 http://www.openlinksw.com/virtuoso/ At 02:27 PM 12/19/2002, SELPH,JASON (HP-Richardson,ex1) wrote: If you are on a windows machine, you can create a DSN to the access file and use odbc from php to connect to it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] extracting data I posted this to the php general list also so forgive me if you are seeing this twice. Can I use php to extract data from an access db? The php script and access db will be local. I will then upload the file to my server. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Tuesday, October 29, 2002, at 04:31 PM, Bill Hudspeth wrote: I have developed a PHP application that accesses a Microsoft Access database through ODBC. The application works well using PHP version 4.1. I have recently installed the newest version of PHP (4.2.3) on another machine running NT4, and IIS 4. Again, I am using an ODBC connection, and have given this connection the same name, login, and password as is present in my PHP files. While the PHP module is running fine, I cannot retrieve records from the database, probably indicating a problem with my connectivity to the ODBC. Again, I have made the same settings in the new ODBC entry as is present on the development machine. Could there be a version problem with the PHP module? Any other suggestions would be greatly appreciated. Thanks, Bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and MS-SQL
Hello, OpenLink provides single-tier ODBC Drivers for MS SQL Server from Mac OS X - these support the additional data types and will work against either Sybase ASE or MS SQL Server, on any platforms they run on. 30-day downloads are available from our site at http://www.openlinksw.com 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 Sunday, October 27, 2002, at 12:22 AM, Frank M. Kromann wrote: Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com -Original Message- From: Axel [mailto:bergmann@;hi.net] Sent: Friday, October 25, 2002 6:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MS-SQL I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP-ODBC
Nithin, This issue is due to the ODBCINI environment variable not being set by in your PHP script, or the odbc.ini file that variable points to not being readable by the user that Apache runs as. Check out the PHP-ODBC-HOWTO at www.iodbc.org for examples of what environment variables need 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 facing a problem in connecting PHP with database, We are trying to access the MS SQL Server 2000 which runs on Windows 2000 from the php in the Linux 7.2. During access the php, it gives the followin message. Warning: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in We do followed all the step done by you. We would like to know how did you solve the issue. We have been using the Openlink database driver.Please help in this issue. Thanks In Advance. With Regards, Nithin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 make sure you have installed the MyODBC Driver
> Then make a odbc DSN to the MySQL database.
>
> Finally try something like this:
>
> odbc_connect($DSN_Name,$UserName, $Password) or die("Could not connect
> to
> the datasource");
>
> Hope this helps...
>
>
> "Chris Payne" <[EMAIL PROTECTED]> escribiÛ en el mensaje
> 000801c263d1$2cf7fec0$f7fea8c0@chris">news:000801c263d1$2cf7fec0$f7fea8c0@chris...
> Hi there everyone,
>
> I have always used MySQL with PHP without any problems using the
> standard
> MySQL connection functionality. Is it possible to connect to a MySQL
> DB via
> ODBC? If so, what would the PHP Connection string be? I am curious
> as my
> email server allows you to use external databases for users accounts
> and I
> figure this way I could write a PHP script to control users email
> accounts.
>
> Thanks everyone, sorry if this sounds like a stupid question, not used
> ODBC
> before so even though I know quite abit about PHP/MySQL, I know diddly
> about
> ODBC :-)
>
> Chris Payne
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server
-Original Message-
From: Gian Michele [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 4:45 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with dsn
I have installed on my computer :
Apache 1.3
Php 4.1.2
Postgresql
the rpm of odbc and the unixODBC.
I tried to connect to my database after done all configurations; I used
the function odbc_pconnect('name_of_my_database','','') and the system
gives me this error
"Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002 in SQLConnect in
/var/www/html/check_avviso2.php on line 5"
Does any body knows as set the DSN and the driver?
Thanks a lot!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] FW: Php database support
David, You will be pleased with OpenLink Software's ODBC Drivers. This requires setting up PHP --with-iodbc, as per the HOWTO's on http://www.iodbc.org and the ODBC drivers are available as a free 30-day download from our site. Please let me know if you have any questions. Best regards, 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: Php database support > Hello All !!! > > We use PHP in a production e-commerce web environment with a mysql > database server. The higher ups have decided they want to move to > Microsoft SQL. I'm now tasked to convert our Unix Apache PHP > environment to use a remote Microsoft SQL server. I've researched and > used TDS the Sybase connector to Microsoft SQL. It works but is very > slow. > > Has anyone completed such a migration ? Can anyone recommend a solid > connector between UNIX PHP and Microsoft SQL DB and a place to go for > setup procedures ? > > Thanks You very much ? > > DW > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 spaces in a row with blanks. > > goddamn *g* > > cu > "Lukas Boldrino" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> hey guys ! >> >> I¥m trying to use a if syntax to compare data and preselect >> radiobuttons. >> I tried it like that: >> >> if ($checked == "Patch") >> $checked6 = "bla"; >> >> With numbers it works great but with char my $checked6 variable is >> empty ! >> I know php is case sensitive and I¥m sure that problem is not the >> "case >> sensitive" >> so please help, im using a MS SQL Server 2000 (enterprise edition) >> and the >> odbc driver! >> >> thanks guys! >> >> - >> [EMAIL PROTECTED] >> - >> >> > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 don't use the cgi version i compile php with --with-apache :o) > and the connection seem to be exist with netstat > each time i use the web script, it reconnect and open a new tcp > and let the previous open ... > > See you > > Nicolas. > > ----- Original Message - > From: "Andrew Hill" <[EMAIL PROTECTED]> > To: "'Escuder Nicolas'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Thursday, July 25, 2002 7:34 PM > Subject: 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 of Technology Evangelism >> OpenLink Software http://www.openlinksw.com >> Universal Data Access & Virtuoso Universal Server >> >> >> -Original Message- >> From: Escuder Nicolas [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, July 23, 2002 11:09 AM >> To: [EMAIL PROTECTED] >> Subject: [PHP-DB] obdc_pconnect problems >> >> >> Hello, >> >> i use php as not a cgi it is include in my apache >> my odbc is a custom odbc driver >> >> >> so i try to use odbc_pconnect, the first time it connect to the db i >> saw >> the connection tcp by netstat >> and the next time (on the next page) i reuse pconnect with the same db >> user pass and sql cursor but it open >> a new connection, i see two connection with netstat ... and more >> connection if i go another page ... >> >> i don't understand why ... >> >> see you >> >> nicolas. >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 -Original Message- From: Marten Lehmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 4:59 AM To: Nick Gorham Cc: [EMAIL PROTECTED] Subject: [PHP-DB] Re: problem with php and unixODBC Hello, > I know its a little late, but I have only just been pointed to your > posting, I would guess the error you are getting "database not found" is > coming from the sybase driver, not the driver manager. I solved the problem a week ago. It was just when I wanted to try iODBC when I saw some putenv()-lines in the examples. I put the appropriate lines in my php-script and then it worked. What I don't unterstand is: When I'm running isql in the shell I can connect to the remote-ressource. When I start apache in the same shell I can't connect through PHP, I first have to set the ODBCINSTINI and ODBCINI env-variables. Why don't I need them in the shell? Regards Marten -- Variomedia IT-Service GmbH | Benzstrasse 22 | 14482 Potsdam http://www.variomedia.de | Hotline: 0800-5588550 | Fax: 0331-7404043 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
Universal Data Access & Virtuoso Universal Server
-Original Message-
From: Salve Tinkerworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] What MDAC version for MSSQL?
Query Analyzer
Thanks Andrew, I'll give it a try. I have users using the code right
now. It
works for a while then it will bomb. If I make a change to the script
(using
interdev) and re-save it, it miracuously starts working again. Very
strange.
I'm not actually changing anything just re-saving the file.
One other thing funky, which I vehemently complaigned about, is that
this
app uses the .html extension instead of .php for all it's files. From
what
I've read this is not recommended. Do you think that would cause any of
this
strange behaviour?
Salve
"Andrew Hill" <[EMAIL PROTECTED]> wrote in message
news:033e01c234b6$d1f3e730$[EMAIL PROTECTED]...
> Salve,
>
> What is QA?
>
> Also, I strongly suggest you turn on tracing in the ODBC Administrator
> while debugging this - it might catch something.
>
> You can also try installing one of our trial MS SQL Server drivers
> (Single Tier) as this may provide better error messages.
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Virtuoso Universal Server
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Virtuoso Universal Server
> office 781.273.0900 x 27 mobile 781.608.4127
>
> -Original Message-
> From: Salve Tinkerworth [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 25, 2002 9:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] What MDAC version for MSSQL?
>
> Oh yeah, I should mention that anytime I echo the the SQL statement
> before
> it runs and copy it into QA; it parses and runs without any error.
>
>
> "Andrew Hill" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
> > Salve,
> >
> > Not sure if the MDAC version is necessarily the culprit - it's
> probably
> > something else.
> > What do you have earlier in your script? Are you catching errors on
> the
> > connect?
> >
> > Best regards,
> > Andrew Hill
> > OpenLink Software
> >
> >
> > > Is there a recommended MDAC version for PHP when accessing SQL
> Server
> > > 2000? Right now the following statement successfully inserts data
> but
> > > always results with the die message:
> > >
> > > $result = mssql_query($sql1) or die('inserting campaign failed');
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Unified DB Query function
Manual, Certainly - please help us pinpoint any issues. Dan Kalowsky has done some great work in resolving lingering ODBC issues in PHP, and I help in my way with testing and iODBC support. I respect the work you have done with Metabase, but it's a fallacy to suggest that ODBC is "weak" - some 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 -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Unified DB Query function Hello, On 07/25/2002 02:34 PM, Andrew Hill wrote: > Pierre, > > Why not use ODBC functions everywhere? I already told you before. ODBC is very weak API for real database abstraction. To make it worse, PHP ODBC API is buggy and not as complete as it could be. As the maintainer of PHP ODBC support, if you are willing to do anything about it, I can help you to pin point the problems that need to be addressed. Otherwise it is quite pointless to even consider using ODBC in PHP unless it is your really alternative. Regards, Manuel Lemos > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Virtuoso Universal Server > > > -Original Message- > From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 01, 2002 1:01 PM > RE: [PHP-DB] Re: Unified DB Query function, Andrew Hill Re: [PHP-DB] Re: Unified DB Query function, Manuel Lemos RE: [PHP-DB] Re: Unified DB Query function, Andrew Hill [PHP-DB] Pulling the Enum Values from MySQL, Mark Middleton Re: [PHP-DB] Pulling the Enum Values from MySQL, Paul DuBois Re: [PHP-DB] Re: Unified DB Query function, Manuel Lemos <-- Chronological --> <-- Thread --> 02db01c23412$69095470$[EMAIL PROTECTED]"> Reply via email to RE: [PHP-DB] Re: Unified DB Query function, Andrew Hill [PHP-DB] Pulling the Enum Values from MySQL, Mark Middleton Re: [PHP-DB] Pulling the Enum Values from MySQL, Paul DuBois Re: [PHP-DB] Re: Unified DB Query function, Manuel Lemos <-- Chronological --> <-- Thread --> 02db01c23412$69095470$[EMAIL PROTECTED]"> Reply via email to <!-- google_ad_client = "pub-7266757337600734"; google_alternate_ad_url = "http://www.mail-archive.com/blank.png"; google_ad_width = 160; google_ad_height = 600; google_ad_format = "160x600_as"; google_ad_channel = "3243237953"; google_color_border = "CE9689"; google_color_bg = ["FF","ECE5DF"]; google_color_link = "006792"; google_color_url = "006792"; google_color_text = "00"; //--> [PHP-DB] Unified DB Query function Casey Allen Shobe Re: [PHP-DB] Unified DB Query function Casey Allen Shobe Re: [PHP-DB] Unified DB Query function Alexander Re: [PHP-DB] Unified DB Query function Casey Allen Shobe [PHP-DB] Re: Unified DB Query function Manuel Lemos Re: [PHP-DB] Re: Unified DB Query function Pierre-Alain Joye Re: [PHP-DB] Re: Unified DB Query function Manuel Lemos RE: [PHP-DB] Re: Unified DB Query function Andrew Hill Re: [PHP-DB] Re: Unified DB Query function Manuel Lemos RE: [PHP-DB] Re: Unified DB Query function Andrew Hill [PHP-DB] Pulling the Enum Values from MySQL Mark Middleton Re: [PHP-DB] Pulling the Enum Values from MySQL Paul DuBois Re: [PHP-DB] Re: Unified DB Query function Manuel Lemos Re: [PHP-DB] Re: Unified DB Query function Casey Allen Shobe RE: [PHP-DB] Re: Unified DB Query function Cal Evans Re: [PHP-DB] Re: Unified DB Query function Manuel Lemos Reply via email to
[PHP-DB] HOWTO: ODBC-PHP-Apache2
Hello folks, Apologies for the cross-post, but I wanted to announce the publication of a new HOWTO on compiling ODBC support into PHP and Apache with the iODBC Driver Manager: It's available at the www.iodbc.org site in the left hand column. You may view the document directly at: http://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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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- From: Pentothal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PicoSQL! I guess this is the wrong place to ask for a new PHP feature, but ... I don't know where else to ask! I just want to signal to C skilled (and willing) people here that there is a new interesting RDBMS server called picoSQL (www.picosoft.it). Besides beeing really small it's really full-featured and fast. It's available for Linux and NT, it has a windows ODBC driver (and JDBC driver, too), and ODBC 2.5 compliant C/C++ API. It supports transactions, row level locking, BLOBS, sub-queries and more... Well: it needs a PHP module! P.S. Last but not least: it distributed under GPL ! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -Original Message- From: Escuder Nicolas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] obdc_pconnect problems Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Unified DB Query function
Pierre, Why not use ODBC functions everywhere? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -Original Message- From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 1:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Unified DB Query function On Mon, 01 Jul 2002 14:55:01 -0300 Manuel Lemos <[EMAIL PROTECTED]> wrote: > Hello, > > On 07/01/2002 06:46 AM, Casey Allen Shobe wrote: > > I'm trying to write a unified database query function for an application I > > have which currently accesses data from both DB2 and Microsoft SQL from a > > Linux server. I'm using ODBC functions for DB2, and Sybase functions for > > Microsoft SQL. > > Why do you re-invent the wheeel and don't you use a database abstraction > package that handles the database differences of you, like for instance > Metabase: > > http://www.phpclasses.org/metabase Just because diversity rules in our world :). btw, do you have samples codes using the xDefinition methods in metabase ? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: MS Access - default value in create table FYI, I'm sending this stuff through the odbc_exec command. Any MS Access experts out there? Thanks! -Nuttzy "Nuttzy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I can create tables and perform alterations just fine. However, if I try to > specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps out > on me. For example, this works > > ALTER TABLE phpbb_mytable >ALTER COLUMN LastName TEXT(40) > > ...but this doesn't > > ALTER TABLE phpbb_mytable >ALTER COLUMN LastName TEXT(40) DEFAULT Unknown > > ...even though I believe this is the correct syntax. Same thing happens for > CREATE TABLE. Help!!! > > Thanks, > -Nuttzy > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL functions vs. ODBC functions
Mark, ODBC is not inherently slower - it depends if the driver is built as an abstraction to the native layer or if it bypasses the native layer. In addition, a properly written ODBC driver will actually enforce additional functionality on the back-end database, to further isolate you from 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 Universal Data Access & Virtuoso Universal Server -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL functions vs. ODBC functions I am not sure if this question has been asked before, If so sorry for asking again. I have a site that the Client is moving from a MySQL db to Microsoft SQL Server. Is it better to setup an ODBC connection to SQL Server and use the ODBC functions OR to use the MSSQL functions. If I have the choice with is better or are they about the same. Logic would say ODBC is slower because it is another layer on top of the DB, but I don't know. Mark. _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com (888)225-6824 ex. 3262 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] unixODBC
Martin, I did not see your last email, but if you are having problems with unixodbc you may wish to try iODBC - http://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- From: Marten Lehmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] unixODBC Hello, isn't anybody using unixODBC with php out there? I still hope to get help to solve my unixODBC problem as described in my last mail. Regards Marten -- Variomedia IT-Service GmbH | Benzstrasse 22 | 14482 Potsdam http://www.variomedia.de | Hotline: 0800-5588550 | Fax: 0331-7404043 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [php][odbc_connect]
Michel, It means that ODBC support is not enabled in your PHP instance. Check the output of phpinfo(); for ODBC. If this is *nix, you need to link in an ODBC Driver Manager (such as iODBC, see the PHP HOWTO at www.iodbc.org) and install an ODBC Driver. If this is Windows, you need to uncomment 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: Tuesday, June 18, 2002 9:20 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] [php][odbc_connect] Hi everyone, what this message means: Fatal error: Call to undefined function: odbc_connect() in /path/to/file.php thx for helping Regards from Switzerland, Michel Buchmann -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MS Access DB Open as file ?
Hi Ivan, Check out the ODBC chapter in Professional PHP4 (Wrox Press) and also read the PHP HOWTO at www.iodbc.org for an explanation of ODBC in PHP - the short answer to your question "can I connect to Access" is "maybe". A lot of it depends on your platform and available drivers. Best regards, 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 Open as file ? Hi All, I'm new in PHP and I whether I can open a MS Access database file directly with PHP? There is a thing called ODBC but in the function odbc_connect(), The first parameter is something called dsn, what's that? And does that mean I can't open the MS Access database directly by somehow only giving it's path? Thanks. Ivan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 & Virtuoso Universal Server office 781.273.0900 x 27 mobile 781.608.4127 -Original Message- From: Anthony [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 9:04 AM To: Andrew Hill Cc: [EMAIL PROTECTED]; 'Gerardo Morales' Subject: Re: [PHP-DB] Re: Question about ODBC databases That is not entirely what I'm trying to do. What I need is for the NT server that is running ODBC to respond to remote requests from other servers or clients. In other words, I need computer A to access database on computer B which is running ODBC. Computer A does not have ODBC, I need computer a to be able to query against computer B as if it were a SQL server. As far as I can tell, I can't make an NT server running ODBC respond to remote requests. If I am wrong though, PLEASE let me know. Thanks. - Anthony [EMAIL PROTECTED] Andrew Hill wrote: > Anthony, > > You can certainly connect to a remote database using ODBC, it's simply a > case of configuring DSN's on your PHP server to use a local ODBC Driver > to connect to the remote database. In the case of MS Access, OpenLink's > Multi-Tier ODBC Agent works quite well. > > This of course requires that the Linux instance of PHP has been built > with an ODBC Driver manager, such as --with-iodbc as per the HOWTO on > www.iodbc.org. > > Gerardo, your problem might be no ODBC Driver Manager linked in, as well > as no local Driver/DSN. Check the output of a phpinfo(); to see what > the state of your instance 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]] > Sent: Monday, January 21, 2002 8:14 AM > To: [EMAIL PROTECTED]; Gerardo Morales > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Question about ODBC databases > > As far as I know, you can not connect to an ODBC source remotly. If I > could do this (make a NT server running ODBC look like a SQL server), it > > would make the app I'm working on much easier to develop. I have found > a program called ODBCSocketServer, that will send and recieve ODBC > requests via an XML stream. This works ok, but is limited and difucult > to work with. At the current time it it incapable of sending over a > secure port also. If you happen to find a way to make the ODBC server > take remote requests, please let me know (I will from then on refer to > you as god). Hope this helps. > > - Anthony [EMAIL PROTECTED] > > > Gerardo Morales wrote: > > >>I have a little problem. >> >>I must design a little system in a linux server, this should be in >> > php. > >>The system must read a MS Access DB in a remote server (Win NT). >> > After > >>a single process the system must update a MySQL DB in the same server >>(Linux) and the Access DB. >> >>The current code works fine in the Linux server, so i can update the >>MySQL DB, but it doesn't connect with the NT server. >> >>When i tried to connect to it i have the following error. >>Fatal error: Call to undefined function: odbc_connect() in >>/usr/local/etc/httpd/htdocs/vox/loginAccess.inc on line 14 >> >>I never developed with ODBC DB, only with MySQL. >> >>I was searching about what could be the problem, but i don't found it. >> >>The code in liginAccess is the following: >> >>$dbaccess = array(); >>$dbaccess["accessserver"] = "NT.server.ip.address"; // >>Access server hostname >>$dbaccess["accessport"] = ""; // Access server >> > port > >>$dbaccess["accessusername"] = "user"; // username >>$dbaccess["accesspassword"] = "password"; // password >>$dbaccess["defaultdb"] = "database"; // database >> >> > $conexionAccess=odbc_connect($dbaccess["defaultdb"],$dbaccess["accessuse > rname"],$dbaccesss["accesspassword"],""); > >> >>In the code above i tried to inser the remote server address, port >> > etc, > >>and the error codee is the same >> >>I hope you cant help me. >> >>I don't who else can i ask for it. >> >>Thanks in advanced >> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:44 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Question about ODBC databases Gracias Juan. Sobre el mismo tema, aunque a la vez separado, en el caso de que la BD se pusiera en forma local, en que directorio se especifica? es necesario hacer algun cambio en php.ini para especificarle una localidad en especifico?? en el caso de que asi sea, alguien sabra si es posible utilizar MOUNT, NFSD o alguna otra opcion dentro de Linux??? Thanks, Another questions are the following, If I can add the Access DB in a local directory in the Linux server, which location should be (dev/, usr/, etc)?? If I add it in a especific path for example /htdocs/MyDB/Access how can I especified to PHP that read thiis path, Need i modified the php.ini file?? Can I Mount a Network File System on Linux, as I can mount the HD with the DB (win nt OS) to a local Path?? using NFSD, MOUNT or another option?? Thanks In advanced Juan Angel Ringhetti wrote: > Gerardo, > > tuve el mismo problema. Compartir con Samba no te soluciona el problema > porque ODBC no cruza servers sino que trabaja en el mismo server. Encontré > una solucion con un ODBCBridge (www.easysoft.com) pero su licencia no es > gratuita sino que tiene un período de trial. > > Si resolvés el problema avisame. > > Juan > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Question about ODBC databases
Anthony, You can certainly connect to a remote database using ODBC, it's simply a case of configuring DSN's on your PHP server to use a local ODBC Driver to connect to the remote database. In the case of MS Access, OpenLink's Multi-Tier ODBC Agent works quite well. This of course requires that the Linux instance of PHP has been built with an ODBC Driver manager, such as --with-iodbc as per the HOWTO on www.iodbc.org. Gerardo, your problem might be no ODBC Driver Manager linked in, as well as no local Driver/DSN. Check the output of a phpinfo(); to see what the state of your instance 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]] Sent: Monday, January 21, 2002 8:14 AM To: [EMAIL PROTECTED]; Gerardo Morales Cc: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Question about ODBC databases As far as I know, you can not connect to an ODBC source remotly. If I could do this (make a NT server running ODBC look like a SQL server), it would make the app I'm working on much easier to develop. I have found a program called ODBCSocketServer, that will send and recieve ODBC requests via an XML stream. This works ok, but is limited and difucult to work with. At the current time it it incapable of sending over a secure port also. If you happen to find a way to make the ODBC server take remote requests, please let me know (I will from then on refer to you as god). Hope this helps. - Anthony [EMAIL PROTECTED] Gerardo Morales wrote: > I have a little problem. > > I must design a little system in a linux server, this should be in php. > The system must read a MS Access DB in a remote server (Win NT). After > a single process the system must update a MySQL DB in the same server > (Linux) and the Access DB. > > The current code works fine in the Linux server, so i can update the > MySQL DB, but it doesn't connect with the NT server. > > When i tried to connect to it i have the following error. > Fatal error: Call to undefined function: odbc_connect() in > /usr/local/etc/httpd/htdocs/vox/loginAccess.inc on line 14 > > I never developed with ODBC DB, only with MySQL. > > I was searching about what could be the problem, but i don't found it. > > The code in liginAccess is the following: > > $dbaccess = array(); > $dbaccess["accessserver"] = "NT.server.ip.address"; // > Access server hostname > $dbaccess["accessport"] = ""; // Access server port > $dbaccess["accessusername"] = "user"; // username > $dbaccess["accesspassword"] = "password"; // password > $dbaccess["defaultdb"] = "database"; // database > $conexionAccess=odbc_connect($dbaccess["defaultdb"],$dbaccess["accessuse rname"],$dbaccesss["accesspassword"],""); > > > In the code above i tried to inser the remote server address, port etc, > and the error codee is the same > > I hope you cant help me. > > I don't who else can i ask for it. > > Thanks in advanced > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 Infrastructure Technology Provider > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 2:13 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Sybase -> MSSQL Server 2000 > > > PHP.NET indicates that to connect to MSSQL Server, from Linux use Sybase. > I've installed Sybase, PHP and Apache and everything works well > on my Linux > server when I connect to the Sybase test database. > > When I try to connect to my MS SQL server, I get this... > > sybase$ isql -S mssql-server -U username -P password > DB-LIBRARY error: > Unexpected EOF from SQL Server. > > Anyone have any suggestions? > > --Tom Brownridge > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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. > Is there any library or class that could help me to write/maintain just > one source code for both MySQL and PostgreSQL ? > > Thanks. > > ARcadius > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how connect a remote data base MSAccess with PHP in Linux system
Hi Silvia, You first need to link your PHP/Apache install in Linux against an ODBC Driver Manager. You may obtain the iODBC Driver Manager at www.iodbc.org and follow the HOWTO on that site for linking with PHP. Then you will need a Driver - I suggest you download OpenLink's Multi-Tier Driver, and use the ODBC Agent on the Windows box. After you install the MT Driver, with client components on the Linux box and server components on the Win box: 1. create a DSN on the Win box using the MS Driver for Access. for this example let's name it "foo". 2. create a DSN on the Linux box, either in the OpenLink Admin pages (http://servername:8000) or simply by editing the relevant odbc.ini. Configure the DSN as usual, except specify ServerType = ODBC, Hostname = [ip of Win box], and Database = foo. 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 & Virtuoso Universal Server > -Original Message- > From: Silvia Mahiques [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 4:07 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] how connect a remote data base MSAccess with PHP in > Linux system > > > Hi friend! > I have a question... > I have a remote database in Microsoft Access on a WinNT System, > and a Apache and PHP on Linux System. How can I connect this? > > There is one function in PHP for make this: > > odbc_connect(DSN,user,password) > > The question is: what is DSN in my case? How I can to specified > the host and path where is situate the data base? > > DSN (Data Source Name) in local host is the name of the DataBase, > but in remote host, what I need do? > > Thanks in advance. > > > Silvia Mahiques > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 OpenLink Virtuoso Internet Data Integration Server > -Original Message- > From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 9:16 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: ODBC and images > > > Although this article is more geared towards MySQL, the > principles should apply to ODBC, and you should be able to > translate the MySQL functions to ODBC functions rather easily. > > http://www.phpbuilder.com/columns/florian19991014.php3 > > > > > > David Juras wrote: > > > Hi, > > I'm working with PHP and ODBC to get images stored in a > database (Blob fields). But I experiment little problems to > display these pics. Has anyone any information about PHP/ODBC/images ? > > > > Thanks, > > > > Bilbo > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] ODBC -- Setting ApplicationID
Bruce, It looks like you were on the right track initially, the problem is that PHP has a major bug - odbc_setoption is coded specific to ODBC statement handle (connection id), which means that trying to use odbc_setoption the way you want attempts to set a SQLSetConnectOption AFTER the connection is open - which is bogus and will give you ODBC function sequence errors. On the other hand, the error message you were getting is a bit misleading; we are fixing that now. So... you can unfortunately not do this via Application ID, but since you are using the OpenLink Rules Book, you can still affect Session-based connection management with any of the other connection criteria: Here is one way to do it: -- Setup your session attributes by configuring the Session Rules Book Aliases section of the Multi-Tier OpenLink Admin Assistant. (http://servername:8000). You can configure session rules for any combination of Domain, Database, User, Operating System, Client Machine, Client Application, etc., and can control any connection options at the server side based on the session. Using "Database" as an example, add a Database Alias with a new database name and configure a session mapping rule to point to the original database name, but change the connection attributes from "Read / Write" to "Read Only" in the options for the connection session. On the PHP side, simply choose between two DSN's in the odbc.ini - one is the "normal" DSN, with default settings, and one will have an alternate database name, "name_readonly" or somesuch, that will cause the oplrqb to instantiate the appropriate connection attributes. If you run into problems, you should probably open a support case at http://www.openlinksw.com/support/suppindx.htm, as this is getting 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 messing around with the oplrqb.ini file too much. I'd really like to do this based on application. What variable do I pass with the PHP script? ( I'm not sure what you mean ). Can I use a variable in PHP that passes the application name to the server? Thanks, Bruce Andrew Hill wrote: > Hi Bruce, > > The setoption error is being thrown because you cannot use > SQLSetConnectOption that way. > Passing arbitrary info to be used by your application isn't really what this > is for, but instead can be used to modify parameters in the ODBC API. > > This means you can modify things like SQL_ACCESS_MODE, SQL_AUTOCOMMIT, > SQL_ODBC_CURSORS, etc., (check the 2.x spec - there are several metadata > items that you can control with this API call.) > > I'd recommend you just pass a variable to your PHP script, and perhaps > change the username to a read-only/read-write user with a case statement or > somesuch, 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 Server > > > -Original Message- > > From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] > > Sent: Monday, March 25, 2002 10:48 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID > > > > > > Sure, I'm simply trying to have PHP pass an ApplicationID to the > > ODBC server. > > When a PHP 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 pass > > something, so that my mapping rules on the server would allow > > write access to > > the db, if the PHP application sends a certain name. Currently our Win32 > > applications, like MS Access, send application names. e.g. Access, sends: > > application=MSACCESS. > > > > Thanks for your help, > > > > Bruce > > > > Andrew Hill wrote: > > > > > 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
RE: [PHP-DB] ODBC -- Setting ApplicationID
Hi Bruce, The setoption error is being thrown because you cannot use SQLSetConnectOption that way. Passing arbitrary info to be used by your application isn't really what this is for, but instead can be used to modify parameters in the ODBC API. This means you can modify things like SQL_ACCESS_MODE, SQL_AUTOCOMMIT, SQL_ODBC_CURSORS, etc., (check the 2.x spec - there are several metadata items that you can control with this API call.) I'd recommend you just pass a variable to your PHP script, and perhaps change the username to a read-only/read-write user with a case statement or somesuch, 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 Server > -Original Message- > From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 10:48 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID > > > Sure, I'm simply trying to have PHP pass an ApplicationID to the > ODBC server. > When a PHP 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 pass > something, so that my mapping rules on the server would allow > write access to > the db, if the PHP application sends a certain name. Currently our Win32 > applications, like MS Access, send application names. e.g. Access, sends: > application=MSACCESS. > > Thanks for your help, > > Bruce > > Andrew Hill wrote: > > > 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 > > > > 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 > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] ODBC -- Setting ApplicationID > > > > > > > > > I am trying to set the ApplicationID, when connecting to an ODBC > > > datasource. I have tried: > > > > > > odbc_setoption ($conn, 1, 1053, "PHPAPP"); > > > > > > And get a: > > > > > > "SQL error: [iODBC][Driver Manager]Option type out of range, SQL state > > > S1092 in SetConnectOption" > > > > > > Basically, I want my PHP script to pass the application name > to the ODBC > > > server, so that I can set up a mapping on the server that allows write > > > access when a certain application string is sent. > > > > > > PHP 4.06 (with file-upload patch) > > > Openlink ODBC 1.5 > > > Linux Client > > > SCO Informix 5 server > > > > > > > > > TIA- > > > > > > Bruce > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] ODBC -- Setting ApplicationID
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 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 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] ODBC -- Setting ApplicationID > > > I am trying to set the ApplicationID, when connecting to an ODBC > datasource. I have tried: > > odbc_setoption ($conn, 1, 1053, "PHPAPP"); > > And get a: > > "SQL error: [iODBC][Driver Manager]Option type out of range, SQL state > S1092 in SetConnectOption" > > Basically, I want my PHP script to pass the application name to the ODBC > server, so that I can set up a mapping on the server that allows write > access when a certain application string is sent. > > PHP 4.06 (with file-upload patch) > Openlink ODBC 1.5 > Linux Client > SCO Informix 5 server > > > TIA- > > Bruce > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL2000
Mike, You can certainly use ODBC. The drivers are already present on your system; just configure a System DSN. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -Original Message- > From: Mike [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 11:12 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MSSQL2000 > > > Anybody able to get this working under a > > Windows2000 advanced server, IIS, PHP 4.1.1, MSSQL2000 SP2 all on one box > > I am beginning to believe it is not possible using any > php_mssql.dll that i > have ever found. correct me if anybody can. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 OpenLink Virtuoso Internet Data Integration Server > -Original Message- > From: Steve Farmer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 03, 2002 7:16 PM > To: Jason Lehman; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? > Sorry > > > Hi Jason, > > You need the Oracle client installed and working > > rgds > Steve > At 11:39 AM -0500 1/3/02, Jason Lehman wrote: > >This may be a stupid question but I am stuck. Do I have to have > the Oracle > >Linux Client to connet to a remote Oracle Database or can I just have the > >php --with-oci8 turned on and that be it? And I can't seem to find any > >how-tos on just installing the client and I am not sure what > prerequisites I > >need on my computer to install just the client. Any help would be > >appreciated. Thanks. > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > -- > - > "Minds are like parachutes, they work best when open" > Support free speech; visit http://www.efa.org.au/ > > Heads Together Systems Pty Ltd http://www.hts.com.au > Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [OpenLink][ODBC][Driver]No key columns found for table referenced by keyset driven cursor
Paulo, This error is caused because odbc_connect is setting a dynamic cursor by default. This is usually not a problem, but a cursor needs a primary key. If no primary key exists on your table or if you are selecting against a view there will be a problem. I suggest you try adding a primary key. Alternatively a workaround exists to prevent odbc_connect from automatically selecting a dynamic cursor when connecting - edit php_odbc.h and comment out: #define HAVE_SQL_EXTENDED_FETCH 1 and recompile your php/apache setup. If you run into additional problems you may wish to open a support 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: Wednesday, February 20, 2002 11:09 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] [OpenLink][ODBC][Driver]No key columns found for table > referenced by keyset driven cursor > > > Hi, > I'm running True64 UNIX with ingres 6.4 and openlink ODBC. > > > When i connect thru cgi(C/C++) it works fine but when i connect via PHP > 4.1.1 gives me this error: > [OpenLink][ODBC][Driver]No key columns found for table referenced > by keyset > driven cursor., SQL state IM909 in SQLPrepare > > > I compiled php like this: > > ./configure' '--with-odbc=/usr/soft/openlink/odbcsdk' > '--with-apache=../apache_1.3.22' '--enable-track-vars' > > I didn´t install iodbc because it's has a problem with snprintf > > Cal anyone help me with this? > > > P Freitas > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] starting odbc for w2k and iis
Eduardo, Under Windows, you can simple configure a System DSN in the ODBC Administrator, and then use the ODBC functions in PHP: www.php.net/odbc, as ODBC support should be enabled by default. You can also connect to SQL Server on Windows from a *nix platform, using the PHP-ODBC-HOWTO at www.iodbc.org as a starting place. You might want to read it for an ODBC architecture overview even if using Windows - just skip the installation steps. As far as the examples go, they are also transferable (that's the point of ODBC) but you will not need to set any environment variables with a Windows-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:31 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] starting odbc for w2k and iis > > > Hello everybody, i'm new to the list, and i want to know where i > get started > with and odbc connection to sql server 2k > > any tutorial or manual, would be appreciated > > Thanks in advance. > -- > Eduardo Cancino > [EMAIL PROTECTED] > --- > Coordinador de Desarrollo Web > CENTRO DE INFORMACION Y COMUNICACION AMBIENTAL DE NORTEAMERICA A.C. > --- > www.ciceana.org.mx > --- > 56 59 05 09 > Av. Progreso #3, Col. del Carmen, Viveros de Coyoacan, 04010, Mexico D.F. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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: Penockio [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 12:51 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Error insert into MS-access through ODBC not aviable
>
>
> I can't use sql command "insert into " but I can use "select" and it
> condition.I use DSN that provide by ODBC and use MS-Access as source file.
>
> my code :
>
> $connect = odbc_connect("sosdb","","") or die ("can not connect")
> ; ->successfult
>
> $order_trans_detail_sql = "insert into order_trans_detail
> (order_id,cus_id,order_place) values
> ('0212027','0071577722451188','548/12 123 Road Patumwan') ; " ;
>
> $exec = odbc_exec($connect,$order_trans_detail_sql ) or die
> ("cannot insert
> order trans detail") ; -> warning as below
>
> all field is text field for database MS-Access .and I connect it through
> ODBC by ms access driver use (DSN)
>
> I found
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation
> must use an updateable query., SQL state S1000 in
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Database Connection
Jerry, I believe it's the sqllib dir, but you can try the other or experiment with just /home/db2inst1/sqllib If created by the DB2 client installer, try applying the environment variables script: . /home/db2inst1/sqllib/db2profile Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Jerry [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 11:36 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Database Connection > > > Thanks Andrew for your answer. > > In the environment variables I have already: > > DB2INSTANCE=db2inst1 > LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib > > Is it correct ? Or does it need to point to the DB2 Client directory > /usr/IBMdb2/V7.1/lib > > > Thanks. > > Jerry > > > "Andrew Hill" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Jerry, > > > Installing DB2 Client will allow you to use the ODBC functions > in PHP, but > > be aware that you are not actually using any ODBC Drivers in this > instance. > > PHP allows hiding of certain database specific functions under > a "Unified > > ODBC" that uses the ODBC functions without using true ODBC database > communication. > > > That being said, you don't need to link --with-iODBC unless you > are using > > ODBC Drivers, so it's not an issue here. > > > If Apache doesn't start, I'd check it's logs, but you might be > encountering > > a situation where the DB2 libraries were in the path at compile time and > are > > not at Apache start time. Try setting LD_LIBRARY_PATH environment > variable > > to include the location of your DB2 Client. > > > Andrew Hill > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > . > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Database Connection
Jerry, Installing DB2 Client will allow you to use the ODBC functions in PHP, but be aware that you are not actually using any ODBC Drivers in this instance. PHP allows hiding of certain database specific functions under a "Unified ODBC" that uses the ODBC functions without using true ODBC database communication. That being said, you don't need to link --with-iODBC unless you are using ODBC Drivers, so it's not an issue here. If Apache doesn't start, I'd check it's logs, but you might be encountering a situation where the DB2 libraries were in the path at compile time and are not at Apache 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 > -Original Message- > From: Jerry [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 10:46 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Database Connection > > > Hi, > > I have IBM DB2 V7.2 on a windows 2000 server > I have IBM DB2 Client/Administration Client Development Client V7.2 on a > Linux Web Server > >From the Linux server (Command Line) I can connect to the DB2 database > directly. > > I would like to connect to the DB2 Database through PHP4/Apache > > After compiling PHP with the option > "--with-ibm-db2=/home/db2inst1", Apache > doesn't start anymore. > > Do I need to install iODBC (or another ODBC) or is it included ? > > Any idea what can cause this problem and how to solve it ? > > Thanks > > Jerry > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] odbc functions
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]] > Sent: Monday, February 04, 2002 10:36 AM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > Subject: [PHP-DB] odbc functions > > > Does anyone have experience of using odbc_primarykeys??? > > I'm writing a script to let me port a database from Access to > MySQL without > having to write all the table definitions by hand. But I can't get > odbc_primarykeys to work - it comes back with: > > Warning: SQL error: , SQL state 0 in SQLPrimaryKeys > > I don't really know what the modifier and owner parameters should do, and > suspect thats where the problem lies. I tried them as "", "%" and " ". > > Running PHP 4.0.4 on NT 4.0 Workstation, with Access 97 > > Richy. > > > == > Richard Black > Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com > Tel: 0141 435 3504 > Email: [EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] ODBC
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 Oracle, for instance. On Linux and other *nix flavors, connecting to databases with ODBC using PHP requires that PHP be compiled with an ODBC Driver Manager, and that ODBC Drivers be installed. A HOWTO is available at www.iodbc.org as well as an Open Source Driver Manager and free commercial driver 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 Universal Data Access & Data Integration Technology Providers office:781.273.0900 x 27 mobile:781.608.4217 > -Original Message- > From: Morten Nielsen [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 02, 2002 11:45 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] ODBC > > > Hi, > > Could anybody explain to me what ODBC is. Should I install it when I use > mySQL? > > Thanks, > Morten > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] same connection to access two different database?
Vincent, If you need to use just one connection against multiple databases, you should check out Virtuoso. Among other features it can act as a "virtual database", where you link multiple heterogenous database tables through it and then can treat them as one transparent schema from a single ODBC connection. The databases you link can be on different platforms as well. You can combine remote data with data in Virtuoso's own tables, and do some interesting things like create XML documents on the fly from any combination of your relational data. http://www.openlinksw.com/virtuoso/whatis.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: Vincent Ma [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 8:46 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] same connection to access two different database? > > > Hi everyone: > > is it possible to use one connect to access two database in postgreq, > because i would like to use subquery to do same search. on the fly in > postgreq must faster a lot than evaluate in php code... > > A, B belong to different database... > sql : select * from A in ( select * B) > > Vincent Ma > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] odbc_columns()
Scott, odbc_columns can take a lot of arguments, but the only one you need to pass is a connection id. It'll return a result identifier containing lots of info on your field names: $conn_id = odbc_connect($dsn, $usr, $pwd) or die (odbc_error()); $result_id = odbc_columns($conn_id) or die (odbc_error()); odbc_result_all($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: Scott Teglasi [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 9:01 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] odbc_columns() > > > Hi. Have a question: > > I've tried using the odbc_columns() function to get a list of > columns in an > access database connected via an ODBC System DSN.. However, I haven't had > much luck in trying to use it. The manual page doesn't really cover much > about it, and I noticed a few comments posted there (on www.php.net) > mentioning that it was a pretty badly documented function. > > In any case, there were notes on how to use it with MS SQL 7, but none on > just plain access databases. > > All I want to get is a list of field names in a table. What would the > proper syntax be to do that? > > Any help would be appreciated. > > Thanks, > > Scotty > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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: Thomas Spellman [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 21, 2002 2:26 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] iODBC module for PHP on linux > > > Hi, > > I'd like to use iODBC in mod_php (Apache DSO) on linux to access an > Access database running on a Windows box elsewhere. I'm using an RPM of > mod_php. Is it possible to compile the iODBC support as a PHP module > without having to recompile mod_php? If so, how? Does iODBC have to be > compiled with support for php? > > Thanks for any help, > > Thomas > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: matt stewart [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 16, 2002 9:42 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] How can recommend a book for SQL and DB design > > > finished University nearly two years ago, but back then, this book was the > one we used too - very in depth introduction to general database theory, > well worth investing in if you need very well designed databases for large > volume applications. > all the best, > Matt > > -Original Message- > From: Leotta, Natalie (NCI/IMS) [mailto:[EMAIL PROTECTED]] > Sent: 16 January 2002 14:17 > To: 'DL Neil'; 'Andy'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] How can recommend a book for SQL and DB design > > > I'm a recent student but I sold back my DB text in hopes I'd never have to > know the stuff again (I guess that $20 wasn't worth it). The current book > my old prof is using is: > > Introduction to Database Systems, 7th Edition by C.J. Date. > > but since I don't know if that's the one I used I don't know if it's any > good. I do know that the class covered the normalizations and things like > that. It might be a good place to start, but it seems like college > textbooks are always at least twice the cost of normal books. > > I haven't tried the PHP O'Reilly book, so thanks for the warning! > > -Natalie > > > -Original Message- > > From: DL Neil [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, January 15, 2002 5:34 PM > > To: Leotta, Natalie (NCI/IMS); 'Andy'; [EMAIL PROTECTED] > > Subject:Re: [PHP-DB] How can recommend a book for SQL and DB design > > > > Andy (and Natalie), > > > > In fact the O'Reilly book on PHP is the exception that might well prove > > the rule - normally I think them v.good > > > > The reference work on MySQL is by Paul DuBois (who often stops by here - > > "hi Paul") and published by New Riders. > > > > Unfortunately none of my favorite texts (of the moment) go into the > > background of db theory, eg normalisation. > > Perhaps one of the (recent) students on the list can help with > that one... > > > > Regards, > > =dn > > > > > > - Original Message - > > From: "Leotta, Natalie (NCI/IMS)" <[EMAIL PROTECTED]> > > To: "'Andy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: 15 January 2002 22:14 > > Subject: RE: [PHP-DB] How can recommend a book for SQL and DB design > > > > > > > Any O'Reilly book is always a good choice. O'Reilly is the > publisher - > > they > > > do the "Nutshell" books and a bunch of others. They are also > the books > > with > > > animals on them, if that helps :-) > > > > > > -Natalie > > > > > > > -Original Message- > > > > From: Andy [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, January 15, 2002 5:11 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: [PHP-DB] How can recommend a book for SQL and DB design > > > > > > > > Hi, > > > > > > > > I am searching for a good book on how to design a db for web apps. > > > > Normalisation rools, performancejust describing how to > do it on a > > > > proffesional way. > > > > > > > > The second one, I am searching for is a book about SQL for > MySQL. Any > > good > > > > books on the market? > > > > > > > > Thanx for the recommendation > > > > > > > > Andy > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > To contact the list administrators, e-mail: > > [EMAIL PROTECTED] > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] &
RE: [PHP-DB] FreeBSD 4.2 and ODBC
Paul,
Sure, email away.
I'd hazard a guess that your syntax errors were due to not matching the
threading of your OS.
And I recommend the OpenLink Multi-Tier ODBC drivers, from your architecture
needs.
They are available for a free download 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
> -Original Message-
> From: Paul G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 6:08 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] FreeBSD 4.2 and ODBC
>
>
> Thanks Andrew,
>
> I will attempt this in the morning. Is it okay with you if I email you on
> the iODBC stuff? PHP was compiled like so:
>
> Configure command: ./configure
> '--with-apxs=/usr/local/apache/1.3/bin/apxs'
> '--with-config-file-path=/usr/local/lib' '--with-system-regex'
> '--enable-track-vars' '--enable-trans-sid' '--enable-versioning'
> '--with-ttf' '--with-ftp' '--with-gd=/usr/local' '--enable-memory-limit'
> '--enable-fast-install' 'with-iodbc=/usr/local/src/odbcsdk'
> php3.ini file path is set to: /usr/local/lib
>
> (iODBC resulted in syntax errors last time I tried. I am new to this I
> should emphasize!) Also, any ODBC driver you would recommend?
>
> -Paul
>
> - Original Message -
> From: "Andrew Hill" <[EMAIL PROTECTED]>
> To: "Paul G" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, January 15, 2002 2:37 PM
> Subject: RE: [PHP-DB] FreeBSD 4.2 and ODBC
>
>
> > Paul,
> >
> > You can simply download the binary at www.iodbc.org and
> > configure --with-iodbc as per the HOWTO.
> > If you tried this and then got "undefined function" then this means you
> > didn't use the correct php binary or somesuch.
> > Ensure that ODBC support is compiled in by examining the output of a
> > phpinfo();
> >
> > You will still need an ODBC driver, as iODBC is simple the
> Driver Manager
> > (enabling use of a driver).
> > To enable BSD to access an Excel spreadsheet will require the following
> > configuration.
> >
> > BSD Client
> >
> > PHP --with-iodbc (using iODBC SDK, use non-threaded option if you get
> > pthread errors)
> > Client-side ODBC - OpenLink MT Client
> > DSN (in odbc.ini) configured with:
> > Host = windows box below
> > ServerType = odbc
> > Database = server-side DSN below ("foo")
> > Environment variables in your PHP script:
> > putenv("ODBCINI=path/to/odbc.ini");
> > putenv("LD_LIBRARY_PATH=path/to/odbcsdk/lib");
> > (ODBCINSTINI is optional)
> >
> >
> > Windows Server
> >
> ------
> --
> > ---
> > Server-side ODBC: OpenLink MT "ODBC Agent" (choose Access in
> the selection
> > 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,
> > 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 5:29 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-DB] FreeBSD 4.2 and ODBC
> > >
> > >
> > > Hi All,
> > >
> > > I'm just new to this list and I'm hoping somebody might have
> > > information leading to a PHP that can access an MS Excel
> > > Spreadsheet. FreeBSD 4.2, PHP 3.0.18 (for gif GD), Apache1.3.12.
> > >
> > > I have had no luck getting any of the ODBC functions to work with
> > > this OS (odbc_connect, php compiled with and without --with-iodbc
> > > switch results in "Fatal error: Call to unsupported or undefined
> > > function odbc_connect() "). I also had no luck compiling iODBC,
> > > which resulted in syntax errors and ultimately stoppage.
> > >
> > > Wondering if anybody has a gem out there. |:) Ever pull something
> > > like this off? Got any ideas?
> > >
> > > Thanks Alot!
> > >
> > > -Paul
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] FreeBSD 4.2 and ODBC
Paul,
You can simply download the binary at www.iodbc.org and
configure --with-iodbc as per the HOWTO.
If you tried this and then got "undefined function" then this means you
didn't use the correct php binary or somesuch.
Ensure that ODBC support is compiled in by examining the output of a
phpinfo();
You will still need an ODBC driver, as iODBC is simple the Driver Manager
(enabling use of a driver).
To enable BSD to access an Excel spreadsheet will require the following
configuration.
BSD Client
PHP --with-iodbc (using iODBC SDK, use non-threaded option if you get
pthread errors)
Client-side ODBC - OpenLink MT Client
DSN (in odbc.ini) configured with:
Host = windows box below
ServerType = odbc
Database = server-side DSN below ("foo")
Environment variables in your PHP script:
putenv("ODBCINI=path/to/odbc.ini");
putenv("LD_LIBRARY_PATH=path/to/odbcsdk/lib");
(ODBCINSTINI is optional)
Windows Server
---
Server-side ODBC: OpenLink MT "ODBC Agent" (choose Access in the selection
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,
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 5:29 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] FreeBSD 4.2 and ODBC
>
>
> Hi All,
>
> I'm just new to this list and I'm hoping somebody might have
> information leading to a PHP that can access an MS Excel
> Spreadsheet. FreeBSD 4.2, PHP 3.0.18 (for gif GD), Apache1.3.12.
>
> I have had no luck getting any of the ODBC functions to work with
> this OS (odbc_connect, php compiled with and without --with-iodbc
> switch results in "Fatal error: Call to unsupported or undefined
> function odbc_connect() "). I also had no luck compiling iODBC,
> which resulted in syntax errors and ultimately stoppage.
>
> Wondering if anybody has a gem out there. |:) Ever pull something
> like this off? Got any ideas?
>
> Thanks Alot!
>
> -Paul
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Moving from MySQL to MSSQL Server 2000
Hi, You can indeed use ODBC, and that will get around some issues that FreeTDS has with SQLServer 2000. Some ODBC drivers are slow, but you will find OpenLink's drivers to be exceptionally fast. To use ODBC, you will need to link PHP against iODBC as per the howto at www.iodbc.org The drivers 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: Gabriel Ricard [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 10:59 AM > To: Boaz Yahav > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Moving from MySQL to MSSQL Server 2000 > > > Sorry for the late reply to this, but if you were to move to MS SQL I'd > highly recommend using FreeTDS (www.freetds.org) to access the database > from PHP. Due to the lack of an MS SQL client library in Mac OS X I have > to use FreeTDS to contact another MS SQL server ( I use MySQL myself ). > Setup was very easy, you just build FreeTDS and then configure PHP using > --with-sybase-ct=/path/to/freetds. Then you can use the mssql_* group of > functions to access the database. > > Or you could use ODBC... but I was never able to get that to work > correctly, and the general consensus seems to be that ODBC is slow. > > On Saturday, January 12, 2002, at 03:24 PM, Boaz Yahav wrote: > > > Hi > > > > I'm planning to move my site (Very successful / high traffic Auctions > > site) from MySQL to MSSQL Server 2000. > > I was wondering if anyone has done this move and if there are any pit > > falls to notice. > > > > 1. Is ODBC the only way to work from a Solaris / Apache / PHP 4 machine > > to a Win2K / SQL Server 2000? > > 2. What could be the performance cost (if any). > > 3. Are there any special points that need to be taken into consideration > > on either side? > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 & Data Integration Technology Providers
> -Original Message-
> From: Berthelot [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 07, 2002 11:57 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] odbc and access
>
>
> I want to connect to an access database via a dsn.
> Here is the code:
>
> $db_link = odbc_connect("tatoo", "", "");
> ?>
> And I got the following error:
> Warning: SQL error: [Microsoft][Gestionnaire de pilotes ODBC] Source de
> données introuvable et nom de pilote non spécifié, SQL state IM002 in
> SQLConnect in C:\Inetpub\wwwroot\php\first.php on line 11
>
> I know it's written in french... sorry: that mean that the driver manager
> can't find the data source but my dsn is correct.
> Anyone can help me ?
> thanx.
> sam
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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: Javalina [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 04, 2002 10:42 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP4 + ODBC Openlink +ORACLE 8.1 on DIGITAL
>
>
> Hi to all...i have a problem when i try to connect from php to the
> oracle 8.1 on a DIGITAL ALPHA MAchine..
>
> i did use openlink , when i try the connection with the SQL aplication
> test of the OPENLINK driver , function OK...the debug of this query
> is.
>
> oplrqb: 192.168.99.106 called (192.168.99.106.1201)
> oplrqb: request: domain=Oracle 8.1.x database= serveropts=
> oplrqb: connectopts= user=system opsys=unix readonly=0
> oplrqb: application=www_sv processid=10770
> oplrqb: solve mapping: ora81::insecure:other:192.168.99.106:www_sv:rw
> oplrqb: using mapping: ora81:*:*:*:*:*:*
> oplrqb: using [generic_ora81] ServerProgram=ora81_mv
> oplrqb: connect params: domain=Oracle 8.1.x db= serveropts= readonly=0
> oplrqb: connectopts= user=system opsys=unix machine=192.168.99.106
> application=www_sv
> oplrqb: spawning /usr/local/openlink/bin/ora81_mv generic_ora81 +debug
> oplrqb: asking agent for server handle
> oplrqb: setting Environment ORACLE81
> oplrqb: change environment 'ORACLE_HOME' -> '/usr/OraHome1'
> oplrqb: change environment 'ORACLE_SID' -> 'Base3'
> oplrqb: change environment 'SHOW_REMARKS' -> 'N'
> oplrqb: change environment 'CURSOR_SENSITIVITY' -> 'LOW'
> oplrqb: change environment 'LD_LIBRARY_PATH' -> '/usr/OraHome1/lib'
> oplrqb: change environment 'LIBPATH' -> '/usr/OraHome1/lib'
> oplrqb: change environment 'SHLIB_PATH' -> '/usr/OraHome1/lib'
> generic_ora81: server starting
> oplrqb: got it!
> oplrqb: asking agent for connection handle
> oplrqb: got it!
> oplrqb: accepted [EMAIL PROTECTED]
> oplrqb: unmap [EMAIL PROTECTED]
> oplrqb: killing generic_ora81 agent (pid=4627)
> generic_ora81: got SIGTERM
> generic_ora81: server shutting down
> oplrqb: pid 4627 died with exit code 0
> oplrqb: agent died (pid=4627)
> oplrqb: removing agent generic_ora81 with 0 connections
>
> the debug of the PHP4 query ,is
> oplrqb: 192.168.99.106 called (192.168.99.106.1199)
> oplrqb: request: domain=Oracle 8.1.x database= serveropts=
> oplrqb: connectopts= user=system opsys=unix readonly=0
> oplrqb: application= processid=10751
> oplrqb: solve mapping: ora81::insecure:other:192.168.99.106::rw
> oplrqb: using mapping: ora81:*:*:*:*:*:*
> oplrqb: using [generic_ora81] ServerProgram=ora81_mv
> oplrqb: connect params: domain=Oracle 8.1.x db= serveropts= readonly=0
> oplrqb: connectopts= user=system opsys=unix machine=192.168.99.106
> application=
> oplrqb: spawning /usr/local/openlink/bin/ora81_mv generic_ora81 +debug
> oplrqb: asking agent for server handle
> oplrqb: setting Environment ORACLE81
> oplrqb: change environment 'ORACLE_HOME' -> '/usr/OraHome1'
> oplrqb: change environment 'ORACLE_SID' -> 'Base3'
> oplrqb: change environment 'SHOW_REMARKS' -> 'N'
> oplrqb: change environment 'CURSOR_SENSITIVITY' -> 'LOW'
> oplrqb: change environment 'LD_LIBRARY_PATH' -> '/usr/OraHome1/lib'
> oplrqb: change environment 'LIBPATH' -> '/usr/OraHome1/lib'
> oplrqb: change environment 'SHLIB_PATH' -> '/usr/OraHome1/lib'
> generic_ora81: server starting
> oplrqb: got it!
> oplrqb: asking agent for connection handle
> oplrqb: got it!
> oplrqb: accepted [EMAIL PROTECTED]
> oplrqb: aborted [EMAIL PROTECTED]
> generic_ora81: got SIGTERM
> generic_ora81: server shutting down
> oplrqb: pid 4616 died with exit code 0
> oplrqb: agent died (pid=4616)
> oplrqb: removing agent generic_ora81 with 0 connections
>
> if you saww the only diference is when i try to connect with PHP don't
> send the www_sv option with the IP of request...
>
> the output of the PHP page is
> Warning: SQL error: [iODBC][Driver Manager]Connection in use, SQL
> state 08002 in SQLConnect in /usr/local/apache/htdocs/prueba_odbc.php
> on line 16
>
> the line the is when i try to connect with this code.
>
> /* some environment variables, you can test to comment them out to see
> if things
> * still work.
> */
> putenv("LD_LIBRARY_PATH=/usr/local/openlink/lib:/usr/app
RE: [PHP-DB] odbc date
George,
Yes, using the date() example.
Cheers,
Andrew
> -Original Message-
> From: George Nicolae [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 31, 2001 1:26 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] odbc date
>
>
> it is right but I want to select all data from a mdbdatabase table and I
> receive in '/mm/dd hh:mm:ss' format.
> I told you I resolve this problem with date("F j,
> Y",strtotime(odbc_result($cur,"date"))).
> I what to know if I can receive a specific format from query "select 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
> [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_date = { d '2002-01-01'}
> > This will allow you to select from a table regardless of the
> date format.
> >
> > For converting a date from one format to another, select it from a 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
> > 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
> > > 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 format it with odbc date syntax in your query { d
> > > '-MM-DD' }
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > >
> > >
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] odbc date
George,
The ODBC date syntax is best used for to make input format unambiguous,
e.g.:
select * from orders where order_date = { d '2002-01-01'}
This will allow you to select from a table regardless of the date format.
For converting a date from one format to another, select it from a 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
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
> 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 format it with odbc date syntax in your query { d
> '-MM-DD' }
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: George Nicolae [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 30, 2001 5:37 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] odbc date
>
>
> for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field,
> php will automatically convert it to '/mm/dd hh:mm:ss' format
> regardless
> of the style of date you've denoted in Access
>
> how can I resolve this problem and print in a different format?
> --
>
>
> Best regards,
> George Nicolae
> IT Manager
> ___
> X-Playin - Professional Web Design
> www.x-playin.f2s.com
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] php and accessconnection
Ruprect, Simply use ODBC. http://www.php.net/odbc If PHP is on Windows, simply create an ODBC System DSN. If your PHP environment is some *nix, you can compile PHP --with-iodbc as per the HOWTO at www.iodbc.org and setup a DSN in your odbc.ini file. Free trial ODBC Drivers are available 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 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of [EMAIL PROTECTED] > Sent: Thursday, December 27, 2001 2:50 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] php and accessconnection > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > is it possible to connect to a access-db via php? > How to connect to an access-database whis is on another host? > > Regards, > Ruprecht > > - -- > E-Mail: [EMAIL PROTECTED] > Date: 27-Dec-2001 > Time: 20:46:48 > > This message was sent by XFMail > - -- > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: Weitere Infos: siehe http://www.gnupg.org > > iD8DBQE8K3tVEK4asBW3N7wRAmUdAKC5ppigbNNWn1nwa9W6iQlKxNiQUQCgwplc > XntZAOt3Y0KnN7m6G0YDcyk= > =u2mB > -END PGP SIGNATURE- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Integration Technology Providers
> -Original Message-
> From: Javalina [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 21, 2001 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC MS SQL Server 7
>
>
> Hi to all...please can you help me ...because i cant retrieve any row
> of the database on MS SQL Server 7 with ODBC . i did use Openlink
> driver on a Solaris 6 machine (Sparc) , the database are on WIN NT4.0
>
> my code is.
>
> /* some environment variables, you can test to comment them out to see
> if things
> * still work.
> */
> putenv("LD_LIBRARY_PATH=/base/odbc/lib:$LD_LIBRARY_PATH");
> putenv("UDBCINI=/base/odbc/bin/udbc.ini");
> putenv("ODBCINI=/base/odbc/bin/odbc.ini");
> putenv("DebugFile=/tmp/udbc.out");// debug trace output
>
> $dsn="NT";// note 'DSN=' is required
> $user="shark";
> $password="shark";
>
> $sql="select * from frases ";
>
> $connect_odbc=odbc_connect($dsn,"shark","shark",SQL_CUR_USE_ODBC) or
> die("Erreur
> de connexion au serveur");
> if (!odbc_autocommit($connect_odbc, TRUE)) {
> echo 'pb auto_commit';
> return;
> }
> // selection avant
> $Req_hebd = "select * from frases ";
> echo $Req_hebd .'';
>
> if (!($Res_hebd=odbc_prepare($connect_odbc,$Req_hebd))) {
> echo 'pb prepare';
> }
> if (!odbc_execute($Res_hebd)) {
> echo 'pb execute';
> }
> if (!($res=odbc_result_all($Res_hebd))) {
> echo 'pb result_all';
> }
>
> ?>
> this code reply "NO ROWS FOUND" , the connection are OK...the databse
> have many rows(of course)..
>
> Thank's a lot.
>
> Cristian
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC with MS Access DB
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 PROTECTED]]
> Sent: Thursday, December 13, 2001 4:21 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC with MS Access DB
>
>
> I am writing a simple application that will store data in an
> Access database.
> I have gotten a simple script that connects and selects some data from the
> database and this works fine. when I try to insert or update data
> it fails. I
> assume I am missing some permissions or something to make it be
> readonly when I connect but the following is the relevant code in case it
> lies there:
>
> $db=odbc_connect('test', 'test', 'test')
> $query="INSERT INTO test (firstname) VALUES('Charles')";
> $result=odbc_exec( $db, $query);
>
> As you can see it is about as simple as I can make it for a test so if
> someone could point me in the right direction to get this up and running I
> would greatly appreciate it.
>
> Thanks in advance,
> Charles
>
> --
> Charles F. McKnight IRC: sokudo | Doubt is not a pleasant
> condition, but
> [EMAIL PROTECTED] ICQ: 2794793 | certainty is absurd.
> [EMAIL PROTECTED] PGP: 0x20A5BCE5 |
> - Voltaire
> [ http://chucksays.mywebsitesucks.com
> ]-
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC .. ehm .. help :)
If you followed the howto and you are still receiving an "undefined
function" error, than you might have more than one apache/php instance, and
you are starting the wrong one :)
What was the configure command you used? Did you use a --prefix? If so,
that is the one you need to start.
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
> -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 steps described at www.iodbc.org. Still no
> result :(
>
> ------
> Original Message
> From: "Andrew Hill"<[EMAIL PROTECTED]>
> Subject: RE: [PHP-DB] ODBC .. ehm .. help :)
> Date: Thu, 13 Dec 2001 09:32:25 -0500
>
> >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 Integration Technology Providers
> >
> >> -Original Message-
> >> From: b i k k e l [mailto:[EMAIL PROTECTED]]
> >> Sent: Thursday, December 13, 2001 4:35 AM
> >> To: [EMAIL PROTECTED]
> >> Subject: [PHP-DB] ODBC .. ehm .. help :)
> >>
> >>
> >> Hi,
> >>
> >> i get the following error with the code listed below: "Fatal
> >> error: Call to
> >> undefined function: odbc_connect() in
> >> /home/users/sites/www.nlhq.nl/html/connect.php3 on line 2"
> >>
> >> >> $db = odbc_connect('server4.1a.nl', '', '', SQL_CUR_USE_ODBC);
> >> ?>
> >>
> >> This is the URL of the PHP script: http://www.nlhq.nl/connect.php3
> >>
> >> Tought it might my usefull to give ya all the info i can get .. so ..
> >> http://www.nlhq.nl/info.php
> >>
> >> Hope some1 can help me out here ..
> >> Thanx!
> >>
> >>
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> >>
> >>
> >>
> >
> >
> >
>
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Integration Technology Providers
> -Original Message-
> From: b i k k e l [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 13, 2001 4:35 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC .. ehm .. help :)
>
>
> Hi,
>
> i get the following error with the code listed below: "Fatal
> error: Call to
> undefined function: odbc_connect() in
> /home/users/sites/www.nlhq.nl/html/connect.php3 on line 2"
>
>$db = odbc_connect('server4.1a.nl', '', '', SQL_CUR_USE_ODBC);
> ?>
>
> This is the URL of the PHP script: http://www.nlhq.nl/connect.php3
>
> Tought it might my usefull to give ya all the info i can get .. so ..
> http://www.nlhq.nl/info.php
>
> Hope some1 can help me out here ..
> Thanx!
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Providers > -Original Message- > From: B. PERRINE [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 27, 2001 2:20 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Oracle, PHP4, BSD > > > le jeu 08-11-2001 à 23:52, D. Witten a écrit : > > These are pretty basic questions, but I would appreciate help: > > > > I need to access Oracle (already running on a separate server) > via PHP4 from > > a FreeBSD Server. > > > > 1) Can this be done? > > (if so...) > I don't think so. But if the BSD can run linux prog, then you may try to > install oracle (client part) on your server via the oracle java > installer : OUI. It come with oracle. > > 2) Where do I find instructions? > technet.oracle.com product : 8i, some howto exists. > > 3) Where do I get php_oci8 > with php > > 4) Do I HAVE to install code from Oracle (the Oracle client, etc) on my > > server? > > (if so,,,) > see 1) > > 5) Where do I get that client software? > > > > Thanks > > > > Dave Witten > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: What software do I need in order to access Oracle database on an NT server from my unix machine?
You may also accomplish this via ODBC - download and link against iODBC per the HOWTO at www.iodbc.org. For free trial drivers, I suggest the Multi-Tier ODBC Drivers from www.openlinksw.com If you run into problems, 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 > -Original Message- > From: Philippe Saladin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 27, 2001 11:19 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: What software do I need in order to access Oracle > database on an NT server from my unix machine? > > > AFAIK, you need to install the oracle 8 client for linux onto > your machine. > Unfortunately, it can't be downloaded alone. you need the entire "Oracle 8 > database release for Linux", available at www.oracle.com > > Hope I'm not wrong. Please correct me there's an error > Regards, > Philippe > > "Lallous" <[EMAIL PROTECTED]> a écrit dans le message news: > [EMAIL PROTECTED] > > Hello. > > > > I have a unix box which doesn't have anything related to Oracle > installed > on > > it. > > > > Now I have another remote machine: NT w/ Oracle Server 8. > > > > What software/Libraries do i need to install on my linux box in order to > > access Oracle database on that NT machine? > > > > Thanks. > > > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] problems in connecting Access database
Mihail, > >$conn = odbc_connect( 'test' , ' ', ' ' ); > > > >where test is the name of that database, then the output is smth. like > > > >Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not > >found and no default driver specified, SQL state IM002 in SQLConnect in > >c:\inetpub\wwwroot\test.php on line 11 Miles is correct with regards to using a System DSN. Other things that can cause that error include mispelling the DSN name, etc. but you don't appear to be using a DSN yet. Create one 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 Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 19, 2001 3:11 PM > To: John Lim; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and MS SQL 2000 Performance > > > Am Mon, 19 Nov 2001 schrieb John Lim: > > Are you using ODBC? We recently had similar problems, and it > turned out that > > we > > had SQL tracing enabled, and every single ODBC function call was being > > written > > to SQL.LOG > > And added, such a traced logfile can grow up to some megabyte of data. > > I know that from an other db-connectiontool. Has someone made > expearance with > using php-connections to a ms-sqlserver from a linux-box > (odbc-connections from > linux)? > > Regards, > Ruprecht > > -- > For germans > > > Vielleicht zufällig ein Projekt zu vergeben und nun auf der Suche > nach einem Freelancer? > Dann doch gleichmal vorbeischauen unter > http://www.gulp.de/profil/rhelms.html > > -- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] MSSQL 2000 and PHP on Linux..
Marcelo, You can use the sybase or free tds libraries, per the configuration options, e.g. --with-option. Check the install docs for the libraries you will need (e.g. ct-lib, tds). Another option is ODBC. Here you can link --with-iodbc using the SDK from www.iodbc.org, and drivers from 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 > -Original Message- > From: Marcelo [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 19, 2001 3:33 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MSSQL 2000 and PHP on Linux.. > > > Hello, > From the PHP site I read that I may use the Sybase libraries to > connect to > a MS SQL server using PHP. > Then reading over the Sybase documentation I got lost. > > Do I have to install/configure Sybase in order to compile PHP with sybase > support? > Or are there some basic libraries that I can install just to compile PHP? > > Or is there an alternative on how to connect to a MsSQL 2000 from Linux? > > Thanks > Marcelo > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Chris Andrew [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 15, 2001 10:43 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP/MySQL to M$ Access > > > Hi, > > Until we completely migrate an application from M$ Access to PHP/MySQL, I > need to figure out a way to temporarily query an Access DB from PHP/MySQL. > > I am aware of this article on PHP Builder: > http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 > which discusses using ODBC Socket Servers, but the article assumes the M$ > Access db is on a winblows machine. In my case, the Access DB is > on a Linux > machine (served thru' Samba - isn't Linux great... :-) > > Anyways - could someone offer me some advice - all I need is some some > simple SELECT queries on the Access tables. > > Many Thanks, > Chris > > > Email: [EMAIL PROTECTED] > Web: www.oxspring.com > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Access with PHP on Linux?
Steve, To clarify, you cannot run Access on Linux. You can install ODBC support for PHP on Linux, and use ODBC drivers to talk to an Access db on Windows. ODBC support for PHP under Linux requires linking PHP with an ODBC Driver Manager. iODBC (www.iodbc.org) is your best bet, 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 http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Steve Farmer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 10:32 PM > To: Andreas D. Landmark; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Access with PHP on Linux? > > > Hi Andreas, > > At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: > >At 13.11.2001 23:23, Chris Payne wrote: > >>Hi there everyone, > > [snip] > > >> > >>I want to keep it an access DB if possible as i've had problems > >>changing the DB to MySQL. > > > >Install ODBC, that would let you interface with degenerate > database formats > >as access et al. > > When you say install ODBC, I assume you mean on the Linux box. Could > you give me a pointer as to the best way to achieve this ? > > [snip > > > > > >-- > >Andreas D Landmark / noXtension > > Regards > Steve > -- > - > "Minds are like parachutes, they work best when open" > Support free speech; visit http://www.efa.org.au/ > > Heads Together Systems Pty Ltd http://www.hts.com.au > Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Hace [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 7:04 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MSSQL Error with MSSQL 2000 > > > When we run an insert query in MS SQL Server we get the following > error "Unicode data in a Unicode-only collation or ntext data cannot > be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 > or earlier." > > On the following website we found this had to do something with the > NTEXT-type. > http://www.bmc.com/products/distdata/sqlprogfaq.html#error_odbc > > Now how should we store a memo-field on MSSQL using php_mssql dll? > > > > > -- > http://hace.dyndns.org/ > Everything I say is my own opinion and not necessarily that of > my employer. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Windows, MSSQL varchar>255 caracters?
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 Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Jacob Anderson [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 12, 2001 9:38 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Windows, MSSQL varchar>255 caracters? > > > The VARCHAR(255) "bug" is actually a limitation imposed by ODBC - so I > suspect the MSSQL library uses ODBC for communication with a SQLServer > installation. I've experienced the same problem using Java JDBC and some > older SQL Server drivers. Recent type-4 MS SQL Server drivers > for JDBC have > fixed the problem, so no doubt subsequent ODBC implementations > will contain > the fix, such as that found in Windows XP. > > -- Jake > [EMAIL PROTECTED] > > > -Original Message- > > From: Ryan Marrs [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 12, 2001 5:15 AM > > To: 'Michael Schmidt'; '[EMAIL PROTECTED]' > > Subject: RE: [PHP-DB] Windows, MSSQL varchar>255 caracters? > > > > > > I fixed this issue by using a text field instead of a varchar > field. For > > some reason, it didn't want to read anything over 255 > characters, although > > the data was still stored. Maybe it's a bug, or maybe just a > limitation. > > > > Ryan > > > > > > -Original Message- > > From: Michael Schmidt [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 12, 2001 8:12 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Windows, MSSQL varchar>255 caracters? > > > > Hi All. > > > > With the Microsoft SQL Server it is possible to make a table with > > fields of > > the type varchar which can have more then 255 characters width. > > > > When use a query to get the content, i only get the first 255 > > characters all > > others are cut off. (i connect to the DB via the mssql_... commands). > > > > Anyone has a idea how to solve the problem? > > > > Michael > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Oracle, PHP4, BSD
Dave, 1. Yes 2. Compile --with-oci, as per the manual, and set all the appropriate ORACLE environment variables before doing so. 3. oci should be available from Oracle's site. 4. Yes, unless you want to use ODBC, and then you would install --with-iodbc per the HOWTO's on www.iodbc.org. 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, November 09, 2001 12:52 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Oracle, PHP4, BSD > > > These are pretty basic questions, but I would appreciate help: > > I need to access Oracle (already running on a separate server) > via PHP4 from > a FreeBSD Server. > > 1) Can this be done? > (if so...) > 2) Where do I find instructions? > 3) Where do I get php_oci8 > 4) Do I HAVE to install code from Oracle (the Oracle client, etc) on my > server? > (if so,,,) > 5) Where do I get that client software? > > Thanks > > Dave > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP and Informix under Linux
Domonique, To use ODBC from Linux under PHP, you will need to link PHP with a Driver Manager. iODBC is a free, Open Source Driver Manager available at www.iodbc.org. Your configure will have to include --with-iodbc=/path/to/odbcsdk More information is available in the PHP HOWTOs at www.iodbc.org. You may use any ODBC driver with iODBC.I don't know if the driver you mention has Informix support, but if you are looking for a comparative driver I'm sure you will be pleased with OpenLink's Multi-Tier ODBC Driver. It supports Informix and can be downloaded for free with 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 Providers > -Original Message- > From: Dominique Dubied [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 31, 2001 10:18 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP and Informix under Linux > > > HI. > > I have PHP4, Linux Red Hat 7.1, Inofrmix Dynamic Server 7.31 UD1 > and Apache. > > I would like to communicate with Informix from PHP via an ODBC driver. I > have the Merant 3.7, but I am not sure that it supports the version of > Informoix mentionned above. > Do you know if I can use this driver ? > If not, do you know another one ? > If not, how can I communicate with Informix under Linux using PHP ? > > Thanks for your help!! > Domonique Dubied > Switzerland > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Anthony [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 1:21 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] help connecting to ODBC > > > yes, I can use the source from other programs. The source is a System > DSN, based on a file DSN for the driver. The I_USR_ user > has the correct access rights to the files being accessed and to the > file DSN driver. > > > Andrew Hill wrote: > > > 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 Access & Data Integration Technology Providers > > > > > >>-Original Message- > >>From: Anthony [mailto:[EMAIL PROTECTED]] > >>Sent: Friday, October 19, 2001 1:01 PM > >>To: [EMAIL PROTECTED] > >>Subject: [PHP-DB] help connecting to ODBC > >> > >> > >>I can't connect to an ODBC data source. I have done this before many > >>times. I am now trying to connect to a new driver for new data. This > >>is the first time I have tried to access a file DSN. I have the driver > >>setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to > >>connect to the data source I get "SQL error: , SQL state S1000 in > >>SQLConnect". What does this mean? does anyone know where I can get a > >>list of SQL errors and their meaning? Thanks to anyone that can lend > >>their thoughts. > >> > >>- Anthony > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >>To contact the list administrators, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >> > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Access & Data Integration Technology Providers > -Original Message- > From: Anthony [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 1:01 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] help connecting to ODBC > > > I can't connect to an ODBC data source. I have done this before many > times. I am now trying to connect to a new driver for new data. This > is the first time I have tried to access a file DSN. I have the driver > setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to > connect to the data source I get "SQL error: , SQL state S1000 in > SQLConnect". What does this mean? does anyone know where I can get a > list of SQL errors and their meaning? Thanks to anyone that can lend > their thoughts. > > - Anthony > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Access & Data Integration Technology Providers > -Original Message- > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 6:27 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > Andrew, > > you mean to activate the ODBC-Tracing of the OperatingSystem? When I > activate this, nothing is being logged. > > OS is WIN2000 Prof. > Database: ACCESS 2000 > Diver: normal MS ODBC-Driver of WIN2000 > > Michael > > > > "Andrew Hill" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 > > Universal Data Access & Data Integration Technology Providers > > office:781.273.0900 x 27 mobile:781.608.4217 > > > > > -Original Message- > > > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, October 18, 2001 1:53 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > > > > > > > Hi all, > > > > > > sorry, there was a mistake: > > > > > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, > fldCaptDuty, > > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > > fld_F_Flown > > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > > =#".$EngDatum."#"; > > > > > > should read > > > > > > FROM tblBookings WHERE fldFlight = ? AND fldBookDate > =#".$EngDatum."#"; > > > ^^ > > > there should the parameter be used. > > > > > > Michael Eisner > > > > > > > > > "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > Hi all, > > > > i'm really new in php (working on my first project9 and i got the > > > following > > > > situation: > > > > > > > > i have a loop going through a result set of an odbc-query. > each row of > > > this > > > > loop has to be checked if there is an entry in another table. so as > the > > > last > > > > odbc-query is the same for each row except they key-field, i > > > tried to use > > > > the odbc_prepare function and a parameter array. but it > doesn't work. > > > > I got no errormessages. > > > > > > > > this is how it looks like - and doesn't work: > > > > ** > > > > ... > > > > ... > > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, > fldCaptDuty, > > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > > fld_F_Flown > > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > > =#".$EngDatum."#"; > > > > > > > > $ergDispatch=odbc_prepare($conDispatch,$sql); > > > > > > > > While (odbc_fetch_into($ergRouten, &$datRouten)) > > > > ... > > > > ... > > > > $Para = array($datRouten[0]); > > > > odbc_execute($ergDispatch,$Para); > > > > ... > > > > ... > > > > * > > > > The array is filled correctly, but the odbc_execute > function doesNn't > > > bring > > > > back any value, but there are definitvly rows where there > should be a > > > > result. > > > > > > > > Thanks in advance! > > > > > > > > Michael J. Eisner > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: Newbie: odbc_prepare & parameters
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 Universal Data Access & Data Integration Technology Providers office:781.273.0900 x 27 mobile:781.608.4217 > -Original Message- > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 1:53 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > Hi all, > > sorry, there was a mistake: > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > fld_F_Flown > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > =#".$EngDatum."#"; > > should read > > FROM tblBookings WHERE fldFlight = ? AND fldBookDate =#".$EngDatum."#"; > ^^ > there should the parameter be used. > > Michael Eisner > > > "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi all, > > i'm really new in php (working on my first project9 and i got the > following > > situation: > > > > i have a loop going through a result set of an odbc-query. each row of > this > > loop has to be checked if there is an entry in another table. so as the > last > > odbc-query is the same for each row except they key-field, i > tried to use > > the odbc_prepare function and a parameter array. but it doesn't work. > > I got no errormessages. > > > > this is how it looks like - and doesn't work: > > ** > > ... > > ... > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > fld_F_Flown > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > =#".$EngDatum."#"; > > > > $ergDispatch=odbc_prepare($conDispatch,$sql); > > > > While (odbc_fetch_into($ergRouten, &$datRouten)) > > ... > > ... > > $Para = array($datRouten[0]); > > odbc_execute($ergDispatch,$Para); > > ... > > ... > > * > > The array is filled correctly, but the odbc_execute function doesNn't > bring > > back any value, but there are definitvly rows where there should be a > > result. > > > > Thanks in advance! > > > > Michael J. Eisner > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: m0sh3 [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 12:01 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] updating records in ODBC with cursor > > > is there a way to update records with cursor thru ODBC? > > thanx > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Other ODBC driver besides an openlink one?
Hi Ricky, I wasn't able to find any open support cases for you. If you've had any problems with OpenLink drivers I'd like to know what they are so they can be resolved asap. Our drivers work quite well with Oracle, although there can be problems if database version is not 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 Integration Technology Providers > -Original Message- > From: Ricky Theil [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 4:33 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Other ODBC driver besides an openlink one? > > > We have had nothing but problems with our openlink drivers > connecting to an > oracle database from our bug tracking software, so I'm not allowed to use > openlink odbc drivers. Is there another way to set up an odbc > connection to > a linux system using php and odbc??? I know I can do native > connections, but > I'm having a few problems installing oracle on Linux. > > Thanks > > Ricky > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:32 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [PHP-DB] connecting SQL 7.0
>
>
> Here is the full script:
>
> $a=odbc_connect("mydsn","myid","mypwd") or die("Database is down");
> echo "$a";
> $b=odbc_exec($a,"select * from mytable");
> echo odbc_error ();
>
> FYI, if I execute only the first 2 lines, there is no problem,
> meaning that
> the server is accesssible ($a is "Resource id #1").
>
> When the whole script is executed with Internet Explorer, a
> windows pops up
> and says: "The connection with the server was reset".
>
> When executed with Opera, the window says: "Repeated attemps
> failed to load
> this page completely. Them may be a problem on the server".
>
> the echo odbc_error() does not help.
>
>
> The Apache server, and php pages are on my PC (localhost) connected to a
> LAN, and the SQL Server is on a NT server on the LAN. The dsn odbc driver
> is on my PC.
>
>
> What's wrong here and what should I change?
>
> Thanks to all for your inputs.
>
>
> -Original Message-
> From: Andrew Hill [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:05 PM
> To: LeTortorec, Jean-Louis; [EMAIL PROTECTED]
> Subject: 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-
> > From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 02, 2001 2:10 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: [PHP-DB] connecting SQL 7.0
> >
> >
> > $a=odbc_connect("mydsn","myid","mypwd") or die("Database is down");
> > echo "$a";
> >
> >
> > When I execute this script, I got $a being "Resource id #1". but $a
> > should be an integer in order to do a query like
> > $b=odbc_exec($a,"select * from mytable");
> >
> >
> > the dsn I created is a system DSN, as suggested my a member of the
> > mailing list. I run PHP4.0 and Apache 1.3 under W2000.
> >
> > Any suggestion?
> >
> > Thanks.
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:10 PM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] connecting SQL 7.0
>
>
> $a=odbc_connect("mydsn","myid","mypwd") or die("Database is down");
> echo "$a";
>
>
> When I execute this script, I got $a being "Resource id #1".
> but $a should be an integer in order to do a query like
> $b=odbc_exec($a,"select * from mytable");
>
>
> the dsn I created is a system DSN, as suggested my a member of the mailing
> list.
> I run PHP4.0 and Apache 1.3 under W2000.
>
> Any suggestion?
>
> Thanks.
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] DB2 Performance issue
Okay, one relevant issue is that PHP sets default cursor type to Dynamic. While this is a nice, potentially bidirectional and sensitive-to-change cursor it can be very expensive, some ODBC drivers don't support it (OpenLink's do) and Dynamic cursors typically dont work with tables 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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Mark Newnham [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 5:33 PM > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] DB2 Performance issue > > > This was posted on the newsgroup a couple of months ago: > > > Christian Szardenings wrote: > > > > Hi Andrew, > > > > thanks a lot for your help. Today we discovered what > > our real problem was: > > > > After "playing" a little bit with the php-scripts that try > > to connect to the IBM DB2, we set the optional parameter > > Cursortype when calling odbc_pconnect(). > > > > And the exciting thing: When we set the cursor type > > to SQL_CUR_USE_ODBC Cursor Type, then > > the whole query speed up from 1 till 10 seconds > > to 0.2 till 0.3 seconds for 100 records. Amazing!!! > > > > Therfore, PHP is just almost fast as calling the DB2 > > from Servlets using JDBC (don't take too much care > > about the speed at whole: the database was on a > > completely other location, so the whole connection > > was made over a slow network connection). > > > > I hope this helps when other encounter the same > > problem when trying to connect to DB2 from > > PHP. > > > > Kind regards, > > Christian Szardenings > > This posting has caused some discussion amongst some of us who > are trying to > use DB2 in Native mode (i.e. using Unified ODBC) as the IBM driver manager > appears not to support this parameter. ( An odbc connect with the > specified > parameter returns [IBM][CLI Driver] CLI0150E Driver not capable. > SQLSTATE=S1C00 > > Could the author or anyone else who knows, please clarify this posting if > they are using unified odbc or perhaps a third party ODBC driver. > > > TIA > > Mark > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Driver for connecting SQL server
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 PROTECTED]]
> Sent: Monday, October 01, 2001 2:44 PM
> To: LeTortorec, Jean-Louis
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [PHP-DB] Driver for connecting SQL server
>
>
>
> Hi
>
> Try to remobe 'DNS=' from the connect
>
> $conn=odbc_connect("dnsname","userid","password");
>
> should do the trick.
>
> - Frank
>
> > Hi:
> >
> > I'm trying to establish a connection with SQL 7.0.
> >
> > My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS
> > Access) and checked that the connection can be established.
> >
> > Then, my php script is as follow:
> > $conn=odbc_connect("DNS=dnsname","userid","password");
> >
> > When I execute the script, I get the following error message:
> >
> > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data
> source name not
> > found and no default driver specified, SQL state IM002 in SQLConnect in
> > c:\apache\intranet\default.php on line 6.
> >
> > How can I specify the missing driver? Should I install something?
> >
> >
> > Thanks for your help.
> >
> > JL
> >
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: DJGray [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 3:13 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP and MS Access > > > I apologize if this is a redundant post. I did do a search and could not > find the answer. > > I'm swimming in ignorance as I build a website for a friend. The hosting > service says they support MS Access and PHP. However, they are telling me > that in order for PHP to get to that database, I would also need MySQL, > which they do not have and have no plans to install. > > Is this accrate? > > Can PHP not get to the Access database directly? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP vs. 2 database softwares
Scott, I didn't know that you couldn't use multiple database protocols at once, and this does surprise me to. ODBC is a way around this problem, however, abstracting the protocol for you. Cheers, Andrew > -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:39 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP vs. 2 database softwares > > > Do you meant to say that it took me several days to figure out that PHP > doesn't support multiple databases? PHP said it will work with almost 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]... > > 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 & Data Integration Technology Providers > > > > > -Original Message- > > > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, October 01, 2001 12:11 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] PHP vs. 2 database softwares > > > > > > > > > Hi! > > > > > > I found that PHP can be compiled and work with only one database > > > software. You won't be able to have PHP to work with 2 seperate > database > > > softwares. (You can compile it but it will work only with one databse > > > software, not both, no matter what). I checked the php "./configure" > file > > > and found that it is not design to include 2 seperate > databases when you > > > want it to. > > > > > > Man, it would be very nice to have PHP to work with multiple > database > > > softwares. The only way you can have PHP to work with more than > > > 1 database > > > softwares, then you would need to compile PHP & Apache to > work with one > > > database. Then re-configure and re-compile PHP & Apache to a seperate > > > directory. That way, you will have 2 apaches and run them > > > together. There > > > is no other way! > > > > > > Thanks, > > > Scott > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP vs. 2 database softwares
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 & Data Integration Technology Providers > -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:11 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP vs. 2 database softwares > > > Hi! > > I found that PHP can be compiled and work with only one database > software. You won't be able to have PHP to work with 2 seperate database > softwares. (You can compile it but it will work only with one databse > software, not both, no matter what). I checked the php "./configure" file > and found that it is not design to include 2 seperate databases when you > want it to. > > Man, it would be very nice to have PHP to work with multiple database > softwares. The only way you can have PHP to work with more than > 1 database > softwares, then you would need to compile PHP & Apache to work with one > database. Then re-configure and re-compile PHP & Apache to a seperate > directory. That way, you will have 2 apaches and run them > together. There > is no other way! > > Thanks, > Scott > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mssql functions on unix
Ricky, Compile --with-sybase will give you an older TDS support, and allow you to use the sybase_functions with MS SQLServer 6 and 7. If you need to connect PHP on Unix to MS SQLServer 2000 you will want to use ODBC. Howto's are available on preparing PHP with ODBC at www.iodbc.org. 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: Ricky Theil [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 26, 2001 12:25 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] mssql functions on unix > > > Where do these functions come from on a unix box? I've never had > to connect > to a mssql DB from a unix machine, but have run into the point > where I must. > I have plenty of scripts on a windows machine connecting to a > mssql DB, but > I don't see a configure option to include the mssql functions > when compiling > php. > > Any help is appreciated :) > > Thanks, > > Ricky > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Universal Data Access & Data Integration Technology Providers > -Original Message- > From: hausii [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 3:52 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] php and mssql 8 > > > is it possible to establish a connaction with php 4.0.4 to mssql > server vers > 8 ??? > > i've tried it serveral times but php alway crashes with the > php_mssql70.dll > extension - and the modul php_mssql from the 4.0.6 release > doesn't work with > php 4.04 > > is it there an other extension out there > > thanx > cu > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] db's war
You might want to also check out Virtuoso http://www.openlinksw.com/virtuoso/ It's as scalable ast the 'cadillacs' and has expected features like triggers, foreign keys, and stored procedure support, and is considerably cheaper. It also has advanced XML, SOAP, and WebDAV features - 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, September 18, 2001 4:22 PM > To: Paul Gardiner > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] db's war > > > IMHO, having run all three, I summarize them like this... > > MySQL, Postgres > Fast, open source, free. Good for projects, small-medium sized > businesses, > and playing around. > > DB2 > Good, solid database. Their UI needs work (it's 100% > java-based) and it's > significantly more complex (and pricier) than the OpenSource ones. > However, > it IS slower. It can handle MUCH larger datasets. It can be run in a > clustered > environment. It has the robustness for large business, but can > be handled > by a > medium sized one. > > Oracle > Often referred to as the "Cadillac of Databases," this thing's a beast. > Expect to not > only pay through the nose for it, but also for help/contractors/DBAs to > set it up, > tune it, maintain it, and handle the problems. It -can- be setup by > smaller firms, but > definately do your homework here. Go with someone who's been doing it a > while > and is in the enterprise space you want to be in. It's also got a HUGE > set of > applications and modules that can run on top of the raw database (no one > else really > has this from a single vendor) but that's a whole new can of > worms, costs, > problems, > etc. > > My personal favorite is DB2. The key to DB2, though, is not the common > sense things > like "do the training classes" and "get a book." The key is in their UI > stuff. Ditch it. > Learn the command lines, the scripting tools, and the database > connectivity > stuff. Sure, > you can do simple things with their UI, but it's going to > restrict you in a > lot of ways. > DB2 is big enough for "real enterprise work" but small enough not > to get out > of hand. > > However, DB2 is almost the cost of Oracle (purchasing) but your recurring > costs are > considerably cheaper. Oracle does have the advantage of being "first" and > so the > knowledge base/finding people who know a bit about Oracle is easier, and > they DO have > all of the applications modules which DB2 currently does not have. (Rumors > are that they're > looking at expanding into that realm a little more, but I don't know > anything for sure.) > > If you need a consolodated system for the whole company, well, Oracle wins > that hands down. > If you just need a super fast lightweight database, OpenSource. > For everything else, DB2. > > And if you need a kick-arse track-anything-anywhere-anyhow system, look at > Camstar Systems, > which will handle backends of both DB2 and Oracle. It's better than the > Oracle MES/tracking modules. > > -Szii > > - Original Message - > From: "Paul Gardiner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; "Sommai Fongnamthip" > <[EMAIL PROTECTED]> > Sent: Tuesday, September 18, 2001 3:16 AM > Subject: Re: [PHP-DB] db's war > > > > Hi, > > > > I'm also very interested in other peoples thoughts and > reactions to this. > > We've been hit twofold, we run on SCO which Caldera has now > taken over and > > also use Informix which IBM have acquired, whom I'm sure will > try to make > us > > move to DB2 at some point. > > > > The other trouble we have is a lot of our programs are written > in Informix > > 4GL and so will be a pain to convert. I would have liked to of had a DB > > independent 4GL but this was already in place before I got > here. The only > > real other choice like you say is Oracle but I've always heard > bad things > > regarding pricing where they are concerned. They had a special offer on > for > > anyone who jumped over two them quickly but I like to 'look before you > leap' > > :) > > > > We plan to start looking at possible alternative's before we're > forced to > > change and so would be glad to hear from anyone else who is in the same > b
RE: [PHP-DB] NEED HELP WITH ORACLE & PHP PLZ.
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 have The following
>
> A Sun Ultra2 Running the Oracle Client talking to a Oracle
> Instance 8.1.7 on
> another server.
>
> sqlplus scott@rhinodb works greate. I do have to be in $ORACLE_HOME for
> some reason.
>
> When I issue the following command I get an error
>
>
>
>
>
> Untitled
>
>
>
> $link = ora_logon("scott@RHINODB", "tiger")
> or die ("Could not connect");
> print ("YAA Connected successfully");
> ?>
>
>
>
>
>
>
> Error in the Browser
>
> Warning: Oracle: Connection Failed: Error while trying to
> retrieve text for
> error ORA-12154 in
> /export/dsk2/apache/htdocs/rhinodb/cgi-bin/dbtest.php on
> line 8
> YAA Connected successfully
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Daniel Bennett [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 11:47 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: Problem with odbc_next_result
>
>
> Michael - could seem to reply to your email address... here's the code
>
> where $res is a valid result_id (I've tested it without the
> odbc_next_result):
>
> do {
> while ($odbc_get_into($res,$row)) {
> print "$row[0]";
> }
> } while ($odbc_next_result($res));
>
> Seems to crash on the first call to odbc_get_into after odbc_next_result
>
>
>
> "Daniel Bennett" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi,
> >
> > Anyone had problems with odbc_next_result on WinNT?
> >
> > I can call the function, but as soon as I try to get a row from the next
> > result set, php crashes.
> >
> > Any ideas?
> >
> > Daniel Bennett
> > [EMAIL PROTECTED]
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Victor Espina [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 11, 2001 11:55 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC connection under Win32 + Apache + SQL Server
>
>
> Hi, i'm new using PHP i'm trying to run some basic PHP scripts to
> retrieve a
> show data coming from a SQL Server database. The problem is that
> when i try
> to run this:
>
> $conn=odbc_connect("MQIS","sa","");
>
> PHP returns the following warning:
>
> Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified
>
> I test the DSN with VFP using:
>
> SQLStringConnect("dsn=MQIS;usr=sa;pwd=;")
>
> and it works pretty fine. ¿What could be the problem here?
>
> TIA
>
> Victor
>
> --
> ==
> Victor Espina
> Caracas, Venezuela
> http://mitrompo.com/vespina
> [EMAIL PROTECTED]
> (Quite el 'nospam' para responder)
> (Remove 'nospam' to reply)
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 8:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC connection problem
>
>
> Windows NT 4.0 workstation
> Apache
> PHP 4
>
> I'm using ODBC to connect to dbase tables.
> the following code works fine and returns the correct results...
>
> $connect = odbc_connect("partner","","");
>
> $query = "SELECT company FROM listing";
>
> $result = odbc_exec($connect, $query);
>
> while(odbc_fetch_row($result)){
> print odbc_result($result, "company") . "";
> }
>
> odbc_close($connect);
> ?>
> ---
>
> but if someone else is accessing the table (not exclusively) i
> get the error
> message.
> --
> Warning: SQL error: [Microsoft][ODBC dBase Driver] The Microsoft Jet
> database engine cannot open the file 'N:\listing.DBF'. It is
> already opened
> exclusively by another user, or you need permission to view its data., SQL
> state S1000 in SQLExecDirect in c:\Program Files\Apache
> Group\Apache\htdocs/test.php on line 6
> --
>
> Is there a work around for this or a fix?
> I need to give internet access for this older internal database
> at the same
> time local users are accessing it.
>
> thanks in advance
>
> don
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Oracle connectivity from Linux
You can use OCI directly - or if you want to still use ODBC, you can piggyback ODBC on the client (Linux) ontop of OCI. That maintains portability for the future and give you some things like better cursor handling and security. Let me know if you want assistance in setting up a 'piggyback' 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 > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Oracle connectivity from Linux > > > > Do you know of any other Oracle connection method that does not > require server side components? > Thanks, > Danny N. > > Andrew Hill <[EMAIL PROTECTED]> wrote: Danny, > > OpenLink's current Oracle driver from Unix requires a server-side > component. > > Best regards, > Andrew > > > > > > - > Do You Yahoo!? > Get email alerts & NEW webcam video instant messaging with Yahoo! > Messenger. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Oracle connectivity from Linux
Danny, OpenLink's current Oracle driver from Unix requires a server-side component. Best regards, Andrew > -Original Message- > From: Danny Nguyen [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 2:01 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] 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 appropriate ODBC drivers are certainly a production-quality > solution. > If you like, you may download our Multi-Tier drivers for testing free from > our site. > They come with a non-expiring 2-user license and we will provide free > support if you run into problems. > > 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 1:04 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Oracle connectivity from Linux > > > > > > > > Hi guys, > > > > I am currently looking into a reliable connectivity for Linux to > > Oracle on NT 4.0. Coding would be in PHP 4. I have read somewhat > > about iODBC, how does it performs under production use? Which > > connection methods do you prefer or recommend. > > > > Thanks in advance, > > > > Danny N. > > > > > > > > - > > Do You Yahoo!? > > Get email alerts & NEW webcam video instant messaging with Yahoo! > > Messenger. > > > > - > Do You Yahoo!? > Get email alerts & NEW webcam video instant messaging with Yahoo! > Messenger. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Oracle connectivity from Linux
Danny, iODBC and appropriate ODBC drivers are certainly a production-quality solution. If you like, you may download our Multi-Tier drivers for testing free from our site. They come with a non-expiring 2-user license and we will provide free support if you run into problems. 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 1:04 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Oracle connectivity from Linux > > > > Hi guys, > > I am currently looking into a reliable connectivity for Linux to > Oracle on NT 4.0. Coding would be in PHP 4. I have read somewhat > about iODBC, how does it performs under production use? Which > connection methods do you prefer or recommend. > > Thanks in advance, > > Danny N. > > > > - > Do You Yahoo!? > Get email alerts & NEW webcam video instant messaging with Yahoo! > Messenger. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC and SQL Server
Todd, Download and install the Lite (Single Tier) driver from our site (Product Availability link) to your Win box. Configure and test a DSN in the ODBC Administrator (The Test button shows up in the Create New Datasource dialog - be sure to hit "Apply" before the Test button, or it will not find the DSN you created :). Try the same PHP code. The trial Lite will expire in 30 days. Multi-Tier is more powerful, faster, and has a free 2-user connection, but for purposes of testing Lite will be easier to configure for proof-of-concept. Free support is available for any of our products 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:[EMAIL 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. 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 Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC and SQL Server
Todd, I don't believe so. Try passing in user and pass variables into your odbc_connect - I'm not sure that is happening. I've about reached my usefulness with regards to debugging a driver connection in someone else's ODBC drivers. At the risk of a plug, I can certainly 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 & Data 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 - > > 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 additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Todd Cary [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 05, 2001 2:49 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC and SQL Server
>
>
> I am trying to setup an ODBC connect to SQL Server. My DSN is
> "Acct32_ODBC". I am using NT Authentication, so that could be my
> problem.
>
> odbc_connect("Acct32_ODBC", "", "");
>
> Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user
> 'PENTIUM3\IUSR_PENTIUM3'., SQL state 28000 in SQLConnect in
> C:\Webroot\testodbc.php on line 33
>
> Any suggestions on how I can resolve this?
>
> Many thanks.
>
> Todd
> --
> Todd Cary
> Ariste Software
> [EMAIL PROTECTED]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and ms Access > > > I think that by using ODBC you can connect to the MS Access server. > > > Andrey Hristov > IcyGEN Corporation > http://www.icygen.com > BALANCED SOLUTIONS > > > - Original Message - > From: "user" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 31, 2001 4:33 PM > Subject: [PHP-DB] PHP and ms Access > > > > Hello, > > > > I am builing a microsoft access database. > > > > Now wants the compagny I created it for me to use it to make dynamic > > webpages. The problem is that I am new at this. > > > > Can somebody please explain the basics of integrating a MS > Access databse > > with php into a webpage? > > > > I thank you in advance, > > > > TheB'Oss > > > > file://Could you please mail the answer to [EMAIL PROTECTED] > > > > Thx > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Technology Providers > -Original Message- > From: Erich Reimberg N. [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 31, 2001 1:30 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] ODBC Drivers that doesn't support odbc_fetch_row > > > Hello, > > I'm building an application that uses odbc_fetch_row with a row > number (odbc_fetch_row($cx, 0)). > > This works fine in MS-SQL7.0, but the PHP manual explains that > using odbc_fetch_row with a row number (second argument) might not > work with some drivers. > > Does anyone of you have an experience with this? I would like to know > which drivers don't support a row number with odbc_fetch_row, because > I might probably have to use this application with different DBs. > > Thanks in advance, > > Erich Reimberg N > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Sharif Islam [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 31, 2001 11:39 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Php and ODBC > > > > How easy is to connect MSSQL server from PHP , running in Linux? I already > have Php installed but I dont think I complied it --with-odbc(?). Do i > have to recompile? Is there any way to test it? > > Any help will be great. thanks > > -Sharif > > > ) >(( > |""|-. > | :|/' > -`--'- > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Providers
> -Original Message-
> From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 4:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] ODBC Woes
>
>
> I am attempting to use oPAYc (www.opayc.com) as a central method
> of payment
> processing. In order to pass information like different store configs or
> certificates at runtime, I need to pass them in the DSN string area. I'm
> using iODBC right now.
>
> - Jonathan
>
> "Andrew Hill" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Nope, it depends on the driver manager you are using, and I believe the
> > first example has been deprecated in nearly all cases. Why do
> you need to
> > use the first?
> >
> > Just use variables:
> >
> > $dsn="dsnname";
> > $uid="user";
> > $pwd="password";
> >
> > odbc_conenct($dsn, $uid, $pwd)
> >
> > Best regards,
> > Andrew Hill
> > Director of Technology Evangelism
> > OpenLink Software http://www.openlinksw.com
> > Universal Data Access & Data Integration Technology Providers
> >
> > > -Original Message-
> > > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, August 28, 2001 4:05 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-DB] ODBC Woes
> > >
> > >
> > > 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("Datasource","username","password");
> > >
> > > I am confused. I can use the second example (I'm on PHP 4.0.3),
> > > but not hte
> > > first, although I need to use the first example. Is there some sort of
> > > switch that lets you decide what format you can follow?
> > >
> > > - Jonathan
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > >
> > >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 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: Tuesday, August 28, 2001 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC Woes
>
>
> 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("Datasource","username","password");
>
> I am confused. I can use the second example (I'm on PHP 4.0.3),
> but not hte
> first, although I need to use the first example. Is there some sort of
> switch that lets you decide what format you can follow?
>
> - Jonathan
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
