I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesAfter I published my application and then installed it to the same computer i used to develop the application, there was an error during the installation, the data source file was not found in the new location set by VBE 2010. How to make sure data source file will be installed at the pre-defined location? so that there will be no installation error.
View 9 RepliesWhy do I have a Silverlight tab in "Choose Items ToolBox" when I never installed it?The problem is if I select that tab (by mistake of course ;) it locks up!Reproducable bug:Right click Toolbox to open context menu, select "Choose Items". In the "Choose Items ToolBox" window select SilverLight Tab, after that none of the tabs/buttons work so I am unable to cancel/close the window and have to kill devenv.exe with task manager.System:Windows XP Pro 32-bit VS 2010 Pro Silverlight is not installed!?
View 5 Repliesi have a question in vb about inside a data grid view i need to create a combo box...
View 1 RepliesI am using VS2008 and for the project I am creating, I have a "settings" text file I am using to save user defined settings like color theme, homepage, etcetera. It works fine, however, I am unsure as to how to handle the eventual distributed apps' destination folder/file.
Creating a pre-determined folder/file is easy enough, but what I'd like to do is make it part of the installed folder files, which should be:
I tried creating the file if it wasn't found, however this did not happen (Though I specified the above formatted pathway) perhaps because I was in debug but it should have saved the text file, which it did not and wasn't found anywhere after saving/creating one.
I have the InnoSetup application (Looks great BTW) and see I can include a starting default text file AND make a specific directory for it, but I am unsure as of yet how Inno works exactly, but would prefer testing it through debug before an install anyway. Wish SHOULD be able to be done, am I right?
The odd thing is that although the file was NOT created as specified when creating one, it DID save a setting when I re-ran/debugged the app. (Rather odd, how is this happening I wonder?)
Here is how I am trying to resolve my problem...[code...]
So I am also wondering... if I use the InnoSetup to "set up" the directory and file, and it is according to user-defined destination, how do I reflect that decision in my coding for reading and writting the file?
I could simply use a basic path like C:DATAFILES but this wouldn't be very professional, though fine for development purposes.
I have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I'm using the setup method to deploy an app I wrote. The program installs fine, but If I want to reinstall it I get an error message saying the program is already installed and I have to uninstall it first. Is there a flag somewhere when I create the setup file to allow it be installed over itself?
View 3 RepliesIn our class in Visual Basic, we are required to turn in a payroll system with time monitoring. And I have prepared already the GUI interface of my system. My question is what kind of collection of data should I use, considering the employee population of 30 (that's what our instructor have told us.)Should I use:
a. Arrays to store them like every field (employee number, employee last name, etc.) has its own array.
b. Sequential files for me to store them in a text file (and if in the text file, could I still retrieve the records inside that text file.)
c. A Database.
I have a software that writes data to Excel sheet. I'm using Microsoft Excel 11.0 Object Library for this. Everything is working fine so far, but apparently the drivers require Microsoft Office installed onto the computer.
Is there a way to write data to Excel format without having Microsoft Office installed?
How do I strip out the data source from the connection string so that I only have the directory path and file name.
My connection string is thus:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMartinMy DocumentsVisual Studio 2008ProjectsRestelRestel IIRestel IIRestel.mdb
I have a windows form and I am attempting to create an excel file from a datatable that has already been created and i'm hitting a snag - the error is: The ':' character, hexadecimal value 0x3A, cannot be included in a name."I have a button to start the Export process, here's the
'here's all my imports for the form
Imports DocumentFormat.OpenXml.Packaging
Imports System.Text
[code]....
I want to make it as an Installer.how can i make it a setup file so that user double click it and the software get installed silently? I used in my program ms-access 2007 database and some other sound files which i linked to my project and some vedio files.Suggest me how can i make all the files as in a single installer or setup.
View 20 RepliesQuestion: How do I programmatically determine which provider to use (Microsoft.Jet.OLEDB.4.0 vs Microsoft.ACE.OLEDB.12.0) when my app runs as a 32-bit process on a machine with Office x64 installed?
I'm developing a VB.net WinForms app in VS 2010 and targeting both x86 and x64.The app processes data from xls, xlsx, mdb and accdb files using System.Data.OleDb:Dim oConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...")
The x64 version of the program works as expected. The x86 version works as expected on a system with Office x86.When I run the x86 version on a machine with Office 2010 x64, I get the following exception when trying to open a connection:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.I believe this is because I'm running Office 2010 x64 so the x86 data access components are not installed.I can get it to work for Office 2003 files (*.mdb and *.xls) by changing the provider to Microsoft.Jet.OLEDB.4.0.
How do I figure out which provider to use when running as a 32-bit process on a machine with Office x64 installed?Ideally, I'd like a function:If ProviderIsAvailableFor("Microsoft.ACE.OLEDB.12.0") Then
Else If ProviderIsAvailableFor("Microsoft.JET.OLEDB.4.0") Then
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
View 4 RepliesI think this has to do with a third party OCX control. Below is the output when the application starts. When I install my application on a stand-alone PC or most PCs in a networked environment it runs fine. When I go to some offices that have very tightly controlled networks I have problems.
The set up won't run under the user name so someone from IT must log in as administrator. They run the set up and the application installs and runs fine. The IT person logs off and the user tries to run it and the application won't even start. An error box appears and below is the report. SCANNERLib.DLL is the third party control. Maybe there is something I'm missing when I compile. Maybe the DLL registering funny under the Admin rights. [Code]
I have a few programs published via ClickOnce. These are highly specialized programs, and are only used by a relative handful of people, but the set of users is likely to change, and is spread over a fairly wide geographical area. The major advantage of ClickOnce....ok, for me, the ONLY advantage of ClickOnce, is that I can create updates and have them (mostly) installed when the end user runs the program. Over the brief time that I have used it, I have encountered these aggravations regarding ClickOnce:
1) The application can only be installed on a user by user basis (it can't be installed for all users at once). I understand why this is done for a general solution like ClickOnce, but it is certainly an aggravation.
2) Updates don't always appear to happen. Usually, the updates do happen when a person starts the program, but a fair number of times, the update isn't noticed, or recognized, or something. This causes the user to continue with the old version, which makes them think that I didn't fix the bug they had, which causes them to give me a raft of excrement, which results in me flipping them the bird. Much hilarity ensues (fortunately, I'm friendly with my entire user group, so this is a fairly accurate acconting of the sequence of events, except that I just laugh at them rather than replying in sign language).
3) Certificates expire in a year. Certificates are a great thing...for some situations. In my case, an alternative seems like it might be better.
4) Some settings in the manifest are so doggone hard to fix that I've nearly given up. I changed the URL that ClickOnce was supposed to go to for updates, and found it impossible to change the program to find the new location. It had to be there somewhere, and I found several candidates, but never could find the critical one.
Because of these issues, I have been tempted to write my own replacement. There are a few issues that I'd like some commentary on. For one thing, security is an issue that is hard to pin down. None of the data I am dealing with is worth a second thought. No cracking of that data would harm anybody or any thing. However, my first thought would be to have people install an app that would go to a web service to check for the existence of an updated version. If one was available, then the existing program files would be overwritten by the new files. If one was not available, then no overwrites would take place. Lastly, if the service couldn't connect, then no overwrites would take place (of course). If the files were compressed for transport, it would be kind of difficult to intercept and inject a different program into the transport stream, so the only weakness that I can see would be if somebody hacked the server that held the new version, and replaced it with something else. What am I missing here?Also, has anybody done anything like this, and if so, what else am I overlooking?
I have created a class which builds a Crystal report and displays it in a report viewer. However, without the Crystal Redistributable, the code crashes. How can I programatically detect whether the end-user has the Crystal DLL installed? The code I am required to include is:
[Code]...
I am creating a project with VB2008 Express Edition. The end result will be a CD containing tech manuals in pdf format which will be accessed via various buttons on a form. I am going to include Acrobat Reader Redisributable on the CD which the user can install by pressing a button on the form if required. What I want to do is this:- When the user inserts the CD into the PC, the form will load.When the form loads, I want to search the users PC to determine if Acrobat Reader is installed.If the Acrobat Reader program is not found on the system, then display a MessageBox to inform the user to install the reader from the CD.Would this involve searching the users registry? I would need to insert in my Form1_Load sectionTarget systems would be Windows XP/ Vista with programs on the C: drive as default.
View 4 RepliesI developed a winform application and I want to send the .exe file to someone else. That means that my datasource for my connection string is not the same any more
Dim da As OleDbDataAdapter
Dim dt As New DataSet
Dim objConnection As OleDbConnection = New OleDb.OleDbConnection
[Code]....
I have a problem when creating installer for my project. My project is utilizing Powerpacks 10 and will be deployed on XP machines. These machines do not have internet connection.When I create the installer, can I include the Powerpacks 10 to be installed offline? Currently I have no idea to make the installer to include the powerpacks and install it offline - it always downloads the required files from internet.I looked it up on Microsoft websites and they only offer Powerpacks 3.
View 3 Repliesi have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Repliesi have a code which has the connection string as driver.dim s as string = "Drr={SQL Server};Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"i need to change that to"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"hen i just change the text it gives this error -"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
View 13 RepliesI need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 Repliesi can connect to only one Data Base with dataset in Visual Basic . but i want Have Dynamic connection to data base i mean in want to my appliction users have ablity to connect to any data base they want (For Example : Choose file from menu and then open and then Select any Data base.)
View 4 RepliesI want to create a setup which requires Microsoft SQL Server 2005 and .NET Framework 3.5. If this software isn't installed, the Setup should offer the user to install them now.
View 2 Repliescan data reader be used as a data source for a grid control?
View 5 RepliesI am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesI'm just trying to create a graph where the user can input data into textboxes and then plot the data. I am attempting to use Zedgraph, but open to other suggestions. The program below creates a plot, but it won't update when the textboxes are updated.
Imports ZedGraph
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
How to create a class which inherits from a data type, specifically from Char data type? I just want to add one property to it. If it's not possible, are there any other ways to accomplish this?
View 2 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)