Accessing database through Web Service problem

Administrator

23y2.8k.NET

Hello, I have one problem to access database on server. Let me explain what is my problem. We have created one webservice to access data. It is working fine in our local server but have problem on our hosting server. It is giving following error message when we invoke our query using below URL or try to use this web service with our asp.net application. "http://63.239.197.72/accessDatabase.asmx?op=ExecuteMyNonQuery" URL: Error Is: --------------------------------------------------------------------------------------------------------- System.IO.FileNotFoundException: File or assembly name macyqaf3.dll, or one of its dependencies, was not found. File name: "macyqaf3.dll" at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark) at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark) at System.Reflection.Assembly.Load(AssemblyName assemblyRef) at System.CodeDom.Compiler.CompilerResults.get_CompiledAssembly() at System.Xml.Serialization.Compiler.Compile() at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings) at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings) at System.Web.Services.Protocols.XmlReturn.GetInitializers (LogicalMethodInfo[] methodInfos) at System.Web.Services.Protocols.XmlReturnWriter.GetInitializers (LogicalMethodInfo[] methodInfos) at System.Web.Services.Protocols.MimeFormatter.GetInitializers(Type type, LogicalMethodInfo[] methodInfos) at System.Web.Services.Protocols.HttpServerType..ctor(Type type) at System.Web.Services.Protocols.HttpServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) Fusion log follows: === Pre-bind state information === LOG: Where-ref bind. Location = C:\WINNT\TEMP\macyqaf3.dll LOG: Appbase = file:///C:/Inetpub/wwwroot/dingo.com LOG: Initial PrivatePath = bin Calling assembly : (Unknown). === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Attempting download of new URL file:///C:/WINNT/TEMP/macyqaf3.dll. --------------------------------------------------------------------------------------------------------- Any help regarding this? Thanks, vidya

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
Ok, fine let me try it. anyway thanks for your help :-)
0
Administrator23y ago
From the error messages you provided. I GUESS you should try to look at C:\WINNT\TEMP\ first.
0
Administrator23y ago
Can you tell me where they need to set this permission?
0
Administrator23y ago
Is is possible that your hosting company didn't make the correct permission to allow the dynamically compiled DLL to be stored in the system? Maybe you should contact them.
0
Administrator23y ago
Hi, Here is the code I am using in my webservice class. -------------------------------------------------------------------------------------------------------- [WebMethod(Description = "Connects to a any database and performs insert/update/delete functions returns number of rows affected if fails returns 0")] public int ExecuteMyNonQuery(string connectionString,string command) { int i; if(((command.ToString()).StartsWith("SELECT ") || (command.ToString()).StartsWith("select ") || (command.ToString()).StartsWith("Select "))) { //throw the custom exception if the sql command does not start with "SELECT" or "Select". CustomSqlException e = new CustomSqlException("The SQL Command must start with insert or update or delete"); throw e; } if((connectionString.StartsWith("server")) || (connectionString.StartsWith("Data Source"))) { System.Data.SqlClient.SqlConnection xConnection; xConnection = new SqlConnection(connectionString); try { System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand(command.ToString(),xConnection); xConnection.Open(); i = myCommand.ExecuteNonQuery(); // return number of rows affected return i; } catch(System.Data.SqlClient.SqlException) { throw; } catch(System.Exception) { throw; } finally { xConnection.Close(); } } else { System.Data.OleDb.OleDbConnection xConnection; xConnection = new OleDbConnection(connectionString); try { System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand(command.ToString(),xConnection); xConnection.Open(); i = myCommand.ExecuteNonQuery(); // return number of rows affected return i; } catch(System.Data.OleDb.OleDbException) { throw; } catch(System.Exception) { throw; } finally { xConnection.Close(); } } } -------------------------------------------------------------------------------------------------------- But I guess problem is not because of code as it is working fine in our local system.
0
Administrator23y ago
Oops! Do you mind to post some code then?
0
Administrator23y ago
Thanks for the reply. but there is no such assembly "macyqaf3.dll" in local server. web service generates this run time. And every time when I invoke it generates a new name.
0
Administrator23y ago
It sounds that there is an assembly which is resides in your local server that you haven't put to your hosting server. This cause your problem. From the information, that assembly is compiles as the name macyqaf3.dll, maybe you need to upload that DLL to the /bin directory of your hosting server as well.
0