Click here to Skip to main content
15,919,898 members
Home / Discussions / Web Development
   

Web Development

 
QuestionIIS Configuration? Pin
ali_reza_zareian31-Jul-07 19:03
ali_reza_zareian31-Jul-07 19:03 
AnswerRe: IIS Configuration? Pin
kubben1-Aug-07 2:08
kubben1-Aug-07 2:08 
GeneralRe: IIS Configuration? Pin
ali_reza_zareian1-Aug-07 2:29
ali_reza_zareian1-Aug-07 2:29 
GeneralRe: IIS Configuration? Pin
kubben1-Aug-07 2:31
kubben1-Aug-07 2:31 
GeneralRe: IIS Configuration? Pin
ali_reza_zareian1-Aug-07 2:42
ali_reza_zareian1-Aug-07 2:42 
GeneralRe: IIS Configuration? Pin
kubben1-Aug-07 2:49
kubben1-Aug-07 2:49 
GeneralRe: IIS Configuration? Pin
ali_reza_zareian1-Aug-07 2:54
ali_reza_zareian1-Aug-07 2:54 
QuestionAccessing SQL Database from Webservice Pin
alias4731-Jul-07 17:50
alias4731-Jul-07 17:50 
This is my venture into the world of Web programming, so please be verbose in your answers.

I have a WinForms app which accesses a webservice which accesses a database and then returns some XML to the WinForms app.
I am currently in debug mode, and webservice is created OK. I get valid data back if I remove the database code from the equation.

My code to access the database in the webservice is:
<code>
//Connecting to Northwind database
string ConStr = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
SqlConnection myconnection = new SqlConnection(ConStr);
myconnection.Open();
SqlCommand mycommand = new SqlCommand("Select * from Customers", myconnection);
SqlDataReader dr = mycommand.ExecuteReader();
dr.Read();</code>

I receive an error: An error has occurred while establishing a connection to the server.

What steps do I need to take (in both the virtual and real server) for the webservice to see the database?

Regards
Andrew
AnswerRe: Accessing SQL Database from Webservice Pin
kubben1-Aug-07 2:10
kubben1-Aug-07 2:10 
GeneralRe: Accessing SQL Database from Webservice Pin
alias471-Aug-07 3:46
alias471-Aug-07 3:46 
GeneralRe: Accessing SQL Database from Webservice Pin
kubben1-Aug-07 3:50
kubben1-Aug-07 3:50 
GeneralRe: Accessing SQL Database from Webservice Pin
alias471-Aug-07 4:30
alias471-Aug-07 4:30 
GeneralRe: Accessing SQL Database from Webservice Pin
kubben1-Aug-07 4:39
kubben1-Aug-07 4:39 
QuestionClassic ASP question Pin
Vodstok31-Jul-07 8:09
Vodstok31-Jul-07 8:09 
AnswerRe: Classic ASP question Pin
Vasudevan Deepak Kumar6-Aug-07 2:15
Vasudevan Deepak Kumar6-Aug-07 2:15 
QuestionBest Javascript compressor / obfuscator Pin
Chris Maunder31-Jul-07 4:05
cofounderChris Maunder31-Jul-07 4:05 
AnswerRe: Best Javascript compressor / obfuscator Pin
Pete O'Hanlon31-Jul-07 10:36
mvePete O'Hanlon31-Jul-07 10:36 
GeneralRe: Best Javascript compressor / obfuscator Pin
Chris Maunder31-Jul-07 10:48
cofounderChris Maunder31-Jul-07 10:48 
GeneralRe: Best Javascript compressor / obfuscator Pin
Vasudevan Deepak Kumar1-Aug-07 22:55
Vasudevan Deepak Kumar1-Aug-07 22:55 
AnswerRe: Best Javascript compressor / obfuscator Pin
Johnny ²31-Jul-07 14:44
Johnny ²31-Jul-07 14:44 
QuestionAny one help to me? Pin
Pandian BE31-Jul-07 2:09
Pandian BE31-Jul-07 2:09 
AnswerRe: Any one help to me? Pin
Chris Maunder31-Jul-07 4:03
cofounderChris Maunder31-Jul-07 4:03 
QuestionForm authentication Pin
sandeep kumar pundhir30-Jul-07 20:15
sandeep kumar pundhir30-Jul-07 20:15 
AnswerRe: Form authentication Pin
T.EDY30-Jul-07 21:05
T.EDY30-Jul-07 21:05 
QuestionDesigning a form in aso.net Pin
tweety@net30-Jul-07 15:42
tweety@net30-Jul-07 15:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.