Read and write File ODBC data sources
September 2, 2000
A file DSN is nothing but a text file that contains all the parameters for an ODBC connection. To prove this, just go to the default directory that holds all
Menu
A file DSN is nothing but a text file that contains all the parameters for an ODBC connection. To prove this, just go to the default directory that holds all
If you try to use a DataList and some labels or text boxes linked to an ADO Data control, and you click on some items in the list, you’ll notice
The syntax for opening a password-protected Jet database might not be obvious. In fact, assigning the password to the Password property in the ConnectionString raises the following error: Run-time Error:
Suppose you have two tables named Table1 and Table2 with one or more fields named the same way. Now, consider this query: rs.Open “SELECT * FROM table1 INNER JOIN table2
When working with a forward-only, read-only Recordset – that is, the default ADO Recordset – the RecordCount property always returns -1. (This can also happen with other types of server-side
When you use JIT activation in particular there is a special situation that you have to be prepared for. While discussing that issue, I will also show a trap when
o briefly recap the situation I described in “All the Changes, All the Time: Part I“, my assignment was to capture all the changes being made in one database and,