[RESOLVED] ODBC Help

[ixalmida]

This doesn't look like the most active forum, but I'll give it a go anyway...

Could someone point me to a clear, concise guide (or post one here) to setting up freeTDS/unixODBC or some other 'nix client to query a MSSQL server from my Linux box?

I've built a new SUSE 11 server, I've installed freeTDS and isql exists, but the iODBC file is missing and the instructions don't seem very clear on configuring a data source. I should be able to run a MSSQL query from the Linux console. The following works on the old, SUSE 9.1 server (which was built before I got here):

cat /usr/query.sql | /easysoft/unixODBC/isql DSNAME USER PASSWORD -b -x0x09 > results.csv

Maybe I'm swimming upstream and I should just build a Windows box to host my website...?

[Design-Dolphin]

Have you got a change to check out http://www.unixodbc.org/ ?

You could also try some of the Suse related forums. My guess is that someone has run into this before. I recall reading a article a little while ago, about crossover server products and server environments. However I don't remember if it was related to the exact problem your having and at which stage it was and if it is only available in the enterprise version of Suse.

I don't know about the upstream part. Personally I keep ASP with MS and PHP with MySql. (and prefer working with PHP, MySQL and Apache)
I don't have any experience mixing the two, so unfortunately I can't help you there.

[ixalmida]

Thanks for your response. I have been to the unixodbc.org site many times. I still haven't figured this out, but I'll continue working on it. I may try just transferring a bunch of folders from the SUSE 9 box to the SUSE 11 box, since it seems to work there.