Hi, I try to connect my webservice with database but appears a error in Winhost environment. My web service use adodbConnection As New ADODB.Connection. the connectionstring is: "Provider=SQLOLEDB;Network Library=DBMSSOCN;Data Source=s03.Winhost.com,1433;Initial Catalog=DB_30290_a0012;User ID=*****;Password=******;" this connectionstring works correcty in my local environment. Anybody can help me? Thanks in advance
Hi Dritan, What's the error message? You may also want to look at this knowledgebase article which provides sample code: http://support.Winhost.com/KB/a688/how-to-query-sql-database-with-asp-using-dsn-less-connection.aspx
I've tried your example but is not work Of course i have tried the connectionstring in the example but is not work. the error message is: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Security.SecurityException: That assembly does not allow partially trusted callers. at Service.getRecordSet(String sqlScript, String ID_KLIENTI) The action that failed was: LinkDemand The assembly or AppDomain that failed was: App_Code.70sxb7se, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null The Zone of the assembly that failed was: MyComputer The Url of the assembly that failed was: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/smiws/888360ff/a7c2d5af/App_Code.70sxb7se.DLL --- End of inner exception stack trace ---
Try setting your application to use 'Full' trust as detailed in these knowledgebase articles: http://support.Winhost.com/KB/a722/common-errors-associated-with-inadequate-trust-level.aspx http://support.Winhost.com/KB/a657/changing-the-default-aspnet-trust-level.aspx
Monitor Database Hello, My client wants to monitor the persons thats logins and logout in the database throught the Sql Server Managment Studio. Winhost offer this service. Thanks in advance
