Asp.net Web Service On Local Server
Jan 9, 2012I create a new web service in VS and I create a function that return a value This the code of my function
[Code]...
I create a new web service in VS and I create a function that return a value This the code of my function
[Code]...
i am looking into web services to be used for a windows forms application that i want to connect to my website and return data from my database. One thing i am concerned about is security. I have only played with web service a little bit but it seems to allow direct access to it by url and then run the service, showing the results in the browser. i guess i could set it up to accept a password in the code. i guess really if i have to pass in the query criteria to the sql from the application then showing the records in a browser should not be a problem. in my web application for the site i can keep all my web services in the app_data folder for no browser access.
i just need some advice in this area. goods, bads, other options if better. i don't have a full grasp on working this way from a client side windows application.
I have developed a web service on my LAN PC, then I hosted that Web Service using IIS and now I can access that web service on that Local PC using http://localhost:<PortNo>/Service.asmx and similarly I can access this service from another PC on my LAN network using http://<ip address>:<PortNo>/Service.asmx, all is well.
Now I am trying to access this web service from a VB.net Program on another PC on my LAN. I added the Service to my VB.net Project using the Add reference in solution Explorer, all is well again. Now the problem is I don't know how to access that service in my code? When I try something like this:
dim myService as new WebCalService
'Webcal is my service running on a network PC.
I get an underline under WebCalService and it says Type Expected? How to use a WebService on a LAN in VB.net??
I keep getting the error msg box[code]...
when trying to run a VB service that I developed. I just want to run it and attach a debugger to it.
I put together a small app I want to use on my local network for service monitoring across a few of my servers.
I'm using vb.net express 2010 with system.serviceprocess imported The problem I am having is that my code only seems to work locally, and will not retrieve the service data for any server on my network.
For example, my local machine is called "office-pc", and when running the app on it, I get all the service information.
Dim localServices As ServiceController() = ServiceController.GetServices("office-pc")
For Each localservice As ServiceController In localServices
ComboBox1.Items.Add(localservice.DisplayName)
Next
But, if I want the service info from my web server called "casper", I use the same code, but i change the GetServices() parameter like so;
Dim localServices As ServiceController() = ServiceController.GetServices("casper")
For Each localservice As ServiceController In localServices
ComboBox2.Items.Add(localservice.DisplayName)
Next
After a few seconds delay, nothing happens, ComboBox2 remains empty.
It was my understanding that GetServices() would get the local machines service info unless a machine name was specified, which in both cases is true.
So why isn't it working? Do I need to set something up on the network servers first?
I've a service running under Windows Server 2008R2. I'm using the system.IO to do some copying & deletion of files and directories.This is working fine as long the service is using an user account. If I set the selection to 'Local system account' then it is not possible anymore to delete or copy files.
View 6 RepliesAll, I have a Custom object which I have written using VB.NET (.net 2.0). The object instantiates its own threading.timer object and carries out a number of background process including periodic interrogation of an oracle database and delivery of emails via smtp according to data detected in the database. The following is the code implemented in the windows service class [Code].
After a little bit of experimentation I arrived at the above code in the OnStart method. All functionality passed testing when deployed from VS2005 on my development PC, however when deployed on a true target machine, the service would not start and responds with the following message: "The service on local computer started and then stopped..." Am I going about this the correct way? If not how can I best implement my incident manager within the confines of the Windows Service class. It seems pointless to implement a timer for the incident-manager because this already implements its own timer.
I'm writing a windows service in VB.Net and set the service process installer's "Account" property set to "User". So when I tried to install the utility using INSTALLUTIL.EXE it is prompting to enter the user id and password. So I wanted to suppress this "Set Service Logon" so added below code to ProjectInstaller.vb and I was able to do what ever I want: [code]
View 2 RepliesI moved my web application to a server and im getting this error below, but on my localhost it works great. Im finding that the error has to have something to do with the dataset not pulling back any data, when I do a for each statement. But the weird thing is that I do a for each statement on another page and it works fine. Here is my for each statement, that im assuming doesnt work. The reason im assuming it b/c when i test it on local it works fine:
Dim retObj As New ClassLibrary1.sql_class
For Each row As DataRow In retObj.sel_all_email_list(company).tables(0).rows
email += row("EMAIL_ADDRESS") & "/"
Next
[code]....
Error:Exception Details: System.IndexOutOfRangeException: Cannot find table 0.
Set objService = objWMIService.Get("Win32_BaseService")
objService.Create("usb2", "usb test", "c:usb2.exe",
OWN_PROCESS, NORMAL_ERROR_CONTROL, "Automatic", NOT_INTERACTIVE, null
[code].....
The original code came from AutoItI just rewrote what was necessary for VB.NET and added the structures and throws. If successful the PID of the process started is returned, else an exception is thrown. No imports needed.
View 3 RepliesI was created simple payroll system application. It's already working on my local pc. Now, my client want to install in their server and they need to access atleast 3 pc's to it. This application compiled using setup and deployment. During the installation the access database included with the same directory of the executable file. If I will install this application on their server do I have to install also in their 3 pc's? but every installation it has included access database. How to achieve this? here is the connection of my database
[Code]...
VB.Net, ADO.Net, .Net 2.0, VS2005 I need to implement the ability of MS Access to link to multiple servers. I have a client side SQL Server Express 2008 DB that supports a subset of SQL Server 2000 data. The Express DB is on a client that is a Tablet PC that is disconected and taken into the field.With Access MDB on the client I could add links to the SQL Server 2000 to extract the data in one SQL command. In ADO.Net I need two seperate connections, one for each server, so I can no longer reference both servers in the same SQL statement.While connected how to I 'refresh' my client side data using ADO.Net?
View 2 RepliesI am trying to connect to my local SQL database with the following script:
'* Configure connection object connection string to be used throughout
'* the form.
sqlConNW.ConnectionString = _
[Code]....
I have a query that is working fine on my local but when placed on the server it comes back with this error,
Server Error in 'Page' Application.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. [Code]
How can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
View 4 Replieshow to find the list of SQL servers on the local machine...and not the network...
I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name....
Basically, what I'm trying to do is:
A) Figure out the local IP range
B) Scan those IPs for a specific open port
What i want this to do is Auto-Find a server application on the local network that has opened a TCP port (Say, 6473) Then tell the user the IP address that it's on. I have searched for hours, but to no avail. How would I accomplish this?
I Need vb.net sample code to run SQL Server Report.
- Would be cool if you could provide:
-vb.net code
- sample showing use of parameters
- switching data sources
- setting credentials
- running a local report using a rdl file ie report file
- running a remote report using reporting services server
For my application, I have a page that redirects to another page (within the same application) via Server.Transfer. I need to do this because the original page has an object that I need to access by using the Page.PreviousPage property.
Once my "destination" page has been fully loaded, a local deep clone that I made of the source page's object is suddenly released from memory once I perform a postback? Is this by design--something to do with the Server.Transfer?
Page1.aspx:
Public Structure myCustomObject
Implements ICloneable
Dim someField as String = "default value" ' Default value
[code]....
At this point, EVERYTHING works as it should. Stuff got cloned over correctly and all is well.(Let's say this is on a button click event) Debug.Write(newObj.someField) ' Output: "default value"<- This is NOT "changed value from source page" for some reason when it was working literally a few lines ago! My guess is that the Server.Transfer stops any association with the source page after the new page loads.
I am making a VB.NET application that can download/backup the database that is currently on a remote server. I have Remote Server IP,Username,Password and Database name. I am also able to connect to it. But I don't know what to do after connecting to it. I don't know what all files are need to be backed up. (I think database and log file both must be backed up, I am not sure).
View 1 RepliesI have a page that redirects to another page (within the same application) via Server.Transfer. I need to do this because the original page has an object that I need to access by using the Page.PreviousPage property
View 1 Replieswhat is the best approach in VB.NET to get the entire table from the Ms SQL 2008 R2 database and save it in the program (dynamic?) array or something which is easy to translate into bytes and send to other device via socket communication?
View 1 RepliesI have an off-line project. User uses a laptop to input data off line into local SQL server express. Once connected to domain (on line), local data will sync with remote SQL server using sync framework. (It is done, works fine)One job left:Since another user used another program to update some tables in remote SQL server, such as CUSTOMER, SHIPINFO, my off-line program need to update these new data once connect to domain.Here is what I design in Pseudo (take CUSTOMER as example)
1) In remote SQL server, create a store procedure (sp_customer) to select all CUSTOMERS
2) In application, create a dataset (dst_customer) based on sp_customer
3) Insert all customers data which is in remote SQL server but not in local SQL server based on CUSTOMER_ID
I have made one application for needs of my company.It is published on company's server and it is possible to use the APP only in company because access db is on local server as well.Now I have small update and when users want to update APP they get this error.
View 4 RepliesWhat is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesI am in the following situation: I have been requested to write an application for managing where we have customers - this must flag up when we try to add a customer too close to another one, so must be able to calculate distances based on post codes.I have chosen to use ASP.Net VB because I am fairly good at that and I like that the browser does all of the layout for me (using Java or C# would mean having to position each element individually).I have copied a few files from the company's website (which I also wrote) and modified them to account for the database structure we need for the new app.I have designed the database to account for the requirements of the new app.I have set up a website in IIS on port 81 through which to view the app.
[Code]...
So I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ?
View 4 RepliesI have developed an ASP.Net 2.0 application and I am facing problem in sending email from my Web Server. Following is the VB code I have used to send email from my web application. Thing is when I try to send email from my local system (laptop) the email goes out fine and reaches the recipient address instantly but when I try to send email from my web server it fails.My hosting provider gave me a relay-host address for sending out email. The email goes out fine but the relay host has an annoying amount of delay in email delivery which is a problem during the sign up process.
Here is the code I am using:I have imported system.net.mail in my code and used async="true" on the aspx page.
Private Sub SendMail(ByVal actcd As String)
Dim mailMessage As New System.Net.Mail.MailMessage
mailMessage.From = New MailAddress(support@ihomejobs.com)
[code]....
I have tried the above settings and they work fine from outlook and the application when tried on my laptop but these settings fail on web server.I want to send email from my web server without using a relay-host.
I need a vb source to get the web server path files and download it to the local machine. actually a web html page in that i have href tag to call the vb exe file, in vb file i have to find current server path and download some supporting files to local machine
View 2 Replies