Visual Basic 2005 and MySql
This is a discussion on Visual Basic 2005 and MySql within the Coding Help forums, part of the Webmaster Help category; Did any of you managed to make a connection to live mySql database and how?...
| |||||||
| Register | Forum Rules | FAQ | Donate | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
20-07-2007, 08:34 PM
| |||||
| |||||
 Visual Basic 2005 and MySql Did any of you managed to make a connection to live mySql database and how?
__________________ :. Web Design & Development Web Design Ireland :. Search Engines Optimization Search Engines Optimization :. Directory Submission Directory Submission :. News & Press Release Ireland GiveItSocks.com :. Used Cars Ireland, Car Parts & Car Audio Cars For Sale, Car Parts & Accessories :. I Have 2 Find It Directory SEF Directory         |
TOTW/F/M Award(s): 1
|
20-07-2007, 09:29 PM
| ||||
| ||||
| Using ASP? |
|
20-07-2007, 09:31 PM
| ||||
| ||||
| Here's a snippet of code for connecting to MySQL database using ASP: sConn = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=your.mysqlserver.ie;DATABASE=databa se;USER=user;PASSWORD=password;OPTION=3;"
__________________ David Behan Web Design | Mortgages | Memorial Websites | Digital Printing | Golf Holidays Portugal | Conservatories |
|
20-07-2007, 09:57 PM
| |||||
| |||||
| Tx Dave. Is not for ASP - i did asp for several years. I want to create a desktop application for off-line use. The data resides on mysql server (live server). My idea was to make connection passing few variables, pull the right data in and create a local MS Access db to work with it. When i am finished, upload the data back to the server. That was just an idea. I think I'll be better off working with XML. Have a page on the server (php) to create the XML or csv format, create the local db then send back to the server the data in the same format (XML or csv) for updating the mysql db. |
|
21-07-2007, 03:12 PM
| ||||
| ||||
| what happens if the live database gets updated after you have done the download but before you re-upload. Are you locking the db / using transactions?
__________________ |
|
21-07-2007, 03:30 PM
| |||||
| |||||
| It can't happen and I can not use transaction either. Let me explain why. 100 user, each have their own records(let's say 50 each). when requested we get a copy of his own records, time-stamp them, and populate the local db. each record on update will also update the time-stamp used to compare it with the live data, also they have a unique id. On upload some work has to be done to make sure the data doesn't get duplicated or changed if it doesn't have to. The logic is simple, putting in practise is the hard part. |
|
08-08-2007, 01:19 PM
| ||||
| ||||
| Quote:
Just a question. You're creating this for offiline use but in the next lines you make references to making connections, downlaoding, updating and uploading back to the server. Is it offline or not ? Cheers G |
|
08-08-2007, 02:20 PM
| |||||
| |||||
| it is for off-line but i want to be able when finished to press a button and update the live db and vice-versa. |
Linear Mode
