|
I can answer for you for only question that I know and base on documentation.
1. Difference between RDO and ADO.
RDO stand for Remote Data Objects
Remote Data Objects implement a set of objects to deal with the special requirements of remote data access. RDO implements a thin code layer over the ODBC API and driver manager that establishes connections, creates result sets and cursors, and executes complex procedures using minimal workstation resources. Although RDO is also accessed by DAO when your code creates an ODBCDirect Workspace object, documentation for this implementation can be found by searching for specific ODBCDirect topics.
Note RDO and the RemoteData control are designed to be used only in 32-bit operating systems such as Microsoft Windows 95 (or later) or Microsoft Windows NT.
With RDO and the RemoteData control, your applications can access ODBC data sources without using a local query processor. This can mean significantly higher performance and more flexibility when accessing remote database engines.
By using RDO, you can:
Create simple cursorless result sets, or more complex cursors.
Run queries and process any number of result sets.
Execute stored procedures that return result sets with or without output parameters and return values.
Execute action queries that perform data manipulation or data definition operations.
Limit the number of rows returned or processed.
Monitor all of the messages and errors generated by the remote data source without compromising the executing query.
Enable synchronous, asynchronous, or event-driven asynchronous processing so your application isn't blocked while lengthy queries are executed or the current row pointer is repositioned.
ADO stand for ActiveX Data Object
Solutions for Local Data Access
The Issue
You want a simple, consistent application programming interface (API) that enables applications to gain access to, and modify a wide variety of data sources. A data source may be as simple as a text file, as complex as a cluster of different types of databases, or something yet to be invented. Furthermore, the API should not presume the means of gaining access to and manipulating the data source.
Although these are your specific requirements, the typical data source is a relational database that supports the Open Database Connectivity (ODBC) standard and is manipulated with commands written in Structured Query Language (SQL).
The general solution Microsoft offers to this problem is OLE DB, a set of Component Object Model (COM) interfaces that provide uniform access to data stored in diverse information sources. However, because the OLE DB application programming interface is designed to provide optimal functionality in a wide variety of applications; it does not meet the requirement for simplicity.
You need an API that is a bridge between the application and OLE DB. ActiveX Data Objects (ADO) is that bridge.
The Solution
ADO defines a programming model—the sequence of activities necessary to gain access to and update a data source. The programming model summarizes the entire functionality of ADO.
The programming model suggests an object model—the set of objects that correspond to and implement the programming model. Objects possess methods—which perform some operation on data—and properties—which either represent some attribute of the data or control the behavior of some object method.
Associated with objects are events—which are notifications that some operation has occurred, or is about to occur.
Basic ADO Programming Model
ADO provides the means for you to perform the following sequence of actions:
Connect to a data source. Optionally, you can ensure that all changes to the data source occur either successfully or not at all.
Specify a command to gain access to the data source, optionally with variable parameters, or optionally optimized for performance.
Execute the command.
If the command causes data to be returned in the form of rows in a table, store the rows in a cache that you can easily examine, manipulate, or change.
If appropriate, update the data source with changes from the cache of rows.
Provide a general means to detect errors (usually as a result of making a connection or executing a command).
Typically, you will employ all these steps in the programming model. However, it is worth noting that ADO is flexible enough that you can do useful work by executing just part of the model. For example, you could store data from a file directly into a cache of rows, then use ADO resources solely to examine the data.
(The source of this document were took from MSDN Library January 2000)
2. About the wizard
It look like the wizard but it just 2 importance step that you need to understand, first select the connection type and second choose the database. To understand this follow this step:
1. Create a new blank project in vb6.
2. Go to Project menu and click on Component submenu.
3. When the Component dialog box appear scroll to Microsoft ADO Data Control 6.0 (OLEDB) and checked it.
4. An ADO data control appear on the tool box and click and draw it on your form.
5. When an ADO data control appear on the form right click on it and choose ADODC Property.
6. From the property dialog box of ADO data control in the "Source of Connection" frame you will see three option. The first one is "Use Data Link file" the second one is "Use ODBC data source name" and the third one is "Use connection string".
7. Choose the third option (Use connection string) and click the build button.
8. You will see the Data Link Property dialog box appear with a difference type of data that you want to connect. If you want to connect to SQL server database you can click on "Microsoft OLE DB Provider for SQL Server" and click on "Next >>" button. The next tab of property dialog box appear with 3 step for you to follow. The first one is "Select or enter the server name:" click on the drop down list to choose the server name that contain SQL database install on it. The second step is "Enter information to log on server", you can choose two option (SQL or Windows authenication). This example I prefer Windows authenication. And the third step is select database on the server. I choose master database (just an example, master database is the core database of SQL server. You should not modified to it in case of necessary). Then click on "Test connection" button. If you see message box said that "Test connection successed." then it is working properly.
9. Click on OK button twice and you will see the connection string in the text box "Provider=SQLOLEDB.1;Integrated Security=SSPI; Persist Security Info=False;Initial Catalog=master;Data Source=APOCEDC" .
Learn from here try to customize the code with any database that you create in SQL server. Then you will see how it is working.
Hope it is work!!! and wish you good luck in programming!!!
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Thanks a lot sir. i got the way and it is really useful. now i can make a Library program which can be used in a network than in a stand alone system. a long way to go i know. again thanks.
|
|
|
|
|
Hello there
Can anybody tell me how to use a VB6 form application on my Pocket pc.
thanks
murtuza
|
|
|
|
|
Try to read the information from here.[^]
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
how can i delete contents of history folder.i've been able to access it but not been able to delete websites in today . can someone tell me how can i do that. thanx in advance
|
|
|
|
|
Do you want to delete it from any application that you build or just delete by manually. If delete by manually, try to go to IE option. On the first tab (the General tab) click on "Clear History" button. This button just clear the list of day that it appear in IE history pane. If you want to clear the file that you have browse on your computer you have to click on "Delete Files..." button. This will clear the cache file that you browse any website before. Hope this work!!!
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
thanx but i know it manually.i have even done that from application but the problem is that it clears the "Temporary Internet Files" folder only and not the history folder which actually has a calendar today which caches sites i want to gain access to that folder and delete today calendar. if u can help do reply, thanx.
nitin
|
|
|
|
|
In IE click on History button, then it will display history pane. If you want to delete the today history, try to right click on Today folder and click delete. Make sure that you already clear the file in IE option (General tab).
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hi all.
I have a quick question about how to determine the color of text based on the background color of the form. My form allows the user to change the BackColor property, but if they select a darker color I would like all the text labels to "lighten up" for them. Windows does this with the text labels of the desktop icons and I'm just wondering how it's done.
As near as I can tell I'll have to just examine the RGB values of the form color and maybe invert them - RGB(255 - R, 255 - G, 255 - B). Is there an easier way do to it though, that I'm not aware of?
Please let me know. Thanks.
"Go to, I’ll no more on’t; it hath made me mad." - Hamlet
|
|
|
|
|
Hi,
There is a problem with me.
I want to open a report created in CR9 thru VB 6 but without using CRViewer.
Actually, i want the behavior of Crystal Report control.
i.e. report is opened in a seperate window and it stays alive even if vb application is closed.
Is there any kind of "Crystal Report control" for CR9, too ?
Plz, respond asap.
Awaiting your reply....
|
|
|
|
|
|
Anybody here know how to retrieve the Topmost Visible row of a Datagrid?
|
|
|
|
|
i want to locate a location of property using Maps. I want to show the property info through navigating Maps. Do u have any idea, how can i achieve this task.
if u know about MapPoint then tell me how can i create own maps in it
thanks.
RAK
|
|
|
|
|
Oh, sorry I thought you wanted the titlebar one,
ok, then check here:
.NET Framework Class Library
Help.ShowHelp Method
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWindowsFormsHelpClassShowHelpTopic.asp
|
|
|
|
|
thanks for you're help...
Unfortunately I still can't find the answer.
All the examples points to loading a help file or pointing to an index or using the help.showhelp class.
All I want to do is "Emulate" the ? HelpButton on the title bar. Now as soon as I found some reference to that, MS says that this procedure cannnot be used in your code DOH!
I thought it might be as easy as raising an event like Showhelp.click ...
There has to be a way ¿
|
|
|
|
|
Hello,
I am beginner in VB.net, kindly guide me in a problem.
I have a file that is written in a language other than English e.g., In Hindi or URDU.
I want to read and display the contents of that file in my program.
How can i do that.
Thanks in advance.
Regards,
Eshban
EsHbAn BaHaDuR
|
|
|
|
|
VB .NET
I am looking for a way to raise the ShowHelp event for context sensitive help when the user presses a toolbar button.
I want the button to behave exactly the same as the ? on the title bar.
Can anyone help?
|
|
|
|
|
Try here,
http://www.help-info.de/en/Visual_Basic_net/vbnet_htmlhelp.htm
|
|
|
|
|
Unfortunately that does not help...
All examples I have seen and all the searches I've done do not show any examples of raising the HelpButton Event.
The reason I want to do this is I have only one main form and I want to display the minimum and maximum buttons, so I cannot have the HelpButton shown as well. So I am trying to have my own ? HelpButton on a toolbar.
Can't find any answers ...
|
|
|
|
|
Hi
Im trying to work with and save large amount of binary data (bytes) but I cannot figure out how to do this in visual basic 6.
In C you can setup a large buffer of bytes, "char buffer[123123]", work in this buffer and then save a part of it with a "fwrite(buffer + 321, 1, 4321)".
In visual basic I can setup a byte array "Dim buffer(1073741824) As Byte" but I cannot get this array as large as I want, about 10Mbytes.
And how can I save only a small part of a byte array fo a file? If I do it Like:
Open "c:\test.raw" For Binary As #FileNumber
Put FreeFile, , bindata
Close FreeFile
Then the whole byte array will be written to the file. I have seen solutions for small amount of bin data where a collection is used and each byte element in the collection is saved in a while next lop with a put in it, but that cannot be that efficient or?
regards Me
|
|
|
|
|
can i get the names of enum items at runtime using VB6?
i.e. does vb6 support some kind of metainformation
(at least a little)?
|
|
|
|
|
No, you can't. VB6 doesn't support Reflection.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yes it does. Try reading up on the typelib utility and also there is an example on how to make your own typelib utility from the cd. Using that, you can grab the classes, types, or enums defined in a dll or exe.
|
|
|
|
|
Great! Didn't know that.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am using an OLEDBDataAdapter to draw data out of an Access database. I am able to use the fill method and populate a flexgrid control with the data pulled. I need to be able to put this data in a text box though so that i can copy and paste all results in one shot. How do I Pupolate any control that I can pick more that one item with copy and paste action with multiple date. At current the command I am using is OLEDBDataAdapter.fill this is a very simple program. TIA
|
|
|
|