On Mon, 2004-02-02 at 00:09, Chadley Wilson wrote:
Hi Richard
Unfortunately I have no choice of using M$ SQL 2000-ent it is what
already exist within our business, I am trying trying change our OS so
that I can be a hero and save the company lots of money ;->
Make no mistake if I can get our in house app to run on linux then our
company would switch as many systems to fedora as possible. We could
also offer the distro a bit of financial support once it has been proven
to work.
Just to clarify how the system works,
The app is called Xalt you wont know of it because it is written for our
company.
It is installed simply by copying files from the mapped U drive to
c:\swacc . straight forward with wine and it works.
Now for database connectivity you have to install client connectivity
for windows (I have tried installing it in wine, but it doesn't work. I
just donĀ“t know what to do in this instance. If it will just connect to
the database server the rest will be done by Xalt. Xalt is also 95%
server based so the only thing the client PC handles is the running of
the front end.
If some-one can just give me a starting point for database connectivity
in linux I might be able to get some where.
Problem is I have never setup a database before.
So I have no clue. I have all the info on the server at hand (at least I
think I do)
I have tried posting on the mysql, postgres & sql lists with no answers.
My question is has anyone ever tried to connect a linux box to a windows
sql server? With all the windows PCs in the world some-one some-where
must have tried this.
Chad
You can use
http://www.freetds.org/. This lets you connect to MS SQL
Server with C, C++, Perl, PHP, Python and probably others. There are
also a few good Java JDBC drivers to access MS SQL Server. MS even puts
out their own Java JDBC for MS SQL Server. Where I work all of our
critical data is in Oracle and some small departmental servers run MS
SQL Server, so I needed to connect to it as you do from Linux.
Do you have the source code to Xalt? Are you able to modify it to make
a Linux client? I am not sure you will be able to get Wine to work with
the DB. If the front-end is so simple, you could easily write a PHP
based front-end and have it up in no time to access MS SQL Server over
the web. If you need a GUI, you could write it in Python-GTK, C, C++ or
even Java.
It is very easy to access MS SQL Server from PHP
http://us3.php.net/manual/en/ref.mssql.php
If you could convert the GUI to web based, you could server the PHP app
from your Linux box with no problems.
Jim Drabb
--
---------------------------------------------------------
The box said: "Requires Windows 98/2000/NT/XP or better."
So, I installed LINUX!
---------------------------------------------------------
James Drabb JR
Senior Programmer Analyst
Davenport, FL USA