Remote MS ODBC connection syntax? (Maybe OT?)

From: Chris McMahon (chris.mcmahon_at_verint.com)
Date: 03/15/04

  • Next message: Tim Johnson: "RE: Remote MS ODBC connection syntax? (Maybe OT?)" 
    Date: Mon, 15 Mar 2004 11:44:26 -0700
To: <dbi-users@perl.org>

    Hello...
            I have the connection working properly on the local machine:

    my $dbh = DBI->connect('dbi:ODBC:DBName', 'name', 'pword');

            But I can't figure out the syntax to connect to a MS SQL
    database on a remote machine. I've tried:

    my $dbh = DBI->connect('dbi:ODBC:\\BOXNAME\DBName', 'name', 'pword');
    my $dbh = DBI->connect('dbi:ODBC:BOXNAME\DBName', 'name', 'pword');
    my $dbh = DBI->connect('dbi:ODBC:192.26.10.20\Instance', 'name',
    'pword');
            
            etc.
            Any suggestions would be welcome, as the DBI docs say "There is
    no standard for the text following the driver name."
            
            

  • Next message: Tim Johnson: "RE: Remote MS ODBC connection syntax? (Maybe OT?)"

    Relevant Pages

    • Re: Which Python web framework is most like Ruby on Rails?
      ... When I first learned PHP, it was pretty standard to use the mysql_* functions (and for another database, a set of functions specific to that database). ... PEAR is distributed with PHP, so it's basically standard, but in the early days it wasn't in the library path by default so it didn't stick out as the obvious way to talk to a database. ... In the Java world, commercial vendors actually compete to produce better JDBC driver implementations, which increases the number of options even more but results in some wickedly fast and advanced drivers. ...
      (comp.lang.python)
    • Re: GEDOM as a database format
      ... Tony Proctor wrote: ... isn't complicated Peter, but that doesn't make it impossible, and it doesn't ... It also includes the operating system crashing for no apparent reason and also the disk on which your database resides going up the swanee. ... The standard I want to see is something not constrained by application program, operating system, or hardware and even at a pinch be implementatble as a paper-based manual system. ...
      (soc.genealogy.computing)
    • Re: Some free utilities for Java, with Hebrew support.
      ... a third-party MySQL client library that I know of. ... market at large. ... The JDBC and ODBC models are such that the database vendor ... provides exactly that adapter to fill in a standard API. ...
      (comp.lang.java.programmer)
    • Re: JDBC URL for Oracle Database With Failover (2 db servers)
      ... After you've loaded the driver, you can establish a connection using ... each form requires a database URL. ... For Oracle, the database URL has ...
      (comp.lang.java.databases)
    • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
      ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
      (microsoft.public.sqlserver.jdbcdriver)