Remotely connecting to SQL Server 2005 error


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
    Posts
    1

    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.

    Riyaz

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Aug 2007
    Posts
    1
    Hi Hack,

    Thanks
    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.

    regards
    riyaz

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, 07:05 AM
  4. Replies: 0
    Last Post: 07-12-2001, 09: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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