Unix CGI using remote DB

Hi, I have MS-SQL Server running as my DB server.  All of my
webscripts or cgi's will run in a red hat linux server because I
used cold fusion but it was too slow!
My questions are the following:

How can I access the SQL Server with CGI.
Is there any thing like Cold Fusion for Linux?
-pbk
pbkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jcondeConnect With a Mentor Commented:
You will need to do one of the following in order to access the DB:

1)  Develope an interfase that interacts with SQL Server through sockest

or

2)  Use MyODBC which is a freeware odbc for linux/unix/windows


If you choose the second option, wich is actually the best and fastest
way to interact with the db, you will need to install MySQL (I recommend it)
to handle all the data, and MyODBC.

MyODBC has some examples on how to access ODBC databases
written in c.

You can download myodbc and mysql from:
www.tcx.se

if you need any help, please send me an email to
jconde@securities.com

--jorge
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.