• Home
 · 
• Miscellaneous
 · 
• 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

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

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

   '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"