richardtoo...@paradise.net.nz wrote:
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.
Thanks for your thoughts on this. I am not very sure about how to solve
the following problem.
I have an OpenBSD Server that is hosting a Plone-based web site and we
need to read and write a few tables located on a Microsoft SQL Server.
Integration with Plone is not strictly necessary but that is what I am
working towards. I am able to access the SQL Server using FreeTDS but
not sure how to use iodbc in this situation or if it is the right tool.
I can conceivably replicate the data to a sqlite or MySQL database and
then use py-sqlalchemy but all that seems too complicated.
I did not get the odbc.ini and odbcinst.ini references to non-existent
files such as /home/openlink/lib/oplodbc.so.1. While looking into that I
got the impression that building the tdsodbc shared library was the way
to access the SQL Server. But that did not work. Now the more I read,
the more confused I get as to what is the correct way to do this.
That was the reason for asking what is the best way to access SQL Server
Databases from OpenBSD.
Anyways, I am working my way through it and will be grateful for any
pointers or advice.
Vijay
