I'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 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 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?
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 RepliesI'm trying to allow users to update their details after logging in on an asp site using vb. Textboxes are populated with user details using session variables in the form_load. The textboxes should be editable but for some reason are not registering the changes when the submit button is clicked.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Txt_Fname.Text = Session("First_Name")
Txt_LName.Text = Session("Last_Name")[code]..........
I am thinking of creating a code to allows my project to pass through the port forward without the outcoming connection details being pass on the third party software such as packet sniffer.Is it possible to avoid packet sniffer to pick up the outcoming connection details?
View 2 RepliesI'm creating an application that uses SQLite (using the SQLite.Net adapter) as its database engine. Since some of the data stored in the database is sensitive I've encrypted the database using the SQLite.NET built-in encryption, and then to open the database I've to do something like this:
vbnet
SQLiteconnection.ConnectionString = "Data Source=" & DataBaseLocation & ";" 'Set the connection string
[code].....
We are developing an application in VB.NET 2008. We break the application into smaller multiple dlls so that we can easily update the program at the customer end.We want to know that is their any way to stop the other person to use my dll in their application?i.e we want to lock the dlls such a way that the dlls will be used by us only and not anybody in their application.Also we want to block viewing of dlls code using any code reflector
View 4 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]...
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 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 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]....
odbc driver not found unable to connectmysql 5.1 odbc already installed and i have the following code to connect mysql
Imports System.Data.Odbc
Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" + "DATABASE=apdata;UID=root;PASSWORD=acelle;Port=3306;"
[code].....
We have a current implementation of a log file manager where it's two main purposes are to 1. rename files generated by other programs with a date/time stamp so they create new ones, and 2. delete files older then X amount of days from a specified folder. The program also makes it's own log file which records when these events happen.Do you think the Logging Application Block would be useful in this instance? The old file manager is written in VB 6.0 and an upgrade to VB .Net would not take too long, but is it worth it to try and implement LAP into it?
View 1 Repliesi'm developing a web application. i want if user access it, it will prompt for windows authentication, if the username and password is correct, then the page appears.i've been working around on this but it's not working. my web app prompt users for windows authentication, but it always failed or access denied.anything i should check?
View 1 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 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'm using a timer to open a database and drop in a few fields of info, such as date, time and 3 traces.
the timer interval is set to 1000msec, but after its been running for a day or so, i've looked into the data and i can see there are periods where no info has been logged. sometimes its as little as a couple of seconds, and other times its upto a couple of minutes.
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 am using logging application block for EL 5.0. I defined listener like below.
<add name="FlatFile TraceListener" type="Microsoft.Practices.EnterpriseLibrary.
Logging.TraceListeners.FlatFileTraceListener,
Microsoft.Practices.EnterpriseLibrary.Logging"
[Code].....
Using visual studio (Winforms) with sql server (R2). If you can login by inserting the correct values in the textfields (vb.net) that is connected in the database . How do i code the log out?
I have 4 Tables Master And Three Tables Details
how to programming this Technique
This Picture dispaly what i mean http://img300.imageshack.us/img300/3981/26072009110315.png
I'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 Replies