DB/Reporting :: Can VB 2005 Front End Running In Win XP Access MySQL Database In Linux Server?
Aug 5, 2008
I 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 Replies
ADVERTISEMENT
Jul 7, 2009
I have a programmer who is using VB and LINQ; and I have a MySQL database that is running on a linux server. My programmer tells me that:he cannot connect to the MySQL database via LINQ if he was able to connect then it would require all sorts of rewriting I don't know anything about LINQ but I thought it was an ORM. As such, any DB server that is supported should work just fine? Right? OK, so maybe it's not an ORM... maybe it should generically connect to ODBC and render similar results?
View 1 Replies
May 8, 2012
We 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 Replies
Mar 27, 2012
how to connect a visual basic front end with a MySQL back end. I am not proficient in VB or MySQL and was not able to find anything on google as a result.
View 1 Replies
Jan 23, 2009
Is there a way for my program to send Linux Console Commands to a remote Linux server?
View 4 Replies
Apr 14, 2011
How to use MySQL database instead of SQL Server 2005 in asp.NET 3.5 ?
And how to create the membership tables in MySQL database as in ASPNETDB.MDF
View 1 Replies
Jul 8, 2008
For years now I have been using access as my database. But with the SQL server Express version around I have been wondering if it is not better to use this instead of access. Note: I only develop applications for small businesses and a limited set of users. So what do you guys prefer and recommend?
View 2 Replies
Apr 18, 2011
Im new on this forum here, i have already browsed many topics but i really didnt found a answer on my question.
I want to connect to a web-based linux SQL server. Is there a way to do that? Or do you have to use the Microsoft SQL server?
View 2 Replies
Dec 3, 2011
I am using Visual Studio 2010. I want to do database connectivity using VB.Net and MS SQL Server 2005. I know 1 way of doing this. Following are the steps...
1. Create a new Data Source Using Data Sources Window.
2. Select the appropriate view like details view/ data grid view for that data source
3. Drag that data source on your form and connectivity is done. Also all the controls are created by the visual studio.
This feature is really cool but I want to learn database connectivity by pure coding without using such advanced features. Also is it possible to do connectivity from a class library ?
View 3 Replies
Dec 8, 2009
I have developed a Windows Forms application using VB.NET and MS SQL Server 2005 Express Edition. My database name is 'AC'. I do not want ANY user, SQL Server or Windows authenticated, to access, read, write to, update, drop or take backups of this database, except this login 'Adel'. So my connection string looks very similar to:[code]What configurations should I make in the MS SQL Server Management Studio 2005 Express Edition to 'Adel' login, 'AC' database, and all other logins to accomplish this?Given the following:I do not own the server; my client owns the server. They have a domain set up (LAN network).They have ASP.NET applications running using other databases on the same server. However, these applications have nothing to do with my database 'AC' or login 'Adel'.Some of their applications do not specify 'User Id' in the connection string; they use 'Integrated Security=True'.
View 2 Replies
Aug 21, 2008
I'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?
View 3 Replies
Jan 20, 2010
WIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?
View 2 Replies
Sep 2, 2010
I'm looking for a front-end that's very simple, to access a to-be-built MySQL Database. I actually need it for only one table. I was thinking that the user could search in a way that would ask for values for each field of that table, and give the option of leaving it blank. Then, it would return all the entries that match up with the query.
View 3 Replies
Sep 23, 2011
I've been researching for days and I've gotten to the point where my WCF service creates an Access object via com/interop.I've ran the Open Current Database call for the Access object without an error but Application.CurrentDB is still nothing/null. If the CurrentDB is nothing then I surely can't call Application.Run "myFunction" I realize WCF services aren't meant to be user interactive, but it's a long story why I'm trying to go this route. Basically I need to have a proof of concept ready sooner rather than later and the alternative (correct) route involves the complete re-writing of a large complex access VBA application. It's not a permissions issue, I have the IIS user names added to the security tab. What I really need is a way to set Environment.UserInteractive to true so my WCF service can create an instance of Access on my server machine, run the VBA functions, close out, return true.I'm using VS 2010 for the WCF, IIS 7 for my server, Access 2010 for the VBA application.
View 1 Replies
Feb 21, 2008
I am trying my hands on VB.net and is trying out a small application which includes a survey form. The form contains radio buttons and when the respondent clicks on a radiobutton, digit '1' should be placed into the relevant field of the database.I have established a dataset and tried doing it but not sure how to do it because the book (How to program Visual Basic.Net by Dietel) does not teach us that
View 1 Replies
Oct 26, 2009
is 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 Replies
Oct 17, 2008
I'm confusing between SQL Server and MYSql and Sql Quries Is the SQL Server database like access and Sql Quries is the language Sql like Select * From Table1?
View 1 Replies
Mar 9, 2010
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 Replies
Jul 31, 2008
My website connects to a Microsoft Access DB at the moment, im about to upload it to the internet - its a VB.NET web application but i'm advised to convert it to MySQL or MSSQL for better performance.How would you recommend I export the DB ? there isn't too much data in at the moment so mainly all of the tables and fields.
View 2 Replies
Jan 9, 2010
I am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard .
View 1 Replies
Jul 26, 2011
I am creating a medical record system using MS Access 2007. the finish product will be used for a small healthcare which has only one available pc for now i ve done all required tables and some queries. What I really want to do is to design the forms where user can access information using VB 2010. I ve read tutorials online about how to connect dataabase to vb and successfully did that.
[Code]...
View 3 Replies
Jul 15, 2008
I have an Access XP database with two linked tables and a maketable query. I need to first run the Query through VB 2005 and then get the data from the resulting table created. But I get an error when I run the query as follows. I am getting the SQL Select statement from the SQL view in MS access after I create my Maketable query So it should be ok. I am saving the select in a hidden text box on my form.The query text :
SELECT [SWX-Seats].[Asset #], [SWX-Seats].Account, [SWX-Seats].Product, [SWX-Seats].[Seat Id], [SWX-Seats].[Serial #], [SWX-Seats].Qty, [SWX-Seats].[Entitlement End Date], [SWX-Seats]![Entitlement End Date]-[NS-Seats]![Exp Date] AS DaysDiff, [NS-Seats].[Exp Date] INTO
[code].....
View 2 Replies
Apr 24, 2011
I can connect/login to my database, view a formatted table in the current window, however I want to click a button and see a new table set in a new window. Theoretically I should be still logged in/connection information saved but however I get 'unable to connect to database'.
View 2 Replies
Jan 6, 2011
I have a MySQL database online. What do I need to connect to it and exchange data?
View 2 Replies
Jun 16, 2009
i am trying to save image into MySQL database ...is there any easier way to do that ?
View 1 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Jun 23, 2009
I am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
View 3 Replies
Apr 28, 2010
i am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
View 1 Replies
Nov 18, 2009
I have a problem here I did make database program for a friend the database is online Mysql I use Visual Studio and put this into setup.exe when he install the program and try to log on he get this error This is my connection to the database
[Code]...
View 1 Replies
Aug 28, 2011
Is it possible to implement an ASP website written using VB Script on a PHP MYSQL server. Maybe their is a php interpreter that can parse the asp files or something like that?
View 3 Replies
