Trying Database Connection in Web Service

N

niyati

New member
Joined
Jun 30, 2003
Messages
3
Location
India
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
 
Dont know about urgent...

Can you send us the code thats 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
 
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
 
Hi,

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

I saw that it allows me to add vb.net forms in asp.net application.
in one of the button clicks i can even write form.show but it does not show me the form.




Thanx
 
Back
Top