DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Database Connection Help

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Apr 2009

Posts: 2

Reputation: olabaz is an unknown quantity at this point

Solved Threads: 0

olabaz

Offline

Newbie Poster

Database Connection Help

Apr 23rd, 2009

I am trying to connect to a database but I have no clue how to do it or if it's even possible. The server address is: sql306.byethost5.com
How would I connect to this server if the username is usn and password is pwd?

•

Join Date: Nov 2007

Posts: 140

Reputation: jonifen is an unknown quantity at this point

Solved Threads: 15

jonifen

Offline

Junior Poster

Re: Database Connection Help

Apr 23rd, 2009

Is it a MySQL database?
First you'd need to make sure your host allows connections from outside of their network (I mean this as in my friend's host SQL server only allows internal connections from his webspace or PHPMySQL Admin page - he can't use MySQL admin tools or anything on his PC)

You would need to check out http://www.connectionstrings.com when you know what SQL database system it is using (MSSQL, Oracle, MySQL etc)

•

Join Date: Apr 2009

Posts: 2

Reputation: olabaz is an unknown quantity at this point

Solved Threads: 0

olabaz

Offline

Newbie Poster

Re: Database Connection Help

Apr 24th, 2009

It's a MySQL database. I'm not sure I'm using the right code.

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
      Imports System.Data.SqlClient
 
      Public Class Form1
 
          Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
          Dim sqlConn As New SqlConnection("server=serverAddress;uid=username;pwd=password;database=database;")
 
      sqlConn.Open()
 
     sqlConn.Close()
  End Sub
 
      End Class
      Imports System.Data.SqlClient
  
      Public Class Form1
  
          Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        
          Dim sqlConn As New SqlConnection("server=serverAddress;uid=username;pwd=password;database=database;")

      sqlConn.Open()

     sqlConn.Close()
  End Sub

      End Class