I'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 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]....
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 have been trying to make a chat application that can go out the local network for quite some time, but all I seem to find is chat applications for in local networks?
View 7 Repliesim trying to make a little application that will read an fps server chat log.the chat logs are plain text files that come in the format :
Billy says: yada yada yada
Bob says: mooo
on certain key phrases (which will be user defined) it will reply (also user defined) now my problems. (there are many). most of which stem from not actually knowing any syntax for this language.firstly im suffering something of a huge brain fart with trying to read only the last line. i have it currently reading though the whole file and counting line numbers but then i just hit a wall . what do i do with the line number? i cant find a simple way to stop and come then have it check again after a couple of seconds for a new line? allegedly filestream can seek the end of the file however all my attempts to do anything with filestream have met with absolutle failure.
this is what i currently have for this, and it works to some degree
FileReader = New IO.StreamReader(OpenFileDialog1.FileName)
Do While FileReader.Peek <> -1
txtln = FileReader.ReadLine()
[code]....
i have the remnants of both the options ive considered in there, and its almost doing what i need it to . i just have no idea what to put into the last section to make it wait for another line to be added to the text file, or use the linenumber to make it check back from there for more lines. i cant seem to find a wait/sleep/pause so i just dont know.
my other problem is one of file access. i am aware of some properties of filestream that allow for a shared read/write access for other programs . however as i stated before . i have had no success even getting this simple peice of code to work with filestream.
I was wondering if its possible to create a chat that runs off of mysql and not a server?
View 4 RepliesI am trying to make a login for vbulletin through a windows application using mysql but whatever i tried has failed, i can connect with the database but i cannot find the password table, since vbulletin has md5 on their passwords.
View 3 RepliesHow to make module to vb.net 2008 and using mysql database
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 am trying to make a login screen that is connected to a mysql database. I cant seem to get it to work it keeps giving me an error that says ("there is already an open datareader associated with this connection which must be closed first")
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class SalePersonLogIn
Dim con As MySqlConnection = New MySqlConnection("Data Source=localhost;Database=testdatabase;User ID=fvfvxcv;Password=cxxvx;")
[Code] .....
I am trying to make a very simple program that connects to a MySQL database using VB.NET. My program only has one form and one label. I setup my MySQL database to have a table and one field (a VARCHAR)called "Tab1". I manually inserted the value "CLOSED" into the Tab1 field using PHPMyAdmin. I want my program to change the value of the field to OPEN/CLOSED and I also want the label text on my form to change too when it's clicked.
[Code]...
I 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 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]...
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 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 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 have a chat server / client system running, but I want users to authenticate with my vBulletin forum database.I don't want the client to do it, because it is possible to fake the 'successful login' and connect with a fake username. I want to send the username and password details to the server, and make the server check it with the local vBulletin MySQL database for the username and password.Is there a way to do this? To my knowledge vBulletin has a username and a password entries in the database which is salted, and the salt varies from user to user.
View 7 RepliesWhat 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 need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
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]......
im trying to make a chat program.im already done with the chat but i dont have any idea now to make the video.
For the chat i used this :(url)
There are a series of web requests, database handling using php as well as using mysql connector. There are at most 5 timers in one window. some window has 3 or 2 timers as needed.Among some features there is a feature for chat. and I'm doing it with Remote mysql connection using mysql data connector.I'm not much familiar with VB.NET coding environment as well as with optimization issues. However made that app running with some problem, that is, when chatting, sometimes its not working smoothly sometimes stops for 4-5 secs then again responding. I'm not sure if this is happening because of timers. However a chat window has 2 timers of 1sec each.
View 2 RepliesIs there anyone here know how to make a chat bot with video?
View 2 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 Replies