Visual Basic Source Code - Tutorial

How to Connect Database Using ODBC (Object Database Configuration/Connectivity)

Published on 2011-06-29 05:33:00

This ODBC method is applicable to Visual Basic .Net and Visual Basic 6.0 using MS Access Databse (.mdb). Please follow the instructions below on how to setup database. 1.  Click Start button, and select Control Panel 2. Once the control panel open, please double click Administrative Tools. Note: If you can't locate the the administrative tools, please select Classic View at the left side of the control panel pane.             &

Connection Strings for SQL Server 2000 and 7.0

Published on 2011-06-29 02:51:00

.NET Framework Data Provider for SQL Server Standard Security Data Source=ServerName;Initial Catalog=DatabaseName;User Id=UserName;Password=Password; Standard Security alternative syntax Server=ServerName;Database=DatabaseName;User ID=UserName;Password=Password;Trusted_Connection=False; Trusted ConnectionData Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI; Connecting to an SQL Server instance Server=ServerNametheInstanceName;Database=DatabaseName;Trusted_Connection=

ADO Control to create Database Table using Visual Basic

Published on 2011-04-07 07:31:00

'Using ADO control to create a database table from Visual Basic'Connect to the database file and use the Connection object's Execute method to 'execute an SQL CREATE TABLE statement. Private Sub BtnCreate_Click()    Dim db_file As String    Dim Conn_Data As ADODB.Connection    Dim rs_Data As ADODB.Recordset    Dim num_records As Integer     ' Get the database name.    db_file = App.Path    If