Click here to Skip to main content
12,405,895 members (67,416 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-Server Visual-Studio , +
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:42pm
Updated 22-Aug-11 16:09pm
v2
Comments
walterhevedeich 22-Aug-11 22:11pm
   
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:24am
   
http://www.codeproject.com/Questions/500077/sqlplusserverplus2005plusinstallation-2fconnection

try solution 1 and also check sql server in your services.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Here more reasons so try those too. Here you go
SQL Server 2005 Connectivity Issue Troubleshoot[^]
  Permalink  
Comments
walterhevedeich 23-Aug-11 0:35am
   
Good links. I believe it is what OP really need.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

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  
Comments
Member 11071777 8-Nov-14 12:43pm
   
i followed steps, but i couldn't clear the error
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

lee bae may loe dae ko may ko loe.
min a may sat pat.
may loe ma thar
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160721.1 | Last Updated 22 Sep 2014
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100