Click here to Skip to main content
Sign Up to vote bad
good
See more: SQL2008VS2010
Hello everyone,
 
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour ,
First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)
 
But when I was trying the application in another pc (Windows 7 32bit)
 
I got this exception:
 
A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
 
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when
the app reaches the DataAdpter.Insert(....) It runs without any problem .
 
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception .
 

Now I hope you understand my problem
 
I tried these things as a solution:
 
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALI\SQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
 

My question is what is the difference between fill and insert?
Is there a problem with my connection?
My app. runs smoothly on the original pc ,What should I do?
Please If anyone knows anything help me, I am very desperate.
Posted 22 Aug '11 - 15:42
Edited 22 Aug '11 - 16:09

Comments
walterhevedeich - 22 Aug '11 - 22:11
What's the data type of DataAdpter? I assume its not SqlDataAdapter since that class has no Insert method.
Abhishek Pant - 19 Dec '12 - 3:24
http://www.codeproject.com/Questions/500077/sqlplusserverplus2005plusinstallation-2fconnection try solution 1 and also check sql server in your services.

4 solutions

Here more reasons so try those too. Here you go
SQL Server 2005 Connectivity Issue Troubleshoot[^]
  Permalink  
Comments
walterhevedeich - 23 Aug '11 - 0:35
Good links. I believe it is what OP really need.
  Permalink  
HI,
 

 
GO START -> ALL PROGRAMS -> SQL SERVER 2008/2005/2008 R2
->CONFIGURATION TOOLS->
->SELECT SQL SERVER CONFIGURATION MANAGER
->SELECT SQL SERVER NETWORK CONFIGURATION
->SELECT PROTOCOLS FOR MSSQLSERVER(YOUR INSTANT NAME)
->IN RIGHT TASK PANEL
->MAKE SURE MENTION BELOW:
 
DISABLE SHARED MEMORY AND VIA
ENABLE NAMED PIPE AND TCP/IP
 
—-MAKE SAME THING IN
->SQL NATIVE CLIENT 10.0(SERVER VERSION) CONFIGURATION – CLIENT PROTOCOLS
 
RESTART SQL SERVER(MSSQLSERVER [YOUR INSTANT NAME]) SERVICE
  Permalink  
asddsa
asd
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 369
1 OriginalGriff 190
2 Tadit Dash 168
3 CPallini 163
4 Aarti Meswania 153
0 Sergey Alexandrovich Kryukov 10,169
1 OriginalGriff 7,749
2 CPallini 4,181
3 Rohan Leuva 3,482
4 Maciej Los 3,089


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 6 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid