Install In Local Server
Oct 27, 2010
I 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]...
View 3 Replies
ADVERTISEMENT
Jun 6, 2009
I have a project that i have created in Visual Studio express and SQL server express. i want to create an install file so that i can send to others to install. Currently it is requiring the user to install SQL server Express and 3.5 .net framework.what steps can i take to stop the user having to install these 2 so that it is a simple install for them.
View 2 Replies
Jan 11, 2010
Is it possible to point the install of ClickOnce to a directory of my choice on the local computer instead of caching it in Documents and Settingsuser? some place like c:Program FilesFoo Apps for example? I like the ClickOnce stuff a lot and especially the update on run functionality, but would like it independent from the user...
Dev/Usr Environment info: I am using VB Express '08 and SQL Express '05 for my applications in a corporate networking environment and the users will be installing from a network share drive. I have tested this and it works fine, just the location seems to be undesirable.
View 4 Replies
May 7, 2009
I created a small application and an installer project for it. I can install and also run it, only thing htat i dont like is that during setup, it downloads .NET Framework 3.5 SP1 and this takes long sometimes. I want to have it on the installation CD later.
I have seen in the installer's detected dependencies, that there is the 3.5 framework contained and it has a InstallURL property = [URL]..I am a little confused about all the Framework stuff on this site - so just 3 simple questions:
1) which file exactly do i have to download,
2) where to put it and
3) what to write into the property InstallURL then? (Maybe needed to change also other properties)?
View 5 Replies
Sep 22, 2011
I 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.
View 1 Replies
Feb 20, 2012
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 6 Replies
Feb 20, 2012
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 1 Replies
Oct 6, 2011
I have a service installed. I would like to install this service (but with different features) twice on the same server but cant as the second service recognises it as the first. How could i avoid this?
View 5 Replies
May 20, 2012
I want to make a database like this one.url...But i want to use it on a pc without installing Sql server.(I can make it work by giving you the .dll files to do it if you want, but rather than that, better you install it completely).
View 7 Replies
Jun 4, 2010
I have an application that uses a SQL Server backend. I wish to be able to create an Install project where the it can install SQL Server and/or an instance on the users machine. Has anyone ever done this before? If so, how is it done? Any examples, etc.
View 2 Replies
Aug 30, 2010
My System gets restarts When i Install MS SQL SERVER 2005,
View 2 Replies
Jan 9, 2012
I create a new web service in VS and I create a function that return a value This the code of my function
[Code]...
View 2 Replies
Dec 24, 2009
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 Replies
Sep 28, 2009
where that i find the commands for make an silent install of SQL Server Management Studio Express.The same thing i did with sql express 2005:
infoSQLExpress.FileName = DirectoryGet + "appsSQLEX05.EXE"
infoSQLExpress.Arguments = "/qb INSTANCENAME=" + txtInstanzname.Text _
+ " ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity" _[code]......
View 1 Replies
Nov 17, 2010
I'm using a ManagementObjectSearcher to query information about installed Sql Server instances, for example:
[Code]...
This method works great for InstanceID, Version and SKUName but now I'm trying to find the installation root as well. For SQL 2005 it appears the property name was SqlDataRoot, but has since been depreciated. Anybody know the correct property name to use to get the data directory, or even just install directory for Sql Server?
View 1 Replies
Dec 12, 2011
I have an application that allows the user to conduct database backups and restores. The users had been using Windows XP, with network security that allowed users to read the registry. For restores, the installation path to the SQL Server named instance was easily found by looking up the instance name in the registry using
restoreDir = My.Computer.Registry.GetValue("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\" & m_DatabaseInstanceName & "\Setup", "SQLPath", Nothing).ToString
They have recently upgraded to Windows 7, and locked down the registry so that users can not read values from it. Is there a way (via code) to find the path to a named instance of SQL Server, so that the app can automatically place the database files (mdb & ldb) in the correct folder?
View 2 Replies
Oct 18, 2011
I need to develop a service and install it into a w2003 box to read excel files a then process its info. The process is as follows, users will upload excel files using FTP and then my service must take those files, validate and then update a SQL Server DB.
The application runs fine on my computer but on the server it asks for the libraries but when I try to install the MS office 2003 Primary Interop Assemblies, system displays "Please install Microsoft Office 2003 before installing the product".
I'd prefer to stay away of any server upgrade as we should require OKs, etc.. so, is there a simple way to just read excel files without having to install any update in the server.
View 3 Replies
Jul 3, 2009
I 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]....
View 1 Replies
May 9, 2011
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]
View 1 Replies
May 5, 2010
How can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
View 4 Replies
Jul 18, 2012
how 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....
View 4 Replies
Oct 26, 2011
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?
View 3 Replies
Dec 11, 2009
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
View 1 Replies
Oct 26, 2011
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.
View 1 Replies
Mar 25, 2010
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 Replies
May 24, 2010
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
View 1 Replies
Sep 19, 2011
what 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 Replies
Apr 19, 2010
I 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
View 2 Replies
Aug 27, 2010
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 Replies
May 15, 2009
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.
View 9 Replies
