I've been using ms access bfore but want to upgrade coz the company im working in is getting bigger. With almost 10,000 new clients added every week. Im afraid access can't handle it anymore. So im planning to create a new database. Im really new to this SQL Express but have knowledge in sql using vb codes. Is it easy to be used as backend database?
View 6 RepliesWe are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesI am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
View 6 RepliesI have a User interface in VB.net(for a desktop application). And i want the backend to be in Java. How to connect them . Example: I want to have the search box functionality to be wriiten in Java.
View 1 RepliesI am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesBasically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
I have built an application using VB 2005 express edition with backend Ms Access 2000. In main form(which is loaded on startup), I am having 9 datagridviews, each bound with databindingsources. I am refreshing this data every 15 seconds by refilling the table adapters and updating the datagridviews.Now, this access database is shared in the network and is accessed by about 5-6 users concurrently. There are other forms which are used to edit the data.My problem is poor performance of the application. Its very slow in opening up forms, not responding sometimes and using the network resources fully.
View 5 RepliesI have a windows app created in 2005 with sql server backend. There's also a web service that is located on a web server at a hosting facility. In my app, when ever it needs to interact with the data, it calls the web service.Ive been having this issue with several screens that Ive developed in .Net. The user enters a date, and saves to the database. When the datagridview is refreshed, the date that they entered always displays one day earlier. Eg. If they entered 4/18/2012, it displays as: 4/17/2012.
The date is correct in the database. I verified that the problem resides on the web server. The default timezone set on the server is GMT -06.00 Central Time(US and Canada) and it cannot be changed on the shared server. The time zone where I'm at is Pacific Standard time. I'm not sure the best way to deal with this issue. Here's one way I was thinking: Retrieve today's date from the server (don't know how to do this), and compare it to the date on my machine so I know the difference. Then, when I'm looping through the datatable, add this same number to the dates to display correctly. Maybe it's better to retreive it from the database via the sql?
Tell me if I want to run a project that is created in vb.net 2010 and uses a backend SQL Server 2005.........how many changes can be done in a project to run on another computer....?what connection string I can write for it.......?which software do I need to install on the other computer to run a project on it.......
View 1 RepliesOne of the things I'm trying to do is work out the total profits for a company, reading from an access database comprising of two linked tables. All the information needed for the calculation in question (Fees, Sold/Bought?, Cost/Income) are found in one form (Financial) and I want to read this information and carry out the required calculations within a sub.
Here is the calculation in Pseudocode I wish to do:
Do
If SoldBought = Sold then
Total = Total + Cost/Income - Fees
Else: Total = Total - Cost/Income
Read Next Record
Loop Until End of Records
[Code] .....
Unfortunately, I encounter an error with the above. I get the following error;
"There is no Row at position 0".
How I could get this in motion - I've been stuck in a rut for days trying different things out and I've come to accept that I can't do this alone.
I have a VB.NET 2005 WinForm app that accesses a SQL Sever Express database.I use the Microsoft Practices Enterprise library to handle my data access with the following appearing in my app.config file.
View 7 RepliesI'm using Excel as a database backend to load into a datagridview.
This is how I connect and bind to the dgv:
vb.net Dim sFileName = filelocation & "checks.xls"
Dim connectionStringTemplate As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=Yes;IMEX=1"""
[CODE]...
It connects and populates fine. I have a button for the user to "refresh" the datagridview. I cannot get it to correctly refill the dgv. I have tried setting the bindsource.datasource to Nothing along with the datagridview datasource, but I get an error that brings up the Visual Studio debugger with no real error message...
My problem is that I need to use a access database as a backend for my visual basic.net program.
The database will be accessed by a maximum of 10 users but I want to lock tables when a user is updating a record.
I am unable to use the SQL server at the company due to it storing sensitive information.
I have some basic knowledge of ado.net
I have read many articles but I can't find any articles that say how to lock a access .mdb file using Visual basic.net
I has a Access database ...that is password protected.... i am connecting in this manner given as follow .......(Without password protection)
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:My Documentsdb2.mdb")
cn.Open()
///codes.......
cn.close()
how can i edit that can use for access those password protected Access database
I have been learning about working with databases and VB. I have coded the connection string for a MS Access database to my VB project but i cannot establish a connection with my sql mdf database.
The code i used to connect to MS Access is:
<Dim dt As New DataTable()/>
<Dim match As String = ""/>
< Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
[Code]....
What is the connection code in order to manipulate data from the mdf file. Is it similar to the above code.
My question is how to link database from MySQL2005 with the interface created in Microsoft Visual Studio 2010 Express?Is it possible to link the database into my interface?
View 2 Repliesi am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 Replieshow can i use Ms-Excel as a backend database in visual studio 2008 applications, if is it possible
View 2 RepliesI am developing an app that uses a sql backend database (hosted on a different machine).The app I am developing will be run on 10 different workstations simultaneously.Sometimes the app will change the database in such a way that the database needs to initiate a workflow process and I'm not sure of the best way to do this.Also, when database changes happen, how does one best notify the other app instances that the change has happened, so they know to refresh their data? I was thinking that triggers could help initiate the workflow but it might be nice to develop the actual workflow in .net code.Should I write another App to run as a service on the server and do the work and also to tell the client apps when things change?
View 1 RepliesI'm a bit new to VB.NET and I have a database which I want to connect to an access backend stored on a network drive for multiple users. I can view the Database in the solution explorer and the directory defaults to the project folder. How can I specify the directory to pull from my network drive? VS has copied this datasource and imported it locally which is fine for testing, but i need the file accessible for multiple users. Is this something I do when publishing?
View 3 RepliesHow To on a database driven login form. I'll include the Administration Backend to go along with it soon. Dial-Up users should not use this thread, it is image heavy
[Code]...
So I have this code to make a "windows taskbar". When you click on an item, it's supposed to bring that window to the front. The only problem is that's not happening. When I use Debug.WriteLine, it has the right window title, except it doesn't come to the front. What's wrong? There is no EntryPointNotFoundException or anything, it just doesn't bring the window to the front.
[Code].....
I have some buttons, labels, datagrids, radiobuttons etc. on the front end of an application. Can anyone tell me how to make all the labels visible in the design view even if the focus is removed from those controls. The problem is once the focus is removed from the labels they do not appear in the screen.
View 5 Repliesis there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 RepliesDisplaying an image in front of a node's caption of a treeview. i have an imagelist that contains of images and a treeview containing of nodes. I have also assigned the name of the ImageList control to the ImageList property of the TreeView control, as you can see in the following code. here is the structure of my treeview: Code: even i know that by using the image index and the selected index property i can display the images in front of the node caption of a treeview but i cant do it properly and having a few confusions.
View 6 RepliesI used a picturebox to allow user draw lines by mouse. I used this code in mouse down:
Dim D As New System.Drawing.Pen(DrawingColor, 2)
Dim g As Graphics = PB.CreateGraphics()
g.DrawLine(D, X1, Y1, X2, Y2)
but when a window appear on front of picturebox... its seams that picturebox redraw itself, so drawn lines erased.
Trying to build a front end for a new database I built at work, and I am having a problem.
This code is supposed to try to add a new customer to the database...in the
"btnSaveCustomerToDatabase_Click" VStudio is throwing "Reference to a non shared member
requires an object reference" but I am not seeing it.[code...]
The program I am trying to modify was initially written using VB 2005 Express. I have subsequently downloaded the 2008 version. The program creates a monthly spreadsheet from a template. The old code that will no longer (highlighted and underlined) compile is as follows:
[Code]...
This may be a simple question, but I'm trying to call a a value from table in my back-end SQL Server database and pass it through a querystring in the URL. For example:
I'm building a mobile web site that registers a mobile device to an account on the sign up page. After the database entry is created, I want the to get the generated deviceId from the database and pass it to a querystring in the URL such as: http:[url]....
I have attempted to uninstall VB 2005 express and C++ express using Remove Add programs to no avail. Error message: The Window Installer Package c:program files visual studio 8 vs_setup.msi could not be opened. I have removed the MSDN library and SQL server successfully. I have also tried vs_uninst_betas tool which doesn't find anything to uninstall. I would prefer not to modify the registry if at all possible. If I could find a source for the original install packages for VB and C++ I would attempt reinstalling and then uninstalling....but cannot find them anywhere.
View 4 Replies