Re: data_source syntax

I have installed FreeTDS, and I have registered a tds.driver.teplate and a tds.datasource.template with unixODBC using odbcinst -i -d -f and odbcinst -i -s -f respectively. I was following this tutorial:

http://www.unixodbc.org/doc/FreeTDS.html

Unfortunately I am still having difficulty getting the perl script I am working on to work correctly. I can provide a full copy of the script if necessary, but this is the eorror I am getting:

Can't connect to data source driver={SQL Server};Server=<192.168.0.149>; database=<userFeedback>;uid=<testUser>; pwd=<testPass>;, no database driver specified and DBI_DSN env var not set at ./feedback.pl line 11

What am I missing?

Robert


On Apr 25, 2007, at 12:40 PM, Robert Denton wrote:

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
ron@xxxxxxxxxxxxx
http://savage.net.au/index.html




.

Relevant Pages

  • RE: [dbi] DSNs
    ... you should have a freetds entry in ... might help explain as they contain alot about unixODBC, ... > I'm trying to debug an install for my DBD::ODBC module, ... I'm trying to install the ODBC driver ...
    (perl.dbi.users)
  • Re: XP HOME BOOT FAILURE
    ... you remove the driver for the graphics card, ... >> If you run a repair install as I initially described, ... A repair install should bypass that but it will ... >>>> on, follow the screens. ...
    (microsoft.public.windowsxp.accessibility)
  • Re: XP update loses sound card
    ... I assume you tried a forced install of a soundcard? ... should try the sound card driver from Toshiba ... The WINMM WDM Audio driver is out of the list now. ... The sound is enabled and uninstalling the Microsoft WINMM WDM Audio ...
    (microsoft.public.windowsupdate)
  • OT: What do you do with your old computers?
    ... connected that to the WLAN as well, using a small USB wireless link. ... And what about backups for petesp4 and Bigblack? ... Once it was talking to the network, I decided to install the printer and the ... driver, and was marked as an unknown device. ...
    (comp.lang.cobol)
  • Re: Modem Install Problems
    ... PCI: PCI BIOS revision 2.10 entry at 0xfb9c0, ... ACPI tables contain no PCI IRQ routing entries ... Serial driver version 5.05c with HUB-6 MANY_PORTS ... install: cannot stat `536ep.o': No such file or directory ...
    (comp.os.linux.setup)