How to remote connect to the SQL server 2005 when th ere is a‘\’ in the SQL server name, such as

Discussion in 'Ruby' started by Wesley Chen, Apr 7, 2009.

  1. Wesley Chen

    Wesley Chen Guest

    Hi, Guys,

    How to remote connect to the SQL server 2005 when there is a =91\=92 in the=
    SQL
    server name, such as 192.168.0.11\active?

    In fact, when I try to remote connect it by the SQL 2005 client, everything
    goes well.

    On local, there is a SQL 2005 server, it is:
    *Server name:* 192.168.132.157
    *User:* Wesley
    *Password:* 111111
    I can connect it successfully by:
    *db=3DSqlServer.new('192.168.132.157', 'Wesley', '111111')*

    *db.open(=91active_local=92)*

    But on another remote server, it is SQL 2005 with the value like:
    *Server name:* 192.168.0.11\thesql
    *User:* Wesley
    *Password:* abc?de
    I can't connect it successfully by:
    *db=3DSqlServer.new('*192.168.0.11*\thesql', 'Wesley', 'abc?de')*

    *db.open('active_int')*
    or
    *db=3DSqlServer.new('*192.168.0.11*\\thesql', 'Wesley', 'abc?de')*

    *db.open('active_int')*

    I get error message:

    E:/NetbeansProjects/ActiveTrainer/lib/sql-server.rb:*26*:in
    `method_missing': Open (WIN32OLERuntimeError)

    OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server

    * [dbmssocn] **General network error. Check your network
    documentation. *

    HRESULT error code:0x80020009

    Exception occurred. from
    E:/NetbeansProjects/ActiveTrainer/lib/sql-server.rb:26:in `open'

    from E:/NetbeansProjects/ActiveTrainer/lib/sql-server.rb:76

    The *26 *above points to the sentence below in Red color.

    My connect string is:

    *def initialize(host, username =3D 'sa', password=3D'')*

    * @connection =3D nil*

    * @data =3D nil*

    * @host =3D host*

    * @username =3D username*

    * @password =3D password*

    *end*

    * *

    *def open(database)*

    * # Open ADO connection to the SQL Server database*

    * connection_string =3D "Provider=3DSQLOLEDB.1;"*

    * connection_string << "Persist Security Info=3DFalse;"*

    * connection_string << "User ID=3D#{@username};"*

    * connection_string << "password=3D#{@password};"*

    * connection_string << "Initial Catalog=3D#{database};"*

    * connection_string << "Data Source=3D#{@host};"*

    * connection_string << "Network Library=3Ddbmssocn"*

    * **@connection =3D WIN32OLE.new('ADODB.Connection')*

    *End*


    **

    I connect the remote SQL server by SQL 2005 client, using the username and
    password above, I succeed.
    Appreciated to any suggestions.


    Thanks.
    Wesley Chen.
     
    Wesley Chen, Apr 7, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steve - DND
    Replies:
    0
    Views:
    352
    Steve - DND
    Nov 11, 2003
  2. XJ
    Replies:
    8
    Views:
    1,786
  3. Wesley Chen
    Replies:
    9
    Views:
    263
    Sean O'Halpin
    Apr 14, 2009
  4. Replies:
    2
    Views:
    326
  5. Peter Makholm

    Substitutions based on Posix ERE's in perl

    Peter Makholm, Apr 5, 2009, in forum: Perl Misc
    Replies:
    1
    Views:
    124
    smallpond
    Apr 6, 2009
Loading...

Share This Page