Problems with connecting to SQL Server via Web Service

08-02-2003

dear all,
My program flows as

ASP.NET --> call ---> Web Service ---> SQL Server
(1.1.1.1) (200.1.1.1) (192.168.1.1)

however, the data record is always "0" record.. but
when i access the web service directly, it return some
records.. there's also no problem when my web method has
no function call to the database..

is there some configuration error somewhere??

regards
Shawn

08-04-2003

What is your web service code like?
"shawn" <> wrote in message
news:024601c3594a$7963c720$...
> dear all,
> My program flows as
>
> ASP.NET --> call ---> Web Service ---> SQL Server
> (1.1.1.1) (200.1.1.1) (192.168.1.1)
>
> however, the data record is always "0" record.. but
> when i access the web service directly, it return some
> records.. there's also no problem when my web method has
> no function call to the database..
>
> is there some configuration error somewhere??
>
> regards
> Shawn

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
asp.net web service connecting to another web service	jazzydance	ASP .Net Web Services	3	02-08-2010 11:59 PM
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote	aboutjav.com@gmail.com	ASP .Net	0	05-03-2008 12:43 PM
Problems connecting to MS SQL via Access2000 adp	Paul	ASP General	3	07-05-2005 08:57 PM
Connecting to SQL Server from Web Service	John*	ASP .Net Web Services	4	05-06-2004 04:02 AM
Connecting MS Exchange Data and SQL Server via ASP?	Richard Morey	ASP General	0	02-05-2004 10:20 PM