First, I'd like to know, in MySQL, when is it more secure and appropriate to close the connection and also why we have to close the connection. The software protection also came to my attention. Is it possible to protect a .exe from being decompiled with any .net decompiler?
View 3 RepliesI just used a Hex editor and in about 10 seconds i got the source code. How can i protect my self form the decompiler?I looked on Google but all i found are third party application. What do you use to protect your software?
View 7 RepliesThere are some VB decompilers out there. How can I make my program unhackable if decompiled, or maybe turn everything into random characters?
View 7 RepliesI was wondering if someone could translate this code into a more understandable code. It is suppose to be a function that accepts an item name its cost and its quantity. and adds one more array element to ."items" variable and assigns the given name and cost and quantity.
Public Sub AddItem(ByVal strName As String, ByVal dblCost As Double, ByVal intQuantity As Integer)
Me.items=DirectCast(Utils.CopyArray(DirectCast(Me.items,Array),New Purchase(me.itemsCount + 1)-1){}),Purchase())
End Sub
This is the translation i made but i don't think it is correct.
Public Sub AddItem(ByVal strName As String, ByVal dblPrice As Double, ByVal intQuan As Integer)
Dim items As Purchase() = Me.items
Dim itemCount As Integer = Me.itemsCount
For itemCount = 0 To items.Length - 1
[CODE]...
I'm making a winforms app in vb.net that connects to a mysql database on my webserver to read and write data, this all works fine.But i have to allow the users ip to remote connect to the database.Is it possible to give everyone access to the database? The user account will not have all rights an the data isn't very important if it got lost.The user account and connection details are hard coded.
View 3 RepliesHow to connect using MySQL connection?
View 1 RepliesPrivate Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim MyConnection As New OdbcConnection("Driver={MySQL ODBC 5.1
[code]....
I was wondering is it possible to use C#/++ and php to connect to a mysql database? I ask because seems my host doesnt have remote access setup for me to access my database.
View 1 RepliesI'm being able to connect to mysql database in localhost. But not able to connect in my server?
View 1 RepliesI'm trying to connect to a database but it doesn't work...
Code:
Dim conn As MysqlConnection
conn = New Mysqlconnection()
conn.ConnectionString = "server=http://www.*****.net/phpMyAdmin; user id=*****; password=****; database=login"
[Code]...
I created a mysql database and I want to connect to it through VB.Net 2008 using MySQL Connector Net. For this I made 3 forms, 1 form - login form, 2 - as ADMIN, 3 - from USER, the database each user has a role defined by regimes (admin / user). The problem is the following - after entering the username and password will not open one of the forms 2 or 3 but the application closes without any error.The code is:
vb.net
Imports MySql.Data.MySqlClient Public Class Form1 Const AppName = "MySql" Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[code].....
so ive drank goats blood, sacrificed a virgin to the gods and more and im still not any closer to connection to a DB in vb.net (something that takes about 2-3 lines on code in a sensible language)....
Imports System
Imports System.Data
Imports MySql.Data.MySqlClient
[code].....
I'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
I want to connect mysql database with vb.net 2003I install mysql and add referance MySql.Data. When I try to use following connection script which is very common: conn.ConnectionString = "server=localhost;user id=root;password=1234;database=test_1" am getting error 1042. server connection errorWhen I use Mysql Workbench for mysql data browsing. I can connect database with Local Socket/Pipe connection method. Standart TCP/IP method is not working, because I do not use any network just work on local machine.
View 4 RepliesI'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases.I've been following this tutorial from page 3 on, as the first 2 pages where on how to initialize a local MySQL database.My MySQL database is on my website, so I thought I had to use the website's name instead of "localhost". Anyways, I now use this code:
Dim connection As MySqlConnection
connection = New MySqlConnection()
connection.ConnectionString = "Server=resload.com; Uid=***; Pwd=***; Database=***;"
[code]....
But it popups (don't now whether that's a real word :p) with the message:Error Connecting to Database: Access denied for user '***'@'my ipaddress' (using password: YES)?
I get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*' at line 1 [Code]
View 14 RepliesI am trying to get connection to MySQL DB through the MS Entity Framework and I am not able to. Yes, I can connect to the DB otherwise, using conventional MySQL Connector 5.2.2. I am using vs 2008 and the VS SP1. I have added a VB Forms Project. Now, when I try to add a New ITEM and choose ADO.NET ENTITY DATA MODEL, it asks for the Datasource. Now, here it lists only SQL Server and I do not see the MySQL option at all. I have added the Mysql.data.dll to the project as a reference. Nothing seems to get me the link to the DB via the Entity Data Model Wizard...
View 2 Repliesregarding vb 2008 as below 1.how to make connection between mysql and visual basic 2008. 2.how to write insert the query.
View 2 Replieshow to create modules and consequently how to use them.I need to do a database in mySql from vb.net. I have tried the usual way, that is my connecting to the database at the beginning of each of my class. I want to know if that can be done through modules, as far as i have read about that or some other way like procedures and functions. In that way, it could ease my coding in not having to write the db connection each time.
View 4 RepliesIn the first form I will load Tabels in the secound I want to open the DB Connection. I wrote a Class which enables me to open and close the connection
[Code]...
connect to MySQL to create a database in visual Basic 2008
View 11 Repliesi would like to ask where is the best place to save a mysql connection string.i want to be able to change the connection string(host,username,password) during runtime so if the server changes IP address i can change it.
View 10 RepliesI'm trying to connect to my MySQL database I have online at (mywebsite.com), however it just hangs for about 30 seconds and says and does nothing.
Dim sConnection As String = "Server=mywebsite.com;Database=mydatabase;Uid=myusername;Pwd=mypassword;"
Dim scConnection As New SqlConnection(sConnection)
Dim scCommand As New SqlCommand("SELECT * FROM mytable WHERE user = @user AND password = @pass", scConnection)
[Code]...
I'm guessing the connection string is wrong, I'm going to try the server as localhost, but in the mean time hopefully someone might see what I might be doing wrong.I'd also like to look into doing it asynchronously, so the UI doesn't freeze,
I want to add a new Data Source (so I can use it with Crystal Reports) but using mysql, I did this before.
In the left side under: 'Data Sources' and then choosed 'Add New DataSource'Then I choose: Database > Dataset I clicked in 'New Connection' and I changed the first box (with 'change' button (as you can see in the image attached)) to what is showed in the image (MySQL Database..)The problem is, as I type the first letter of any of the textbox's that are below (server, user, or pwd) it closes that form showing the previous form (where I clicked 'New Connection')
Have someone had this problem ?I had a connection there, but since I changed the project from 'Framwork 4 Client Profile' to 'Framework 4' (so I could have the Crystal Report Viewer) the connection has gone and don't leaves me create it again.PD: I'm using dotNetConnector (already Added as a Reference)
My program needs to connect to a mysql db, but if the users has no internet or fails to connect i don't want my app to crash
View 4 RepliesI have created an exe file. i am now worried whether my exe file will be decompiled using some vb.net decompilers.(sample coding) for some exe file named "hello.exe" to prevent the hackers from decompiling it. how to restrict the use of decompiler.i now want to make my code, invisible (or) not traceable (or) not understandable. even if it is decompiled.Also i came to know that , it is also possible to remove the obfuscation from the exe file.. so that the actual goal to trace the code is possible...
View 1 Replieswith this Program [URL] People can see the code and password, how can I defend against it?
View 15 RepliesHow can I call the connection string by name from an app.config file in my vb.net program?
View 1 RepliesMy system use to run on from a access database. Now I created the database on a MySQL server.I can connect to it using the connection wizzard, but I prefer using my old methods as shown below.[code]...
Does anyone know how to hardcode a connection and selection like I use to do with access, but only in MySQL?
this is code where i want to insert ConnectionString=<%$ConnectionString =""%>[code]....
I can not connect MySql (SQL YOG) at all to this control, this is prob from .net control and not MySqlMark the thread as answered