Okay. I looked breifly at OOB, which looks like quite good software,
but unfortunately out of our budget since I am working on a project
which has yet to prove it's usefulness. I am happy to pay for good
software but at this point I cannot justify it to my boss.
I'll take a look at FreeTDS and report back...
Robert
On Apr 25, 2007, at 12:20 PM, Martin Evans wrote:
Robert Denton wrote:
Well, as it turns out, I am jumping the gun. Going by some
tutorials here:
http://www.easysoft.com/developer/languages/perl/
dbd_odbc_tutorial_part_1.html Having unixODBC installed is not
enough, I also need an ODBC driver to go with it. Running
'odbcinst -q -d' reveals I only have [PostgreSQL] but apparently I
also need something that can talk to an MSSQL db.
true, you do need a driver.
I thought unixODBC came with all the necessary drivers? Can
anyone confirm this? Perhaps I need to install a different
version? Thanks!
I can confirm that. unixODBC includes a postgres, an old mysql, a
text driver and a nntp driver but not a SQL Server driver which you
need. Your choices are various commercial drivers (like ours which
you'll find on the same site as the tutorial you are reading) or
FreeTDS.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Robert
On Apr 24, 2007, at 7:17 PM, Ron Savage wrote:
Hi Robert
While connecting to a MSsql database, do you need to pass the
uid and
pwd in the $data_source string as well as in the parameter list for
the connect call? For example, are either of these correct:
Errr, what happens when you try both?
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
