Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips


1-20 of 72     Previous     Next
Determine Whether a Field Exists in an ADODB.Recordset
by Shawn Dorman
Unless you populated a recordset yourself, you may not know whether it contains a particular field.
Connect to SQL Server Using ADODB Retrieving Records
by Yatin Karekar
This tip will show you how to connect to SQL Server using ADODB Retrieving Records using Record Set and connecting it to Crystal Reports.
A Fabricated ADO Recordset
by Kamesh S
CheckOLEDBProvider - Check whether an OLEDB provider is registered correctly
by Marco Bellinaso
Check if the specified OLEDB Provider is installed and registered correctly Example: check the Jet 4.0 OLEDB Provider MsgBox "The specified OLEDB provider " & _ IIf(CheckOLEDBProvider("Microsoft.Jet.OLEDB.4.0"), "does", "does not") & " exist" NOTES: Requires CheckRegistryKey and ...
Saving an array to a SQL Server table with VB and ADO
by Francesco Balena
Persisting an array of data in a SQL Server DB is usually considered quite difficult. The common solution is to use a master detail table, but this leads to a waste of space and overall decreases performance. Here we'll see how to save an array with VB and ADO. Create the destination table ...
A dual use of a lookup query
by Vito Vessia
Usually in your application you use two different types of lookup query; the first one is for retrieving a page of records (or all records) to populate a pick list, the other one is to retrieve a single record, i.e. for decoding a code description while user is typing it in a textbox. So, if ...
CUDL - A class to create UDL files
by Gordon Gong
A class that creates UDL files for use as ADO Data Sources. Universal Data link files are handy for select data sources but there are lack of a way to create/edit this files. The little program i attached teaches how to read/write a UDL file. IMPORTANT: requires that you add a reference to ...
Read and Write UDL files
by Gordon Gong
Universal Data link files are handy for select data sources but there isn't a way to create/edit this files. This little class shows how to read/write a UDL file. '----------------------- ' The cUDL Class '----------------------- 'please visit www.shoutsoft.com for Tools building ...
Close Connections When You Are Finished With Them
by Trong Ha
By proactively closing connections when they are no longer needed, you reduce demand on the database server and make resources available to other users. Connections are closed when they go out of ...
Increase Connection Throughput By Requesting Multiple Records At Once
by Trong Ha
By default, the CacheSize property of the Recordset object is set to 1 for all cursor types. By increasing the CacheSize, you can increase the number of records the provider will retrieve at one ...
BlobToFile - Copy a BLOB field's contents to a binary file
by Francesco Balena
Copy a BLOB field's contents to a binary file.
CloneFieldStructure - Create a new Recordset with same field structure
by Francesco Balena
Copy the field structure of a Recordset to a new Recordset. The original code has been improved to account for Numeric and Decimal fields, that also require the setting of Precision and Numeric Scale properties. Thanks to Robert Gelb for this suggestion.
Create UDL files the easy way
by Scott Hutchinson
The standard way to create a UDL file is to right-click in the directory where you want to create it and select the New-Microsoft Data Link menu command. Unfortunately, on many computers, this manual procedure won't work, because the file type "Microsoft Data Link" does not appear on the "New" ...
FileToBlob - Copy a file's contents into a BLOB field
by Francesco Balena
Copy a file's contents into a BLOB field.
Use adExecuteNoRecords in the ADO Command Object to Boost Performance
by Andrew Holliday
If you need to execute a stored procedure from a Command object, and the stored procedure will not return any rows, you can boost performance of the Command object by setting the ...
MTS Objects Containing ADO
by DevX Pro
I have an MTS object that contains an ADO connection object which I use in an ASP page. I look at the MTS console and confirm that the package gets activated, and I use ODBC performance-monitoring counters to verifty a connection gets pooled. But when I manually shutdown the component or let it idle timeout, I notice the connection gets closed also. Shouldn't the ADO connection object stay around after the MTS component gets destroyed, since the ODBC idle connection time is higher than the component idle time?
Determine the RecordCount of a forward-only Recordset
by Francesco Balena
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 cursors, depending on the specific OLEDB provider.) In general, you can determine how many records were ...
Open a password-protected MDB database with ADO
by Francesco Balena
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: 2147217843 (80040e4d) Cannot start your application. The workgroup information ...
Use aliased field names to avoid ambiguities in JOIN commands
by Francesco Martire
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 ON table1.id = table2.id" In our example, both table1 and table2 share the same field name "field1", but ...
Save Data in a SQL Server Image Column with VB6
by Gian Maria
I needed to retrieve image fields on SQL Server 7.0 with VB6, and I couldn't find any article about it. So, I assume others have had the same problem. I've since found a method for doing it.
1-20 of 72     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date