DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Remotely connecting to SQL Server 2005 error

  1. #1
    Join Date
    Aug 2007

    Question Remotely connecting to SQL Server 2005 error

    Hi guys,

    Any one is there to help me?

    I have problem remotely connecting SQL 2005 thru my VB Aplication.

    I have set it to allow remote connections and use TCP IP and have opened TCP port 1500 on the Windows XP firewall using the SQL Sever on Port UDP 1433. Also the Server Browser service is running. The server is connected directly to the internet on a static IP (eg. IP XX.X.X.XX)

    When I try to connect to the database on another computer it fails. it says Error Msg: "Network Interface Error: Provider not installed"

    OpenConn = Ado_Open(MSSQL2005ConnString("XX.X.X.XX,1500\MSSQLServer", "myData", "", "", "DBMSSOCN"))

    But SQL Server 2005 intaled computer is connecting through above connection string my software is working properly but same software is showing same massage when i am triying with another computer in same Lan Network:

    Help me please.


  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Then there is something that is installed on your computer that is not installed on the other computer.

    Check to make sure the both are configured the same and have the same DSNs installed.

  3. #3
    Join Date
    Aug 2007
    Hi Hack,

    I am not using "DNS" my connection as above direct to server.

    Actual error is: "Provider cannot be found: it may not properly instaled" it was something like some file are not installed. I need to know wich file?

    Next thing is I am not able to connect from remote computer do yoy know any good "tested" connection code?

    Please help me I am realy in very big headache.


Similar Threads

  1. Replies: 0
    Last Post: 12-20-2006, 09:50 AM
  2. Replies: 1
    Last Post: 03-18-2006, 12:55 PM
  3. Sql server Access denied ERROR
    By persian_celina in forum Database
    Replies: 3
    Last Post: 06-14-2005, 06:05 AM
  4. Replies: 0
    Last Post: 07-12-2001, 08:26 PM
  5. SQL server error message
    By Tiffany Sanches in forum VB Classic
    Replies: 0
    Last Post: 01-05-2001, 08:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center