I want to make a simple application which contacts my MySQL Database located at DazeZone. I do not know how to do this process, never ever got into this with SQL and Databases yet...
View 1 RepliesI have been working on an application that has a built in contact database.I would like to be able to syncronize this with Outlook.
Specifically:
1)Bring Contacts in Custom App over to Outlook
2)Keep info on those contacts syncronized in Outlook and Custom App
3)Ignore contacts that are in Outlook but not in Custom App(ie do NOT bring them into custom App)
i want to connect to mysql located on my website's server in visual basic.
View 1 Repliesim trying to let users login to an application i created in vb.net using the user table of the application's database in mysql i heard that The usual way to do this is to have just one MySQL user called "[my_app_name]" with the relevant permissions. Then my application uses it's own user table to control access to the application, and the one MySQL user to access the database.
View 2 RepliesI'm working on an application in VB.NET that has to connect to a MySQL database and FTP. How secure is it if I used it in an application that I gave to other people. E.g. if I was to let other people use this application would they be able to find out the MySQL and FTP connection details through intercepting packets or something like that? If that's the case how can I work round this? Also, part of my application is an uploader for users to upload files, is FTP secure for that or are there better alternatives ways in doing that? My server is a Windows Server 08 if that makes any difference.
View 2 RepliesI have developed VB2008 application and MySql as Database.I want to Open this application on any web browser without making any changes in Orginal application.
View 8 RepliesI'm trying to make a chat application in Vb what uses MySQL database.
Here is the code for the UpdateChat()sub
Public Sub UpdateChat()
' MySQL Adapter
Dim MySQLAdapter As New MySqlDataAdapter
[Code]....
Now it gives me there error that a connection is allready open with the Datareader (I havea timer running this sub once in a while).
I'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
[Code]...
How can I use code VB.NET to synchronize my Outlook contacts to a database?
View 1 Replieshow can i read from a database like contacts in gmail??Dustin_K "There are 10 types of people in the world: those who understand binary and those who don't."
View 2 RepliesI have default.aspx used masterpage, in master page i have a control called DefaultMenuContent, this control have a dropdownlist with autopostback, the problem is loosing the selection even if i use Is Not PostBack in control's load event, how to persist the dropdownlist selection?
In Master:
<asp:ContentPlaceHolder ID="MenuContentPlaceHolder" runat="server">
<art:DefaultArabicMenu ID="DefaultMenuContent" runat="server" />
</asp:ContentPlaceHolder>
[code]....
i am about develop an application and i want to do the following.
1. use vb.net 2008 for the application
2. use mysql database as the database for the application
Question:
1. is it possible to package the application by adding the mysql database so that during deployment it will be installed as well eg. vb.net 2008 and access database can be attached and deployed without installing any file to support
I am trying to develop an application using VS 2008 connected to MySQL database. Previously in vb6 i was using adodb and now when i googled and got a few sample projects done using VS2008 in which most of the module codes were OLEDB.....To which method should i stick to...?
View 2 RepliesI am building a database application using MYSQL as the backend. The MYSQL instance will be installed remotely on a share host. I have access to SSL certificates. I'm obviously not looking for any code but, conceptually, how do I go about securing the connection using SSL between my application and the remote MYSQL database?
View 2 RepliesI want to update contacts in a database from VB, where the field value is N/A. The following will update all fields where phone = @Phone, however I want to update those fields IF they have N/A in already. Can it be done in SQL?
[Code]....
I have an issue with my code. The application interacts with a MySQL database on a remote server, I have access to this server. When my app is running the insert into code I m getting this error: "Conversion from string "INSERT INTO phpvms_fsspireps(pil" to type 'Integer' is not valid."
The variable which holds the Inser Into string, during break point debug gives me this: ""INSERT INTO phpvms_fsspireps(pilotid, code, flightnum, depicao, arricao, route, route_details, distance, aircraft, flighttime, flighttime_stamp, landingrate, submitdate, accepted, log, load, fuelused, expenselist, source,
[code]...
And this is my code.
Dim conn As MySqlConnection
Dim cnString As String
cnString = My.Settings.constr
[code]...
the DB spec:
Total DB size: 190,1 MB
Total Tables: 106
and the table specs. The titles are in Greek but I think you can understand it from the data. [url]
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 RepliesI've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script etc.
View 1 RepliesI am developing a chat application using online connection to a mysql databbase. But i am facing a problem. After 10 minutes, MySQL closes all the chat connections because of the 600 seconds timeout (has been set by the host service i am using). I don't understand why is that happening cause every piece of my code which needs data from the database opens and closes the connection (i mean that it dosn't maintain the connection after the query's execution). If i .close() and .dispose() the connection, it still appears in mysql at sleep mode (it terminates only if i exit the program).
Dim MySQLCon as New MySQLConnection
Dim MySQLCom as New MySQLCom
Dim counter as Short
[code]....
What i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
I should create a program for a Pocket PC that reads & writes data from an MSAccess database located on a desktop computer (pocket PC and desktop one are connected through a Wi-Fi connection).Is that possible?
View 3 RepliesI have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 Repliesgive me a sample code that works when uploading data from access database into MySQL database...
View 6 RepliesI want to divide the content in my application to groups each group has its own rectangle border with the group name located at the top border, i've seen it before and i'm not sure what is the correct name of this control, anyone knows what I'm talking about ? EDIT: Ok, I found the Groupbox Control but how do i use it? should i just drag other controls inside it or i should add controls directly into it?
View 2 RepliesI developed a vb.net application and TRIED MYsql for database as ( open source). i have to install this application in client machine? As i am new to MYSQL, for deploying MYSQL Database as a Setup installation (With application ) in client machine.
View 1 RepliesI have a application developed in VB.Net on Vista that is running on XP. While running the application on Vista the application works perfectly. While running on XP I get the Microsoft has encountered an error dialog box. Any ideas why I am getting this error.Both XP and Vista machines have .NET framework 2.0 installed. The application is also using calling MySQL. I have installed the MySQL connector 5.0.9. If I do not use MySQL everything seems to work on both XP and Vista machines.
I wish I could give you more information but I just don't know what else to post.
I have tried a listbox and listview so far, but I can not seem to find anything that will let me create a list of items that looks like: [code] I want to make a roster list of contacts with the status image, user name and below the status message. Can you get my on the right track, I can't find what I am looking for. Maybe you know what to search for better?
View 2 Replies