Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.††Topics such as question regarding the System.Data namespace are appropriate.††Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 28th, 2005, 05:08 AM
Registered User
 
Join Date: Nov 2005
Location: Mumbai, MH, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to virajp
Default ADO.NET connectivity problem with SQL Server !!!

Hi,

I have a executable (C#) which connects to SQL server and retrieves some information.

There is one setup which has 2 servers. Both of them are Windows 2000 Server and one of them has IIS and the other is a database server (i.e. SQL Server 2000 SP4).

The IIS hosts some ASP pages and few ASP.NET pages. The IIS server also has the executable mentioned above. This executable and ASP.NET pages are NOT able to connect to the SQL Server 2000 however, the ASP pages are able to connect. The error returned is "System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlInternalConnection.OpenAn dLogin()"

The following is the connection string being used:

SERVER=10.10.1.1,1433;UID=xyz;PWD=;Database=NewPvr ;Network Library=dbmssocn;pooling=false;"

This executable and ASP.NET pages works perfectly fine with all the other machines but this one.

I have tried re-installing .Net Framework 1.1 but that too didnot rectify the problem.

Please write back in case any one has any clue on this issue.

Thanks.


Regards,
Viraj Patel
Reply With Quote
  #2 (permalink)  
Old November 28th, 2005, 02:01 PM
Friend of Wrox
Points: 4,332, Level: 27
Points: 4,332, Level: 27 Points: 4,332, Level: 27 Points: 4,332, Level: 27
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2003
Location: , NJ, USA.
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Check the connection string property in help. It uses different syntax than you have above.

Reply With Quote
  #3 (permalink)  
Old December 5th, 2005, 10:51 PM
Friend of Wrox
Points: 464, Level: 7
Points: 464, Level: 7 Points: 464, Level: 7 Points: 464, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2005
Location: Colombo, , Sri Lanka.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nalla Send a message via Yahoo to nalla
Default

Hi,

First you check the network connection from your machine to SQLServer.
Check whether you can connect to the server from you machine.

In Run--> type \\Server Name and check whether you can connect to the server.

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET connectivity with SQL server shupi Classic ASP Databases 0 September 19th, 2005 07:09 AM
SQL Server with ADO.NET dounme SQL Server 2000 4 February 8th, 2005 08:19 PM
ADO.Net slower than SQL Server Query Analyzer s5g5r ADO.NET 1 January 26th, 2005 08:49 PM
how can i link to sql-server with ado.net[B)] zjxgjp ADO.NET 1 December 25th, 2004 08:50 AM
Connectivity Problem To SQL Server 2k ctanchan Pro VB Databases 4 October 7th, 2003 11:29 AM



All times are GMT -4. The time now is 10:20 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.