Quoting Vijay Sankar <vsan...@foretell.ca>: > I am trying to access a database hosted on a Microsoft SQL Server 2005 > using FreeTDS and iodbc from OpenBSD 4.5 -stable (also tried OpenBSD > -current as of today). Unfortunately none of the documents I have read > so far or the various trials/tests have helped. I can use tsql and > access the SQL Server but I am not able to use iodbcadm-gtk to add a DSN > > etc.
[cut] > I hope the list can give me any advice or pointers on what is the best > way to access data from a SQL Server 2005 database from OpenBSD > > Thanks very much, > > Vijay I cannot give you a direct answer, but what do you mean by "the best way to access data from a SQL Server 2005 database?" What are you trying to do - the *best* way may be determined by that. Do you have to use FreeDTS or iODBC? Or is that just something you have tried? Is there anything in one of the languages that might help (PHP, Perl, Tcl?) Maybe not (doesn't seem to be anything directly ported, so you might need to do a bit of work here), but might be another avenue to explore, depending on what you are trying to do. If you are only needing to SELECT, then it might be easier to knock up a web service or similar on a Windows box and return the data as XML or whatever (not exactly neat, but better than nothing at all - again, depends on what you need to achieve here.) Not sure if SQL Server 2005 has any built-in web service style stuff. HTH.
