Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL

by Raghuraja.C (12 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 7^th March 2003
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL




   'For SQL Server Driver
   BuildSQLCon = "driver={SQL Server};database=databaseNAme;server=ServerName;uid=UserName;pwd=Password
   
   'For Oracle Driver
   BuildSQLCon = "Provider=MSDAORA;Data Source=DatabaseName;User ID=scott; Password=tiger;"
   
   'For mySQL Driver
   BuildSQLCon = "driver={MySQL ODBC 3.51 Driver};server=ServerName;uid=root;pwd=root;database=databaseName;option=NUM"
   
   'For MS-Access Driver
   BuildSQLCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & app.path & "/databaseName.MDB"

Download this snippet Add to My Saved Code

Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL Comments

No comments have been posted about Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL. Why not be the first to post a comment about Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL.

Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL

Simple string for DSN Less connection using SQL Server, MS-Access, Oracle and MySQL Comments

Post your comment

Difficulty