bringing back an old thread I began... Andrew, I was curious if you could explain more about why you think odbtp is better than FreeTDS. If anyone has any opposing thoughts, I'd be curious to know as well. I went back to my old faithful 2+ yr old method I used with FreeTDS previously and have found success. I'll be sharing that success later today after I verify my notes of the process are good.
I didn't choose to investigate odbtp when I realized I'd be compiling just the same as I realized that's what I'd have to do in an old familiar method I had. I was originally hoping a better solution had come along with the use of php-odbc and odbcunix and the sort, but apparently not. Thanks, David M. --- Andrew Phillips <[EMAIL PROTECTED]> wrote: > I've done a lot of research in this area and actually found that odbtp > is a much better solution then FreeTDS to the problem. > http://odbtp.sourceforge.net/ Check it out, you'll probably be > suprised how good it is. > > -Andrew > > > > On Wed, 28 Jul 2004 14:16:05 -0400, Bob Shepherd <[EMAIL PROTECTED]> > wrote: > > > > > > Hi David, > > > > We have done this successfully and recently with FreeTDS. I checking with > my > > partner to see if we have a HOWTO I can provide to this list. > > > > If you've already established connection and can pass TSQL commands from > PHP, > > your problem then is largely one of which methods to use in PHP. The TSQL > > string itself is very close to ANSI-SQL. > > > > Bob Shepherd > > > > On Wednesday 28 July 2004 1:19 pm, Turnpike Man wrote: > > > In the past, I have managed with SuSE 7.1 to MSSQL 7.0 on PPC, but that > was > > > more than 2 years ago. I keep seeing this unixODBC come up and now, so > in > > > a new environment in different job, I'm trying to do as the subject > > > suggests. This is how I did it previously: > > > > > > http://www.turnpike420.net/linux2/Apache_PHP_FreeTDS_MSSQL7.txt > > > Which I honestly can't stand this method and had to do it on SuSE at the > > > time b/c standard installs were configured for it, and I don't think SuSE > > > had a package thing like RPM, but if it did, doesn't matter b/c I didn't > > > know. > > > > > > Anyway, I'm using FC1, I have php and php-odbc packages installed, > unixODBC > > > is installed, as well as Apache 2.x. PHP works great with Apache right > > > now, this is out of the box install, nothing config'd away from default. > I > > > would like to think with this combination I can talk to the MSSQL 8.0 > > > (2000) database from a PHP web application. > > > > > > An alternate method I'm trying is using the FreeTDS tool that I used back > > > in the first example. FreeTDS now comes with 'tsql' tool which I can use > > > and successfully connect to the MSSQL 2K db. I don't know how to use > tsql, > > > so other than successful connect, I don't know how far I can go. At > least > > > it proves I'm not firewalled off form the db. Any tips or experience > > > making this happen would be great. > > > > > > David M. _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
