Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re: MS SQL Server

by lhoward (Vicar)
on Aug 29, 2000 at 17:32 UTC ( #30124=note: print w/replies, xml ) Need Help??

in reply to MS SQL Server

You didn't say if your client perl program was going to be running on NT or UNIX. If it is going to be running on NT, you should have no problems, DBD::ODBC works just fine and is as good performance-wise because MS Sql is as-fast w/ ODBC as with any other driver:
use DBI; my $dbh = DBI->connect("dbi:ODBC:MQIS","USER","PASSWORD");
where MQIS is your ODBC DSN.

If your client is gonna run on UNIX (or any OS for which MS does not provide client-side ODBC libraries) you have 2 choices:

  • DBD::Proxy - run a proxy DBD on an NT box and have your perl programs use DBD::Proxy to connect to the proxy.
  • 3rd party ODBC driver - there are some 3rd party ODBC drivers for MS Sql server (some commercial, some not) that you could use. I've never used these (don't even know where to get them), but I have heard that they exist :)

Replies are listed 'Best First'.
RE: Re: MS SQL Server
by TStanley (Canon) on Aug 29, 2000 at 18:24 UTC
    Openlink Software is a company that has a very good generic type
    of ODBC driver, that will connect to just about any type of database,
    whether it is Oracle, MySQL, Informix, MS SQL Server, Solid, etc.

    There can be only one!
      An update to this post..The Openlink drivers work with pretty much any database at the moment, except MS SQL Server. It seems their code has a bug in it, of which they are aware, and it will be fixed in their next release, which is due out within (HOPEFULLY) the next month. The drivers for Oracle work quite well, and the only problem that has been noted, is that you need to use a SQLDRIVERCONNECT to connect to the database, instead of SQLCONNECT. This has been reported to Openlink, and will be addressed in the next release.


      UPDATE (13 NOV 00): The new drivers are out and unfortunately, the same bug is still there.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://30124]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (2)
As of 2022-01-27 20:27 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (71 votes). Check out past polls.