Re: data_source syntax

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: How to make the file undeleteable
    ... the driver can be stopped, ... Microsoft MVP - Windows SDK ... Free Win32 Source and Tutorials ...
    (microsoft.public.vc.language)
  • Re: Wireless & CD problems.
    ... A Netgear WG511 PCMCIA card, ... First of all I note that the prisim54 driver (common for the v.2 ... For some reason most tutorials leave out the part where the wrapped ... form XXXX:XXXX (see ndiswrapper -h for a bit of reminder). ...
    (Ubuntu)
  • Re: The Eternal Search for Dev Documentation...
    ... I'm interested mainly in device drivers. ... driver for Linux and for Minix3 ... For sure there are books or tutorials how to program R2232 and PS/2 ...
    (comp.os.minix)
  • Re: what are the steps to add my code for class driver like printer cl
    ... You can either create a PB project into your OSDesign to embed your driver. ... you should be able to handle it following tutorials of PB ... You can also create a complete sysgen component in public directory. ... Yannick Chamming's ...
    (microsoft.public.windowsce.platbuilder)
  • Re: data_source syntax
    ... Unfortunately I am still having difficulty getting the perl script I am working on to work correctly. ... I'll take a look at FreeTDS and report back... ... 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. ... Perhaps I need to install a different version? ...
    (perl.dbi.users)