Member Avatar for master_mind187

Hello.,
i have sql server in my pc and i want to connect my visual basic form to my sql? how can i do that? what is the code i have to write in the modules? please help

Thanx in advance...

  • 3 Contributors
  • 2 Replies
  • 103 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jireh

Dani AI

Generated

— the key decisions are which Visual Basic you are using (classic VB6 vs VB.NET) and which server (SQL Server vs MySQL). and were right to point out that a correct provider/driver and connection string are required; below is a concise, practical outline and a ready pattern you can adapt.

For VB.NET the recommended pattern is to use the built-in SqlClient (for SQL Server) or the official MySQL Connector/NET (for MySQL). Open connections as briefly as possible, use parameterized commands to avoid SQL injection, and always dispose connections (the Using block handles that cleanly). Example pattern for VB.NET:

Using conn As New System.Data.SqlClient.SqlConnection("Server=localhost;Database=YourDB;Integrated Security=True;")
    conn.Open()
    Using cmd As New System.Data.SqlClient.SqlCommand("SELECT * FROM Users WHERE Id=@id", conn)
        cmd.Parameters.AddWithValue("@id", 1)
        Using rdr = cmd.ExecuteReader()
            ' process results
        End Using
    End Using
End Using

Troubleshooting checklist: confirm the server accepts TCP/IP connections and the correct authentication mode, ensure firewall and SQL Browser (for named instances) are configured, verify user privileges, and test connectivity with a DB client (SSMS or mysql client). For implementation details and API reference see Microsofts SqlConnection docs: SqlConnection (System.Data.SqlClient), how to enable network protocols for SQL Server: Enable or disable a server network protocol, and the MySQL provider docs: MySQL Connector/NET.

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

use ADO and find the Connecting string here.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.