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
