Problems with connecting to SQL Server via Web Service

#1

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

#2

What is your web service code like?
"shawn" <shawnabc77 (AT) hotmail (DOT) com> wrote

Quote:

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problems with connecting to SQL Server via Web Service

ASP.net Web Services microsoft.public.dotnet.framework.aspnet.webservices

Problems with connecting to SQL Server via Web Service - 08-02-2003 , 06:04 PM

Re: Problems with connecting to SQL Server via Web Service - 08-04-2003 , 11:41 AM