[TriLUG] LA(MSSQL)P - possible solution, inquiry

[Turnpike Man]

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 <andrewphillips at gmail.com> 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 <rwshep2000 at yahoo.com>
> 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