Set rstemp = contemp.OpenResultset("select. EstablishConnection rdDriverNoPrompt, false, rdoForwardOnly Connect = "ODBC DSN=Oracle USR=scott PWD=tiger" ' or rdUseOdbc, rdUseNone, rdUseIfNeeded, rdUseClientBatch Set envtemp = rdoEngine.rdoEnvironments(0) Set rstemp = dbtemp.OpenRecordset(myquery.Text, dbOpenDynaset, dbSQLPassThrough) Set dbtemp = wstemp.OpenDatabase("", False, False, "ODBC DSN=Oracle USR=scott PWD=tiger") For information about OO4O, read the OO4O FAQ. ![]() ![]() ![]() ![]() For more information about ODBC, read the ODBC FAQ. VB is based on the BASIC programming language and is mainly used to develop Windows based applications.Īccessing Oracle from Visual Basic Ĭonnectivity to Oracle is provided via ODBC or OO4O (Oracle Objects for OLE). Visual Basic (VB) is an extremely popular and easy to use programming language provided by Microsoft Corporation.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |