Make SQL Server DB App Portable By Adding A SQL Resource?
Jun 9, 2011
I have a simple app (coded in VB 2008 Express Edition) that uses an SQL Server database (in .mdf format) that works fine on my own machine. I created the database in SQL Server on this machine. I added the DB as a data source and it works fine. But when packaged this app (ClickOnce) and installed this app on a different machine the installer tries to download MS SQL Server Express. Obviously this is because SQL Server is a prerequisite and is not installed on the other machine. But just as obvious is the fact that the download will take a long time to complete before my code even starts installing.
My question is this: Is there an SQL Server reference (using Add Reference...) that I can add to avoid this? I suspect the application just needs one or two DLL files from SQL Server. Downloading the whole product seems like overkill. Is there a way I can included the needed files in my app to avoid this long download process?
View 1 Replies
ADVERTISEMENT
Jan 2, 2010
Is it possible to make an vb.net application portable?
View 6 Replies
Mar 13, 2009
I have an ASP.net 3.5 website and I am using vb.net in VWD 2008 Express, I am also using MS SQL Server 2008 Express, I used ajax tabs and a textBox charavters counter control develped by [url]...The database is attached with MS SQL Server Management Studio Express and the files are stored in the SQL default "Data" folder.
The whole project's code and forms are stored in a folder in my E drive.I need to hand the whole project to another coworker who have to finish it, please describe in steps how can i make my website portable (like i can put it all in a folder that he can carry around in his flash disk).
View 1 Replies
Apr 22, 2010
Is it possible to make that an application doesn't have to be installed so it would be portable?
View 5 Replies
May 30, 2010
is it possible to make a portable client for a mmorpg with vb 2008 express? somehow put the files inside of it or somthing?
View 15 Replies
Feb 25, 2009
I'm using Microsoft's Portable VB. so far I'm doing my work with the help of my friends. I'm making a project and for that I want to wheter I can have an image as a marquee. If yes then how to make it work like that or what is the coding for it?
View 2 Replies
Oct 21, 2010
I have a program made in vb 2010. The problem is it uses my files on the computer such as different cursors and pictures and I really want to be able to make it portable and stick it on a memory stick and run it on other computers. Is this possible?
View 12 Replies
Oct 23, 2010
Im make a portable program which has a form with a few different pictures like a photo gallery.when you hover the mouse over a picture it will appear enlarged in a floating box infront of the form. Then when the the mouse is taken away from this floating box the box will disapear and leave you with the picture gallery again?
View 3 Replies
Oct 24, 2011
I want to add an xls file as resource to my vb.net project.
I added the existing file and when i write the code which will help the user to download the file , i am not able to see the resource listed in the dropdown .
Dim b() As Byte = My.Resources.abc
System.IO.File.WriteAllBytes("C:abc.xls", b)
MsgBox("abc downloaded in C:", MsgBoxStyle.Information, "Project")
View 1 Replies
Nov 10, 2009
basically what I want to do is compile a program from my program(parent) to a seperate program(child) which is a module I have created.
When I compile my child program from my parent program I want to add a .exe resource to the child and when the child program runs I want to run the resource I added.
View 1 Replies
Jan 18, 2010
I have a couple of pictures in my resources. I know that I can set an image by:
picturebox1.image=my.resource.picture1
But how can I add an image if I hold its name in a string variable?
View 2 Replies
Jan 23, 2011
I've added multi-language support to my application by setting the Localizable property of each form to True and changing the Language property to the desired one. Then I change the Culture.
vb.net System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("de-DE")
System.Threading.Thread.CurrentThread.CurrentUICulture = New System.Globalization.CultureInfo("de-DE")
VB automatically creates the resource files and this works all fine, but now I need to do something similar for Strings and MessageBoxes, e.g. MessageBox.Show(My.Resources.Exit). Everywhere I read that I need two resource files in order to do this, but I can't find where to add a second resource file myself.
Every forum post or google search result I found says, go to 'Project -> Add Resource', but I don't have the "Add Resource" menu option. Or they say, right click on your solution and go to 'Add -> Resource (RESX)', but I don't have a "Resource (RESX)" menu option either. When I go to 'Project -> Add New Item', there's no 'resource' option in the list either. Am I blind or does VB2010 Express not have an option to add resource files manually?
View 1 Replies
Feb 15, 2010
I am going to create a web server control representing a treeview. So I want to use 2 images for + and - for expand/collapse. How can I build this into the control in a way that can be used as image source when rendered on the page? Since this will be in a compiled web controls library, I don't want to rely on external images in the web application.
Edit:Based on this answer by Andre Kraemer I did the following:
In AssemblyInfo.vb:
<Assembly: System.Web.UI.WebResource("MyCompany.MyWebControls.Resources.plus.gif", "image/gif")>
<Assembly: System.Web.UI.WebResource("MyCompany.MyWebControls.Resources.minus.gif", "image/gif")>
[code]....
My Assembly name is MyWebControls.My Root Namespace is MyCompany.MyWebControls.The images plus.gif and minus.gif are located in a folder named Resources, and the images have Build Action set to Embedded Resource.It still does not work. I get no errors. I have tried the generated image url directly in the browser, bot nothing happens, just a blank page.
Note:I tried to use an invalid path in the resource name, and the result was exactly the same, which made me wonder if I need to do something special to map the actual resource to the resource name. I got a 404 Not Found error only if I used different name in the code than what was specified in AssemblyInfo, it had nothing to do with path was pointing to an actual resource!
View 3 Replies
Jan 7, 2010
Has anyone tried to call FindResource to determine the "TYPELIB" resource that is embedded in a COM server? I am using VB (.NET 2008) to try to accomplish this task. (Why? I want to distinguish between a COM server and other types).
View 1 Replies
May 24, 2009
How can i make it so that when i load my form, it loads a .exe file along with it that is in my Resource folder?
View 5 Replies
Jul 15, 2009
When import image to project. It shows a form and in groupbox resource context ,There are 2 options : Local resource and Project resouce file.appearly : In the first option i dont see any image in project. wherre is it ??
View 4 Replies
Sep 29, 2011
In Visual Studio 2008 I tried to add xml file as embedded resource. During compilation the embedded resource item was simply ignored and the resource I expected to find in resulting dll was not there. I tried several times with no positive effect. Finally I decided to rename the file, so it does not have xml extension. As soon as I changed the extension to (it was .en in this case) Visual Studio started picking the file up and embedding it as part of the assembly. I could not find any any documentation on that odd behavior. Does anyone know if that is expected, and, if so, why ?
View 10 Replies
Feb 18, 2010
I need to create a list of possible images to change picturebox controls to. I have the images loaded into the My resources folder of the solution, but I need to create an array referencing them. What data type do I use for the array?
View 9 Replies
Jun 28, 2009
was just wondering in the next versions of vb.net, will the default settings designer in be able to make the onfiguration portable ( which i mean by that the user.config file will be in the app folder ? why i am asking ?urrently my application is portable and i use ini files to store the settings within the application folder and i really wanted to use the settings designer instead ofimplementing my own Settings class using ini or xml files
View 7 Replies
Nov 6, 2009
I was wondering about the possiblity of creating a portable application in vb.net, not for anything specific - more out of curiousity than anything else. The only way that i have thought of doing this is creating an application, grabbing it out of /bin and it would save settings in a xml file or text document/whatever.
View 4 Replies
Feb 10, 2010
I have run into a problem with a couple of the "Sync" applications I wanted to create. In both instances, I am trying to connect a Portable Device to my computer and access it using VB.NET. One application would pull the pictures in from my camera, rename them, and put them in folders according to their date taken. The other would place the podcasts I have downloaded onto my Mp3 Player. I have the logic for both so that if I run it on two Windows directories, for example (C:Source and C:Destination) but when I try to access the Portable device using a directory browser, the "OK" button is disabled. Is there any way to access the directories on such a device?
View 2 Replies
Apr 8, 2010
I'm creating a WPF application in VB.NET with the 3.5 Framework. (If you provide an example in C#, that's perfectly fine.)
In my project I have a Template for an MS Access database. My desired behavior is that when the users clicks File-->New, they can create a new copy of this template, give it a filename, and save it to their local directory.
The database already has the tables and some starting data needed to interface with my application (a user-friendly data editor)
I'm thinking the approach is to include this "template.accdb" file as a resource in the project, and write it to a file somehow at runtime?
View 4 Replies
Mar 14, 2009
I have an ASP.net 3.5 website and I am using vb.net in VWD 2008 Express, I am also using MS SQL Server 2008 Express, I used ajax tabs and a textBox characters counter control developed by [URL]..The database is attached with MS SQL Server Management Studio Express and the files are stored in the SQL default "Data" folder.
The whole project's code and forms are stored in a folder in my E drive. I need to hand the whole project to another coworker who have to finish it, please describe in steps how can i make my website portable (like i can put it all in a folder that he can carry around in his flash disk).One more thing, I already finished my side of the project, I need to ship it out to this other programmer.
Can anyone suggest something like a: Checklist or Must Do list to achieve this?PS: I have had a problem trying to move the project from one server to the other, the project seems to look for the dlls of the AJAX control and the textBox counter where i originally unzipped the folders in which they cam in, which i think was on my desktop, although when i added those controls to the Tools tab, i created a new tab, then i choose the dll from the where i unzipped the controls source code, aint that enough?
View 1 Replies
Jul 25, 2010
I have a server which has around 300+ users on it. Though the problem is that its coded in VB6, and if somebody has a bad ping, everybody has a bad ping. I need a tunneling server which will tunnel the incoming and outgoing connections and make there ping appear to be 0 in the server. Client to Server, Server to Client.
View 1 Replies
Mar 6, 2011
I would like to use the .NET FileSystemWatcher class to monitor a folder path which is located on a device currently connected to the host computer and is being managed by Windows Mobile Device Center. The environment is Windows 7 Pro, x64.
When connected to the PC, the device is listed under "Computer" -> "Portable Devices", and I can navigate to its filesystem from there. When setting the "Path" property of my VB .NET app's FileSystemWatcher class object instance, however, it only accepts a valid string-representation of a standard filesystem path (eg. c:somedir hisdir), whereas the address bar of a navigable portable device reads "ComputerPocket_PC";a value which throws an exception at runtime.
Am I able to use the FileSystemWatcher class in this context? How else could I get a PC app to monitor file activity on a handheld device while it is attached?
View 1 Replies
Mar 4, 2010
I need to refer to some strings using an "indirect string" in the registry. It should be in this form:
@filename,resource
MSDN: "If the resource value is zero or greater, the number becomes the index of the string in the binary file. If the number is negative, it becomes a resource ID."How can I find out either of these numbers for my resources that only have names in VB? I also need the ID/index for the exe's icon.
View 2 Replies
Sep 24, 2010
How to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?
View 6 Replies
Jun 21, 2012
What i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
View 3 Replies
Nov 6, 2009
I have an application in which i have a database .mdf file in directory which i use a connection string to give a path of to access it, which means without installing sql server i can access database. Connection string below to access this database(.mdf) which placed in the directory.
dim con as sqlconnection = New SqlConnection("Data Source=.SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|Universal_data.mdf;user instance=true")
Now the question is that if i access this .mdf file without installing sql server, i also want to access to this .mdf file on other computer(client) after creating DSN or any other connectivity tool.
Let me know you that when i install sql server 2000 or 2005 i create SA user name and password which i use to create DSN on client computer and give SA username and password in the connection string that successfully works and client get access to sql server, connection string is below.
Dim serv = "MY-LAPTOP"
dim con as sqlconnection = new sqlconnection("Data Source=" & serv & ";Initial Catalog=clinic;Persist Security Info=True;User ID=sa")
I only need to know that my application access .mdf file without installing sql server works fine on a single computer, and i want to give access to this .mdf file on other clients without installing sql server on server computer (like i mentioned above paragraph) how will do it.....
View 1 Replies
Jun 3, 2011
I have a VPN server Hosted in 80.234.49.64 For Incoming Connections I have to Login Remotely(RDP) & add User Manualy(username & password)I Just want to do it remotely(adding users for incoming connection) Through an application........which i want to write in vb.net?
View 8 Replies
