Get A List Of Local SQL Server 2005?
May 5, 2010How can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
View 4 Replies
ADVERTISEMENT
Connecting To Local SQL Server 2005?
Jul 3, 2009I 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]....
VS 2005 Impersonation With Account Local On A Remote Server
Mar 19, 2009I need to impersonate with an account that is local on the remote server not the server where the application is running.
View 1 RepliesUnable To Connect SQL Server 2005 Running On Local System?
Aug 19, 2009An Error has occurred while establishing a connection to the server. When Connecting to a SQL Server2005, this failure may be caused by the fact that under the default settings SQL server doesn allow remote connection (provider: Named Pipe Provider, error: 40- Could not open a connection to SQL Server)I want to connect to the SQL Server 2005 Express Edition which is running on my system from a VB.NET application. I am using Visual Basic 2008 Express Edition. Here is the Coding,
Dim sqlConn As SqlClient.SqlConnection
sqlConn = New SqlClient.SqlConnection("server=localhost" & "initial catalog=LIB")
Try
[code].....
VS 2005 Connect To A Remote Server And Copy A File To Local System
May 27, 2009I want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 RepliesCreate Local Copy Of A List To Be Able To Change Elements Only In New List?
Oct 26, 2011This is probably a really basic question - but I have a list of items (custom objects) being passed from one winform (.net 3.5) to another. I want to create a local list to store changes that only get persisted if the user clicks save. Currently if the user clicks cancel - the changes are still applied in the first form because I assume the objects are reference type.I have the save working as it calls a service layer to do the save and then refreshes the other form - but not the cancel.
View 1 RepliesAsp.net - Local Server Versus Production Server?
Sep 22, 2011I 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.
Changed SQL Server 2005 Express To SQL Server 2005 Standard Edition?
Mar 4, 2011May I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
List Of Local Variables
Feb 6, 2010I am using a lot of variables in my code and like to have them listed or printed. How can I do that?
View 3 RepliesList Of Local Variables?
Feb 7, 2010I am a Visual Basic 2008 user (under Visual Studio 2008) and I have numerous local variables in my project. How can I list them to a file or to a printer?
View 2 RepliesAsp.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]...
Install In Local Server
Oct 27, 2010I 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]...
Refresh Local SQL Server?
Dec 24, 2009VB.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 RepliesList Local NT Groups Windows XP And 7?
Oct 19, 2009I'm looking for the code to list all users in the Administrators group on a local machine. I had something like that for VB script and I converted it to work under .NET but it's slow and not the thing I want.
Dim o_adsi_group As Object
o_adsi_group = GetObject("WinNT://" & System.Net.Dns.GetHostName & "/Administrators,group")
[code].....
List Of Directories On Local Machine?
Oct 14, 2011IIS7 running on Windows Server 2008 R2. Development environment is VWDE 2010.
I'm setting up a simple "machine status" page to monitor a server. I want to display the Drives on the machine, including mapped network drives and show their free space, etc.
I'm using System.IO.DriveInfo.GetDrives() to return a collection of DriveInfo objects. I then itterate that collection to display the relevant information.
The issue I'm having is that only local drives appear. (A:, C: and D:) No mapped drives "Network Locations" appear in the collection.
I'm thinking it has to do with the user account that's executing the code (if that makes any sense). So if the code is executing under the user "ASPNET" (or whatever it is) the drives would have to be mapped under that user. As it happens, I have the server set up like a workstation and it logs in automatically under the user with the mapped drives.
What I've done:
- I have set the Web Site's Anonymous Authentication user to that same user
- I have set the Identity of the Application Pool to which my web site is assigned to be that same user.
SubQuery To A Local List Using ObjectQuery?
Apr 12, 2011I need to find all records where the status is in the local list of Integer's.
In SQL I would do
Where Status in (select i from my list)
But I can't figure how to make it happen in Linq.
ListData = New IssueTrackerEntities2()
Dim queryString As String = "SELECT VALUE CallList FROM IssueTrackerEntities2.CallList AS CallList"
Dim Status As New List(Of Integer)
[Code]....
DB Connection Working On Local Not On Server
May 9, 2011I 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]
SQL Server Name On Local Computer Not Network?
Jul 18, 2012how 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....
VS 2010 Scan All Local IPs For Server
Oct 26, 2011Basically, 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?
Run SQL Server - Running A Local Report Using A Rdl File?
Dec 11, 2009I 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
Asp.net - Server.Transfer Losing Local Variables?
Oct 26, 2011For 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.
Backing Up Database From Remote Server To Local
Mar 25, 2010I 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 RepliesServer.Transfer Losing Local Variables?
May 24, 2010I 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 RepliesSql Server - Copy MS-SQL Table To Local Array?
Sep 19, 2011what 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 RepliesUpdate Local Tables From Remote Server?
Apr 19, 2010I 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
VS 2008 Possible To Use APP Only In Company Because Access Db Is On Local Server As Well
Aug 27, 2010I 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 RepliesWeb Service On Web Server For Local Application Advice?
May 15, 2009i 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.
IDE :: List All The Local Variable Used Inside The Current Function Or Sub?
Aug 12, 2010I have a button inside a one of my forms which contain a lot of coding and normally a lot of variables declaration.
Is there is a option/add-on that I can use/set that enable me to display all the variable used inside the sub or function I am currently working in?
All I can find is add-on to display the Properties/Methods and only Public variables inside the form or inside the class. but I need to list the local variables also.
List All Processes Running On Local Machine In A Listbox?
Jan 5, 2010I want to display in a listbox all the running processes on the local machine. Can anyone offer me some code to do this.
View 2 Replies.net - Couple Of Errors Both Related To SQL Server, When Trying To Run An App On Local Machine?
Jun 30, 2010I 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]...
