Using MSSQL from a Unix account...

[Alessandro]

...is it possible?

Did anyone experienced to connect a unix hosted site to MSSQL?

[Brangwyn]

There are 3rd party drivers available, but Microsoft themselves do not provide any so its all unsupported. I have no idea whether Vortech have any of these intalled either.

Heres a bit of info on the subject.

http://www.algonet.se/~sommar/mssql/unix.html

[electricfox]

Why in the world would you go through the hassle when you can use MySQL?

[Brangwyn]

I guess some people just like using real DBMS's

Postgresql is a better DB in most terms, but support for it in some languages seems to be less readily available, as most PHPers like MYSQL, even though it is less capable.

[Alessandro]

Hello to everyone,

Sorry for not responding in real time, but I'm 6 hours ahead of the East Coast.

Brangwyn:
Thank you for the link, it was useful for my purposes.

electricfox:
Actually is not my idea but a customer's one. He thinks to change to a unix account and I understand he doesn't want to loose the MSSQL commit/rollback function for data integrity.

landiserve:
For market reasons I'm leaned towards MS (not a nice thing to say from a Mac user...). Does Postgresql use commit/rollback?

[Brangwyn]

I believe it does support commit/rollback Alessandro

[Alessandro]

I'll give it a deeper look then.