please help me! visual basic usage!!?

Question

okay, so i am using visual basic 6.0 and i downloaded access database engine ole. so i installed it then i went to my project and i want to use ADOD. so i did all the basic steps; put adodc1 then build a connection string. all went well, even when i click test connection button the connection is okay. then i clicked the properties of a textbox then i chose adodc1 for datasource. here's the problem. when i click the datafield, it shows ADOD unknown error. i'm so mad because i cant finish my project because of this damn error. what do i do?!?! i'm so confused!!

Answer 1

OLE is not ADO. They are completely different means. Make sure you have downloaded and installed an appropriate ADO driver.



After that, I'm not sure if you're creating a DataControl in VB or not. If not, use it. The DataControl's default connect method to Access is Jet, but you could switch it to ADO instead. If you configure the DataControl properly, you should be able to see the various tables in your database as a RecordSource property, and be able to select one of them. Then finally, set your DataSource property in your textboxes.



If you don't like the DataControl being visible, you can make it not visible and control it manually using datControl.Recordset.MoveNext etc.

Answer 2

Did you install service pack 6 for VB6?

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24417



Sp6 fixes lots of bugs.





Adodc is just a connection to a database. You need to define a table in that data base and within that table you need to define the record fields where data will be stored. I suspect that you have not created a table nor fields. Trying to connect the textbox to just the database will generate an errot you also need to identify which table and the field with in that table for the textbox to bind to.....



Why are you using VB6? It is literally last centuries technology. Microsoft provides fully functional express versions of VB, C and SQL .

Answer 3

that's a programming language. initiatives which could be completed via a working laptop or laptop want the classes interior the fashion of device code. to ensure that that device code to be quite written and edited that's generally switched over right into a language greater quite understood via a human. for this reason the programming language. a working laptop or laptop truthfully works via a series of classes made up from 0 and a million (binary) or on and rancid. based on the width of the machines factors (like 8bit, 16bit etc) your guidance set might nicely be (8bit): 00000000 to 11111111 this provides 256 combos. So enable's say the guidance to the laptop for a return desires to be 01101100. those binary codes are generally switched over to some thing referred to as Hexadecimal which contain numbers and letters. i think of return is C9 (which could signify 01101100 yet as I guessed it, it in all probability does not!). ok, so that's a lot much less annoying to bear in techniques C9 fairly than the 8bit binary extensive style, yet we are able to circulate one step further via employing a programming language like worry-unfastened (or seen worry-unfastened). those languages are compiled or assembled from and to device code: i'm uncertain which way around that's! besides in case you write return in seen worry-unfastened it tells the laptop to do a similar factor as C9 or 01101100!! a lot much less annoying i'm particular you will agree. that's no good as a video games application as that's in simple terms too sluggish. via the time the classes have been switched over you would be shot ineffective.