C# - Deploy SMO Application To Workstation Without SQL Server 2008 Installed?
Jun 15, 2010
I am trying to deploy an application that uses SMO on a workstation without SQL Server installed on it. The instance the app is connecting to is SQL Server 2008. The application is failing with:Could not load file or assembly 'Microsoft.SqlServer.Replication, Version 10.0.0.0, Culture=neutral,PublicKeyToken=89845cdc8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.
The assembly in question is in the same path as my application as well as system32. I am running this on a Windows 7 64 bit box. I have run SQL Native Client, CLR, and SMO MSIs from the 2008 SMO redist download page.This app worked fine when connecting to SQL Server 2005.
I developed a ClickOnce application using MS Chart Controls. It works fine for the charting part. But, as Chart Control needs to be installed beforehand (with admin rights and not with classic ClickOnce deployment), I need to detect if the component is available on the machine. So I tried to create a new Chart and to handle the possible Exception but it seems it is not possible to catch it (too low level Exception?) :
Try Dim oChart as New Chart Catch ' Some user-friendly message to ask the user to contact the helpdesk End Try
This code is never executed: I get a unhandled Exception as soon as I enter the event this code is in. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
***** Exception Text ******* System.IO.FileNotFoundException: Could not load file or assembly 'System.Windows.Forms.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. File name: 'System.Windows.Forms.DataVisualization, Version=3.5.0.0, [Code] .....
Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.That is working, so, so far so good.My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?
I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there The nonplusultra would be that it only starts the server when you click on the shortcut.
How can I deploy my sql server express 2008 database to client that do not have sql server instance at all? Since the server connection in my vb.net program is hard-coded, I want the server instance on client side has the same instant name as mine.
I am trying to deploy an SQL Server 2005 WPF application on Vista. Database connection is failing. Can someone tell me on what to do. The app deploys well on other operating systems.
how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?
My problem is, when deploy vb.net 2005 with crystal report on Windows Server R2 2008, the report can't load it show blank. i'm using AxCRViewer91 component.
the DLL's; AxInterop.CRVIEWER9Lib.dll Interop.CRAXDRT.dll
I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
why is "sql server express" a prerequisite when i deploy my application? is it because i am using the "oledb" class? im using it to connect to a ms access database...could i be using any other class that would not require "sql server" to be a prereq? what about the "ado" class?
A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on a remote VM Server and sends the image location to a VM instance of SQL Server(along with other OCR extracted data).
It is my job to create a program that will:
1. Allow another user to see the filenames on a form, chose which files need to be processed (either by typing them into two textboxes {ie. start and end filenames} or by clicking on a start and end filename on the form {from a databound SQL container maybe?}.
2. The program then must show the images in a picture box as it is copying them to the destination folder.
3. Then the software must somehow be able to regonize which documents were processed, and not include them in new searches.
In our VB.Net application, we need to get the path to our data folder in Public Documents. In our standalone application this is straighforward using the SHGetFolderPath function. However, for our network application, we run into a problem when we load the application on a Win 7 server and run it from a Win XP workstation. From the workstations, SHGetFolderPath returns the workstation's public documents folder instead of the what we want, which is the server's public documents path.Is there any way within the application to query the public documents path on the server?
I created a simple dll in VB2008 on my development workstation (uses a GUID and Implements an Interface,It is a basic "Hello World" & someInputValue. I reference this dll in a MS Access code module and works fine on dev machine. I run Debug.Print testDll.HelloWorld("xyz") and I get I then copy the mdb and dll, tlb files to the remote workstation (where I am also running all versions of the .Net framework) and try this on the remote workstation -- Everything compiles fine within the Access code module on the remote workstation, but I get an error message that the ActiveX control cannot be created when I try to run the procedure. I tried to register the dll regsvr32.exe "C:myDirmyTestDll.dll"and get the message that the dll is loaded but the DllRegisterServer entry point was not found. This file cannot be registered. I know that I have tested other custom dlls on this remote workstation before, and everything worked fine.
I'm not sure if I should post this on this thread or in the Database section but I'm using VB2010 so I posted this unto this. I have a fresh installed VB2010 and a Microsoft SQL Server 2008 R2.And I can't seem to connect my database to VS2010. I've been searching the net but I can't seem to find the solution to my problem.
I have attached my SQL Server Configuration and the error message I got in VS2010.
I recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and 2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
The code below checks whether IE enhanced security configuration installed or not on a server. this works for server 2003 but doesnt work on 2008 r2. it returns IE enhanced security configuration installed response when i know and have checked that its not.[code]...
My Visual Studio 2008 seems to be corrupted. I can not use the Windows Forms designer. I get an error about: "Make sure the application for the file type (.vb) is installed." Also, under menu item Tools>Options, it says "an error occurred loading this property page" when I try to look at the options for 'Data UI Customization' under 'Windows Forms Designer'
Does anybody know how to deploy SQL server database using VBnet.(When you install application on user computer, application should be setled to use database, How?)
I have made a project in vb.net 2008 and used sql server 2008 for database and how to make the setup that need to be deploy on those system which do not have sql server on their system .
I built a specialized userControl using VB2008 (on XP 32-bit) to embed in HTML (not ASP!) and compiled it, pointing to x86 CPUs. I added the necessary keys to the registry (see attachment) to declare a classId in a HTML 'object' tag. This scheme works OK on all 32-bit OS I could put my hands on, but fails to load on 64-bit: I could test only on XP and Win 2003. No error message and Fiddler does not even know something happened... I installed VS2008 on the XP 64-bit machine and ported the code to a fresh userControl (to check the code). I got the userControl running on this workstation without any trouble. I copied this new DLL on another workstation and added the necessary keys to the register, but to no avail. I checked the registry and the 'Wow64' keys are there allright. As a check (and to provide you with a 'working' example), I:
- built a very simple userControl on the 32-bit environment (label, textbox and button to display the text in a mMessage box), - on the 32-bit workstation: + copied the file to a 'program files' folder,
i just finished developing an application with visual basic and want to deploy it on the client computers while the database is on the server in a LAN environment.i tried installing the application on the server but the other computers on the network couldn't access it.i am using SQL 2000 database on the server.
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
Im trying to deploy an application by using clickonce and having some difficulties with it. In a class i have this function
Private AD As ApplicationDeployment Private updateCheck As UpdateCheckInfo Public Function SoftwareUpdate() As Boolean
[code]....
When i create my code on a form (to run the function above) i receive the error "Object not set to an instance" I try to add New to my declaration but then receive the error "Application Deployment has no constructors". Im not sure what im doing wrong or how i should go about this.it does not go past the line AD = ApplicationDeployment.CurrentDeployment i decided to leave the remaining code
I developed a vb.net application and TRIED MYsql for database as ( open source). i have to install this application in client machine? As i am new to MYSQL, for deploying MYSQL Database as a Setup installation (With application ) in client machine.
I have developed an application using VB2005 and Access Database and am trying to run it in another machine but wasn't successful in doing so!I tried to use (Publish from Build) but when I did the setupin the other machine I got anerror connecting to the database simply because the connection string is different
