Results for "Category: Databases/ Data Access/ DAO/ ADO"

if mdb_dsn_connection doesn't exist... then make it

To upload and retrieve ORACLE BLOB File using ADO Recordset. Never try with other than ORACLE database, but i think i can ...

To Provide a Recordset Template (view,execute,edit,Add new) To Provide a Database Connection Template (ORACLE and MS Access)

I have received a lot of responses to my code posted earlier ( a generic object that assisted in returning recordsets from Oracle). Most of these questions have been in the domain of the stored procedures themselves. Hopefully this article and example stored procedures will help clarify.

It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks: Save the data stored in a SQL Server Image column to a file on the hard disk. Move the contents of a .gif file to an Image column in a SQL Server table. ** Article ID: Q258038 - I take no credit for the code, I simply created a project from the example in the article **

This function retrieves data from MSHFlex Grid and prints it directly to the printer. It determines whether the information should be printed landscape or portrait.

Uses RDO to connect to 2 different (or the same) ODBC specified connections. Allows you to select tables on both sides and creates SQL statements to transfer the Data from the Source Table to the Target Table. Has the Option to Clear or Truncate the Target Table before Transfer. The 2 Tables must have the same amount of fields (of course).It automatically does the single quote thing for the fields that requires it. Easy to convert to ADO. Very nice , easy to use interface. The ODBC connection wil NOT work on NT , although minor changes can easily make this happen. Comments are very Welcome , even from critics.

Add / Remove User Using Access Database User: ADMIN / Password: admin / Level: Administrator

This a Search program that searches for a 'specific record in a database. This is a kind of DISTINCT search. Where u just have to enter the first letter of the data u want and it gives u an output in the grid.

Allows the programmer to create an MS Access table in Visual Basic where the primary key’s field data type is set to AutoNumber. It is not like creating the primary key field in Access where you can select AutoNumber date type. In VB 5 and 6 you can’t request AutoNumber for a field type in the SQL Create Table string, it does not exist. So to create a table in VB where primary key’s numeric field type will be AutoNumber, you have to do it the way the included source code shows. Hope this helps.

Class that allows to create or edit connection strings using datalink of ADO. Suggestions and commentaries are welcome. Vote me!!

This code/tutorial is a beginners guide to connecting to your own SQL Server database.

This is in response to a 'Request for Code' in the discussion forum. It's similar to lots of other submissions of address book style apps. It shows how to create and access a database without any data controls - just by referencing 'Microsoft DAO 3.6 Object Library'. Purely an introduction to databases - nothing more. A simple address book in 160 lines of code, easily expanded, with lots of comments to guide a beginner through the code.

This little application uses SQLDMO to script out objects in SQL Server 7.0 databases (tables, stored procedures, views, defaults, UDTs, full text indexes, etc.), as well as SQL Agent Jobs, Server logins, Operators, Alerts and Backup Devices. It even lets you save DTS packages as Structured storage file. Can be run in GUI mode or unattended/scheduled from the command-line. The code is a nice example of the use of SQLDMO objects, but even if the code doesn't interest you the application should be useful for SQL Server developers/DBAs who want to generate scripts of their DB objects in a more automated way then SQL Server EM lets you. ------------------------------------------------------------ A short text-file describing use is included. ------------------------------------------------------------ This is not drool-proof paper! Use at your own risk. Don't use on production servers unless your local DBA god has given you explicit permission. Dependencies are described in the included text file. ------------------------------------------------------------ A short (third-party) review of this tool and an executable-only download can be found at http://www.myitforum.com/articles/18/view.asp?id=3117 ------------------------------------------------------------ (Update 20020517 (v2.0.1): Added options to the /DB command-line switch to script out only the user or system databases) ------------------------------------------------------------ (Update 20020701 (v2.1): Server names, login names and authentication modes are now remembered between GUI sessions)

To remedy difficiencies in ADO, namely single criteria in the .FIND method. We encapsulated an ADODB.Recordset within a vb6 class module, and created four methods (FindFirst, FindLast, FindNext, FindPrevious) which allow for more that one criteria.

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

This is to show new developers to Databases how to develop applications with VB and ADO. It is very well formated, step by step. And if you like it Please vote!

This is to show developers (mostly new ones) how to use XML / ADO technologies from within VB. I got the XML source code from a project on this site and put it to use! I hope that this will help someone out!

Store Files to Access-DB and restore them from DB to File and more...