Philhosting.Net | Internet Articles | Updates | Tips & Tricks

Oracle connection strings

Oracle ODBC connection strings Open connection to Oracle database using ODBC “Driver= {Microsoft ODBCforOracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;” Oracle OLE DB & OleDbConnection (.NET framework) connection strings Open connection to Oracle database with standard security: 1. “Provider=MSDAORA;Data Source= Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;” 2. “Provider= OraOLEDB.Oracle;Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;” Open trusted connection to Oracle database “Provider= OraOLEDB.Oracle;DataSource=Your_Oracle_Database;OSAuthent=1;”

Continue reading...

MySQL connection strings

MySQL ODBC connection strings Open connection to local MySQL database using MySQL ODBC 3.51 Driver “Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3″ MySQL OLE DB & OleDbConnection (.NET framework) connection strings Open connection to MySQL database: “Provider=MySQLProv;Data Source=Your_MySQL_Database;User Id=Your_Username; Password=Your_Password;”

Continue reading...

MS Access connection strings

MS Access ODBC connection strings Standard Security: “Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\App1\Your_Database_Name.mdb;Uid=Your_Username;Pwd=Your_Password;” Workgroup: “Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\App1\Your_Database_Name.mdb; SystemDB=C:\App1\Your_Database_Name.mdw;” Exclusive “Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\App1\Your_Database_Name.mdb; Exclusive=1; Uid=Your_Username; Pwd=Your_Password;” MS Access OLE DB & OleDbConnection [...]

Continue reading...

SQL Server connection strings

This is a compiled connection strings reference list on how to connect to SQL Server. ODBC Standard Security Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Trusted connection Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes; Prompt for username and password This one is a bit tricky. First you need to set the connection object’s Prompt property to adPromptAlways. Then use the connection string to connect to the database. oConn.Properties(”Prompt”) = adPromptAlways Driver={SQL Server};Server=myServerAddress;Database=myDataBase;

Continue reading...