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 On Sat, 2004-01-31 at 19:08, Richard Welty wrote: > could you guys kindly please stop it? > > i'm no fan of M$, and i like postgresql a lot, but face facts here. > the guy is proposing a major migration of his desktops. no sane > IT shop would simultaneously migrate an entire database > infrastructure. what he needs are working ODBC or JDBC > drivers so the apps on the linux desktops can talk to M$ SQL > Server, nothing more and nothing less. both options should > work; he didn't give enough information about his desktop > App to really suggest which he needed. > > PostgreSQL and MySQL may not even meet the needs of > said IT shop, none of you have any idea what their schemas > or SQL look like. i've dabbled in Oracle->PostgreSQL migration > before, and it can be pretty challenging if certain "features" > were used by the Oracle developers. > > MS SQL Server-> <some Open Source DB> is likely to be > every bit as challenging, so it's pretty silly to propose it in > this case. > > this flame war is a real waste of bandwidth. > > sheesh, > richard > -- > Richard Welty rwelty@xxxxxxxxxxxxxxx > Averill Park Networking 518-573-7592 > Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security >
