 | Trouble connecting to SQL server | |
 | With MS SQL databases, while the server IP is always the same, the connection port is different if you are trying to connect remotely (with SQL Management Studio or similar software) or locally (from a script).
When connecting remotely to MS SQL databa |
|
|
| How To Administer Your Database | |
| Administration of SQL databases can be done in any number of ways; the easiest of these, however, is to use dedicated administration software.
To administer MySQL databases we recommend using MySQL Administrator and MySQL Query Browser. For more inf |
|
|
| OLE DB Connection Strings | |
| OLE DB Connection Strings:
While ODBC drivers are currently available, we nonetheless recommend the use of OLE DB instead. Example connection strings for various database systems are available below:
MS Access:
"Provider=Microsoft.Jet.OLEDB.4.0;D |
|
|
