MS_SQL Connectivity

[Collins Richey]

On 5/17/07, Shawn Tayler <stayler at xmtservices.net> wrote:
> Hi Guys,
>
> I am still struggling with getting a commandline connection to a MS_SQL
> box from my linux PostgreSQL server.  I got unixODBC built and have been
> trying to use FREETDS with it to no avail so far.  I was hoping someone
> could tell me if this is a good approach or if there may be another
> simpler way.
>

Both Perl and PHP, and I'm sure Python as well, have standard command
sets for MySQL. It's as simple as coding a connect statement for the
database (make sure your MySQL DBs are setup to permit remote access)
, issuing SQL statements, and exploiting the data returned in arrays
(numeric index or hashed by column name). Google "PHP|Perl|Python
MySQL" for the syntax.

All of these work well via command line.

I'm not sure why you are struggling with something that is easy as
pie? I'm nt a DB heavy, and I can code this stuff in a heartbeat.

-- 
Collins Richey
     If you fill your heart with regrets of yesterday and the worries
     of tomorrow, you have no today to be thankful for.