Connecting to DB from a Web Service
-
Hi, I have a web service that references the DLL. Inside the DLL I make a connection to a database, and do some data manipulation. However, for some reason I can not establish the connection. (DLL is a COM object). On the other hand if I just use a simple windows forms application and reference the same DLL, I connect with no problems. It seems that I am missing some settings or something. Really need help. Thank you!
-
Hi, I have a web service that references the DLL. Inside the DLL I make a connection to a database, and do some data manipulation. However, for some reason I can not establish the connection. (DLL is a COM object). On the other hand if I just use a simple windows forms application and reference the same DLL, I connect with no problems. It seems that I am missing some settings or something. Really need help. Thank you!
What is the error? What exceptions are being thrown?
Recent blog posts: * Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3) My website | Blog
-
What is the error? What exceptions are being thrown?
Recent blog posts: * Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3) My website | Blog
-
Hi, I have a web service that references the DLL. Inside the DLL I make a connection to a database, and do some data manipulation. However, for some reason I can not establish the connection. (DLL is a COM object). On the other hand if I just use a simple windows forms application and reference the same DLL, I connect with no problems. It seems that I am missing some settings or something. Really need help. Thank you!
Hi zaboboa If you can just post your code , it will be easy for us to help you
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
Hi zaboboa If you can just post your code , it will be easy for us to help you
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
Hi! Unfortunatelly I have no control over the DLL that I am using. The method in DLL will return the ADO connection object. It's working fine when I reference it from Windows Form Application (connection object is returned), and not fine (get the Timeout Exception) when referenced from Web Service running on my local machine. So, I guess my question is what is the difference in referencing components from Web Service and Windows Form application? Thank you.
-
Hi! Unfortunatelly I have no control over the DLL that I am using. The method in DLL will return the ADO connection object. It's working fine when I reference it from Windows Form Application (connection object is returned), and not fine (get the Timeout Exception) when referenced from Web Service running on my local machine. So, I guess my question is what is the difference in referencing components from Web Service and Windows Form application? Thank you.
hi man I understand your Problem. What you receive is the timeout in the Command object. I hear you say you have no Access to the DLL code. So that means you have little to do with that Problem. i will tell you what did the person who write the DLL missed. CommandObject.CommandTimeout = 0; Atleast microst Recomend it, that means it is infinite.There Shouldnt be a Difference. Thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
hi man I understand your Problem. What you receive is the timeout in the Command object. I hear you say you have no Access to the DLL code. So that means you have little to do with that Problem. i will tell you what did the person who write the DLL missed. CommandObject.CommandTimeout = 0; Atleast microst Recomend it, that means it is infinite.There Shouldnt be a Difference. Thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
Hi Remember there is a Difference Between Web and Windows.
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za