Remotely connecting to SQL Server 2005 error
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.
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
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.
Last Post: 12-20-2006, 09:50 AM
By anita in forum Database
Last Post: 03-18-2006, 12:55 PM
By persian_celina in forum Database
Last Post: 06-14-2005, 07:05 AM
By robert in forum Database
Last Post: 07-12-2001, 09:26 PM
By Tiffany Sanches in forum VB Classic
Last Post: 01-05-2001, 08:01 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL