Trying Database Connection in Web Service

[niyati]

hi,

this error comes in the connection string line when i try to connect my web service to the sql server database.

 

An unhandled exception of the 'system.web.services.protocols,soapexception' occur in system.web.services.dll

 

additional information system.web.services.protocols soap & exception server was unable to process request

system.runtime.interopservices.comexception(OX80040E21)

Multiple-step OLEDB operation generated errors check each status value,if available.No work was done.

At adodb.connectionclass.open(string connectionstring,string userid,string password, int32 options)

at testwebservice.service1.helloworld() in

C:/Inetpub/wwwroot/testwebservice/service1.asmx.vb

 

end of inner exception stack true

 

 

urgent reply appreciated

 

Thanx

[Nerseus]

Don't know about urgent...

 

Can you send us the code that's causing the problem. Also, send us a sample of your connection string AND the code that calls the webservice.

 

The more info the better. Much better to have too much than too little.

 

-Nerseus

[niyati]

Thanx for help

But now my that problem is solved.

I have another problem like i want to return a recordset from my web service function to a windows application function. But when I do this and compile my web reference it gives me an error that service1.asmx?wsdl not included in the dll

 

My Code is as under

Service1.asmx

Web Service Name is "TestWebService"

 

<webMethod>Public function HelloWorld() as Adodb.recordset

dim rs as Adodb.recordset

Helloworld=rs

end function

 

Windows Allication

 

Public function button_Click

dim ws as testwebservice.localhost.service1

dim rs as Adodb.recordset

rs=ws.helloworld

end function

 

 

 

Thanx

[niyati]

Hi,

 

I have my application completed in vb.net . i want to convert my app from vb.net to asp.net . What's the solution.

 

I saw that it allows me to add vb.net forms in asp.net application.

in one of the button click's i can even write form.show but it does not show me the form.

 

 

 

 

Thanx