I use visual basic 8.0 en MySQL.I have a connection witho my MySQL database "test" with Myconn.I have two table's :
Rental
Articlenr Articledis Articlerent
100 beerclass 15
200 wineclass 10
[Code]...
MVC3, VB.NET, using EF. I am working on coding up a simple function to handle checking for a valid MySQL connection. If the connection fails the test it will use the secondary server connection. This is required because our hosting provider does not provide failover or redundant MySQL servers. The problem is I tried to use a simple try catch method in the HomeController. This fails early because the Entity Framework is looking the connection that was set up when I set it up... Is there anyway to control that connection dynamically?
View 1 RepliesI have some questions about mysql database; I have set up columns and rows on mysql database and I would like to make mysql connection for a test before I would release the project in the near future, but my doubts is that how would I be able to keep mysql admin username and password details secure in the project without anyone could find out??Secondly, I don't want anyone to crack my project to get the details, which it will put me and other clients at risks.
View 22 RepliesI am new to Visual basic and am using visual basic 2008 to write programs in, I have setup a database connection and the connection string is currently stored in the settings section of the project.I would like to have a menu item where when the user selects "test database connection" it will run the sub for testing if the database is established.
View 2 RepliesI am having a problem with a unit test I have created. First time doing this so I am not sure why I am getting this error [code]Test method ETDS_Unit_Tests.LoginTest.ValidateUserNameTest threw exception: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).This is the same connection that my software is using, and the software runs fine, only the unit test is failing. What I am doing wrong? It Seems to fail one time for each datarow in the table.Also, I am using a Linq Query in the method that I being tested. I believe that this may be what is causing my error.
View 2 RepliesI just bought the MCTS Self-Paced Training Kit (Exam 70-561): Microsoft.NET Framework 3.5 - ADO.NET Application Development, and am trying to do the Lab Exercises now. Allready at the first exercise (point 8), where I am supposed to make an "UNIT TEST",[code]
View 5 RepliesI've set up a test database to begin unit-testing an app that I've recently been added to. It is a 3-tier design (presentation layer, BOL and DAL) and this is my first time writing unit tests. I've decided to start at the BOL and I figure the best way is to swap out the ConnectionString (which has been passed along as a Shared String) with one that points to my new test database. However, I don't wish to change any production code. I simply wish to somehow redirect the app to the test database during unit tests.
View 4 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'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'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)?
how 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 Repliesconnect to MySQL to create a database in visual Basic 2008
View 11 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 am having and issue with showing my database in another form. It works fine if I have it display in the current form but this is not what I want. I want to connect to the database and then have it show my query in a second form. If you don't get me here's my code.
CODE:
And then the code in form 2 is
CODE:
It comes to the error when it gets to "ContactsAdapter.Fill(ContactsData)".
I'm wondering if I create a program that connects to a mysql database, will they be able to decompile it and do anything with the mysql connection information?
View 18 RepliesWe have a VB6 program that uses an ADODB.Connection to establish a database connection and use its execute function to run SQL statements. The connection we have established is to a SQL Server. It has been working fine. Currently, I am trying to change the connection to a MySQL database. I changed the connection string and the connection is ok.
However, when it comes to running the execute function, it returns a runtime error 3246 - connection object cannot be explicitly closed while in a transaction.
I checked the connection.status before calling execute and found that it is open. When I use MySQL's server connections to check the status, I found that there was a connection before and after execute was called.
I encountered this same error whether I used MySQL ODBC 5.1 Driver or MySQL ODBC 3.51 Driver.
I 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 some software that grabs information from a mysql server. However, users minimize it to the system tray, and leave it idle for hours until using it again.If a user leaves the program idling for about 15 minutes, then goes into the program again to perform a query, it throws a Fatal Error in the mysql, and says 'connection must be valid and open'
The reason is simply because the mysql connection has timed out..I was wondering what the code would be to re-connect to the server IF it has timed out.
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 used code below at end of one function. Does need "myConn.Close()" before "return true"?
Using myConn
Try
myConn.Open()
[CODE]...
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 fill a datatable using the dataadapter. and i set the adapter.missingschemaaction = missingschemaaction.AddwithKey. i set the insertcommand,updatecommand and deletecommand for the adapter as well.however, when i click on the datagridview to add new rows a new temporary primary key is not generated in my datatable.I've done this with access and sql server 2005 with no problems. im using MySQL.Net connector 6.1.2
View 4 RepliesWhat is the best way to check if a web service is up and active? I realize there are many different factors to this, but I would like to do something simple before sending data, like at the moment the proxy is constructed to see if the service is able to be connected. I am coding in vb.net.Is there even a best practice for this type of comm?
View 1 RepliesI want to test whether the connection string is valid or not?What should I do ?
View 18 RepliesI need a simple snippet that will allow the user to test the connection for the FTP server entered in a textbox and the username and password from 2 other textboxes. (Server = TextBox1.Text, U/N TextBox2.Text, PW TextBox3.Text) I forgot to note something obvious - there's a "Test FTP" button
View 2 RepliesI 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 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 RepliesI'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 Replies
