i wanted to know how to deploy a simple program that is coonected to a access database.I have tried it many times but when I try to install it says that some file is mising. How can I do it so that I dont have to copy the database from one computer to another.
View 1 RepliesI am trying to deploy a VB2010 programme that uses the 2010 Access Database Engine. The programme falls over when starting, with an error trying to access the Database. If I Install the programme on a machine that has Office 2003 installed - still installing the 2010 Database Engine - then it runs OK.Does the Database Engine work?
View 5 Replieshow do I deploy a SQL server database program to a machine thats I don't know the name of the machine. tried using "server (local)" but still.
View 6 RepliesI coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
how to create a program that can access information held in an excel database and show it in a simple form.
View 2 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesI have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
how do i go about publishing my program so that it can run right from the cd? do i just publish it to my pc then install it to a blank cd?
View 1 RepliesThis program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
I am trying to deploy my program from vb 2008 express edition into the CD using ClickOnce but it has no progress at all and will take a long time when you run the setup.exe to another computer and in the end it will just pops-up an error. I have followed the proper setup procedure on how to publish the program into the CD with ClickOnce and was able to successfully published it along with all necessary prerequisites and supporting files.But when you open the setup.exe from the CD using other computer,it won't deploy the program into that computer and will just display a window which gives you 3 buttons saying Details,Retry,Cancel saying such error after downloading the required files.Does it matter if my OS is Vista and the computer where I'm deploying the program is using XP?What could have been the possible cause for this problem?How could I possibly resolve this issue?
View 3 RepliesI made an app that uses a Access Db extensively(will be changed to sql later). I have hard coded the location of the db into the app,i use one click to deploy the program and then i manually copy the database into the location.
View 7 RepliesLet's say I roll out version 1 of this project for many users. As time goes by I update the code, change the Access db strucutre here and there, and would like to roll out version 2.What is the best way to do this?Is there an easy way to get the differences between version 1 and version 2 of an access db?
View 6 RepliesCan we deploy an application developed in VB2010 to Linux or Max
View 2 Replieswhen i publish my applications in visual studio 2008. when it is installed i only see the entry in the programs list at the start menu and the application folder is thrown some where else(wonder where). So i was wondering is there a way to publish an application so that when it is installed, it gets installed in the program files folder on C:\
View 2 RepliesI am using VS.net 2003. When I deploy my program and try to run it the program works except that when I try to print a report I get a message that I need a license.
View 7 RepliesI have an vb.net application that I want to install on client machine. The backend is SQL server. Could I make up a setup package that would deploy an application that includes the database with all the stored procedures and tables? The client pc do not have sql server installed there.
View 14 RepliesI connected my project to a sql database - i created the database in sql server 2008..
my project run ok in Visual studio but when i deploy it, it cant find the database
can anyone tell me how to deploy a database with my project?
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?)
View 1 Repliesi am having a big probLem about my Win-base appLication, i am trying to pubLish my project / make it an ".exe = executable" file, it is connected to an ACCESS DATABASE. The problem is that, after getting my application to a ".exe" form, it seems that the application recognize stiLL the original database, where is my path --> OleDb.OleDbConnection("Provider=Microsoft.ACE.oled b.12.0;Data source=C:Usersx3r0Desktopvb_skuLprog_sad_3_te stproducts.accdb") <-- of the originaL database, when i try to input at the ".exe" file, the data are going to the originaL database, and when i tried to change the path, coz i am thinking of using another database, error says cannot find "C:Usersx3r0Desktopvb_skuLprog_sad_3_testpro ducts.accdb"... before changing the databse, ofcourse i have changed that path already for my new database, but it shows an error for the database its using before..
View 5 Repliesi'm developing a linq to sql database application that i created with visual basic 2008. I intend to install the application on another computer system. The problem i'm having now is that, after i've developed,deployed it and installed it on another computer, i can't find the linq to sql database i created with the projectkelvin rolex on the installed application on the other computer,
View 3 RepliesI have develop a wiindows application and it's done in MS Visual Studio 2008 using the VB language and it connect to a 2005 sql database. now i want to deploy my application and want it to be directly attached to my database so that when someone installs it, it comes directly with the database attached to it.
View 1 RepliesI have developed a windows application which performs a series of database operations like select, insert, update. I am connecting to Oracle database and its working fine in development system. But, when I deployed this application, I am getting error at StartConnection (which opens the DB connection). After installing OracleClient in client system, its working fine. Now, my question is that do I need to install OracleClient to every user? If so, it will be hectic to do so as its size is around 200 MB and its not possible to ask all the users to install it just for a small application. I have tried adding some OracleClient files like orannzbb11.dll, oraciei11.dll, iraops11w.dll etc. But in vain! Could anyone please suggest me a work-around or a way to accomplish this?
View 1 Repliesquite new to database queries through VB. I have just created a DB using MS Access and I need to write data to it from my VB Application.Can anyone point me on which objects should I use to execute these write transactions?
View 6 RepliesI 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 .
View 9 RepliesHow can I deploy and reference a stand-alone SQL Server 2008 Express database with my vb.net 2008 Express app ?
View 8 RepliesFor those of you that have been helping me for the last two days thank you first of all, my program is now at the stage where i need to have a windows application that the user can then select databases from, and then using these databases information will be put into a second application that will then run a program to compute some data and spit it into a .xml file.
Is there a prewritten piece of code for choosing databases? And then a set format for choosing cells in that data base to be exported into another windows application?
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 RepliesI am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
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?
View 5 RepliesI want to create program in vb2008 express with ms access database. Can somebody help me so i can learn how to program using classes hard coded. I have learned vb6 before but it has a big difference on vb2008.
I have a database named "DATABASE" in ms access 2003 and the details are: Table :
EMPLOYEE(EmpNo, EmpName), DEPARTMENT(DeptID, DeptName), CATEGORY(CategoryID, CategoryName), SUPPLIER(SupplierID, SupplierName), ITEM(ItemID, Itemname), ITEMLIST(ItemListID, ItemID, ItemDescription), INVENTORY
[CODE]...
All the CAPITALIZED name are Table and all items inside the parenthesis are fieldnames. I don't know where to start on working on this RECORDS. I was able to understand visual basic 6 a bit, and i am trying to apply the coding to VB 2008 but all i get is errors. I am hopeless now and i need help to be able to start my programs. If someone can give me a sample code, i think i would be able to trace the line of code to be able to understand it. I am currently an inventory manager on the small company i was working with and i like to organize my record by using database.