Reusing MySqlConnection.serverString

Question

Say I have a connection to a database. After reading some stuff I want to connect to the same database. So I naturally use the first database mysqlconnection.serverstring

Well guess what, the password and username is not included in connect1.ConnectionString. So how can I do so? Is this by design?

      Using connect1 As New MySqlConnection(ConnectLocalhost.serverString)
            connect1.Open()
bla bla bla
                Using connect2 As New MySqlConnection(connect1.ConnectionString) ' this won't work
                    connect2.Open()
                End Using

Tony Hopkinson · Accepted Answer · 2012-06-20 20:33:30Z

1

You need to put Persist Security Info = true in your original connection string otherwise it won't be read back.

Course if you do that you might as well not have a user name and password...

edited Jun 20, 2012 at 20:33

answered Jun 20, 2012 at 17:42

Tony Hopkinson

20.4k3 gold badges35 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Moshe L · Accepted Answer · 2012-06-20 17:43:26Z

1

Store your Connection String in your configuration - as It need to be changed outside the code (for example - production vs development).
Write an function that returned a active connection or wrapper object, so you can use:
```
Using MyHelper.GetConnection()

   ...

End Using
```
In this way, you can use connection and close it, as the connection pooling save the connection for later use.

answered Jun 20, 2012 at 17:43

Moshe L

1,9051 gold badge16 silver badges21 bronze badges

Comments

blearn · Accepted Answer · 2012-06-20 17:32:13Z

0

Can you not just re-use your original connection? Unless you have explicitly closed it, you should still have access.

answered Jun 20, 2012 at 17:32

blearn

1,21811 silver badges17 bronze badges

2 Comments

Tony Hopkinson Over a year ago

Depends on a few things that, and it shouldn't be the default way to go.

blearn Over a year ago

@Jim Thio : you are mistaken - one connection can definitely be used multiple times. It is a instance of an object referencing your database (hence the 'new' keyword).

Collectives™ on Stack Overflow

Reusing MySqlConnection.serverString

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related