On Tue, 11 Jan 2005 14:06:31 +1100, Daniel Kasak <[EMAIL PROTECTED]> wrote: > Hi all. > > I'm after a driver for SQL Server. > > My requirements: > > - must run on Linux > - must support placeholders > - must work with SQL Server 7 > > That's it.
I had the same requirements, and I chose DBD::ODBC, and iodbc. I used placeholders as well. > > To show I've researched a bit: > > I'm currently using DBD::Sybase with freetds, but this doesn't support > placeholders. > I had a quick look at DBD::ADO but it only runs on Win32. > DBD::ODBC requires an ODBC manager, and I'm doing this on the cheap ( ie > opensource only ) Check out iodbc. It's free, and works fine for me. > > DBD::Proxy *might* work. ie install something like DBD::ADO and > DBD::Proxy on the server and DBD::Proxy on the client. Will this setup > support placeholders? Don't know. I'll try it out if I have to, but it's > feels like a messy solution. I looked into that route as well. It took nearly an entire day, but I got DBI::ODBC working fine on my system. I communicate to both SQL 2K and 7. I just have seperate dsn's for both. Like usual, I didn't do a good job of documenting what I finally got to work or I would share more steps with you. Hopefully this can serve as encouragement that your solution is very doable. > > Dan > Good luck, and hope this helps, -Brian
