I have installed Oracle 8i and VB on windows 2000 server. How do I connect my VB projects to Oracle Database?
98374
1. Open CONTROL PANEL\n2. Open ADMINISTRATIVE TOOLS\n3. Open 32-BIT ODBC\n4. Create a connection to Oracle Database by creating a System or User DSN.\n5, Create an Standard Exe Program in VB\n6. Add ADO Data Controller\n7. Configure it to use a DSN, you have just created.
850443
ok I give some hints\nIf you want to refer to a database from Excel you need to add the ADO 2.8 objects Library. \nHow to proceed?\nFrom the Visual basic editor, click on tools (menu bar) and then reference. look for Microsoft Activex Data objects 2.8 library and tick it.\nNow you should have access to ADO objects.\nTo learn how to use these objects try the msdn microsoft website, full of advice and templates\n\nIf you want an example from me, give me a valid email address where i can send you an excel workbook and small access data base for it takes too long to explain
1080454
Try http://www.vbcodesource.com \n\nor\n\nhttp://www.programmersheaven.com/zone1/mh49.htm
973927
Using either PHP or ASP use ADO to establish your connection to either database and fetch your data that way.  You will need to install the Oracle OLE or ODBC driver.  I have not done this in the Unix / Linux world but it is so easy to do in the windows world.  Here is the ado connection strings you will need to do it.  I know this is written for Windows but it is somewhat similar in the Linux / Unix world.\n\n\nhttp://www.carlprothman.net/Default.aspx?tabid=81
667928
i think it should be Oracle 8.0
931713
I think for that u need the machine name or the IP address of the database machine.\n\nU can use this machine name or IP as the data source value in ur connection-string value provided for connection in ur code..
246093
your app. will have 3 layers: 1-data layer 2-business layer 3-userinterface\n1-data object will take care of the database no matter where it is (u will use DCOM for that.)\n2-business object is where the logic of your program is\n3-user interface is the application that users in every station will run\nso, u will have to design 3 projects. If u use vb6, u need one standard exe project for user interface, and two ActiveX DLL projects one for data object and the other for business object.\nafter creating those two dll files (from activeX projects), u will need to add those dll's in Standard EXE project as reference files to be able to use them, but before, u need to register the dlls in registery..\nfor data object, depending on network topology, u can create an activeX dll or activeX exe..\nthats it.\nIf u dont know how to access to a remote database, u can start designing the softwares, then writing the code and instead of using real functions for database access remotely, use hard-coded functions until u learn how to use real functions.\nu will have to learn some other details depending on ur DBMS.\ngood luck ;)
268492
Here are links:\nOracle Real Application Clusters Quick Installation Guide\nfor Oracle Database Standard Edition 10g Release 1 (10.1.0.2.0) for Windows\nhttp://download-uk.oracle.com/docs/html/B13829_01/toc.htm\n\nOracle Real Application Clusters Installation and Configuration Guide\nhttp://download-uk.oracle.com/docs/html/B10766_08/toc.htm\n\nAnd here is the complete list of Oracle documentation:\nhttp://www.oracle.com/technology/documentation/database10g.html\n\nServer will ask you to enter your login at Oracle Technology Network. Register there if you aren't yet. It's free and very useful.\n\nGood luck!
1118985
if your using .net platform than look up the oracle client\n\nSystem.Data.OracleClient.OracleConnection\nIf your using any other windows implemetation of C, C++ use odbc
1091921
In visual basic 6.0 IDE you have to add a reference to ADODB(ActiveX Database Ojects) library.You have to declare a public variable to reference a connection in the general declaration section.\nGo to www.planetsourcecode.com and you will find a lot of programming code for that.
361351
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
292214
Once a new UserConnection object has been inserted into the project, you can add new Query objects to it. These query objects can be either stored procedure calls or user-defined SQL statements. Each query object defined at design-time will automatically be available as a method of the new UserConnection class.\n\nTo add a Query object, click the leftmost button on the toolbar. The new Query object is added hierarchically below the UserConnection object, and its Properties Window appears.\n\nSelecting Stored Procedures\nSelect Insert Stored Procedure to view the available stored procedures on the database. The UserConnection designer attempts to establish a connection to the database, using the connection properties you entered. If successful, it enumerates the available stored procedures on the database, allowing you to select one to define the Query object:\n\nQuery Properties dialog box\n\n\n\nInserting User-Defined Queries\nChoose Based on User-Defined SQL to create a local query against the remote database. This enables the SQL property box, into which you enter SQL statements to define your query.\n\nAlternatively, you can click the Build button, which opens the MS-Query query design tool. MS-Query provides a visual interface that allows you to drag and drop database tables and fields, define conditions and set relationships to define the query. When you exit from MS-Query, your visually-designed query is automatically translated into SQL code and inserted into the User-Defined SQL property box.\n\nFor More Information   For more information about using the MS-Query query builder, see MSQry32.hlp which is installed in the &#92;Program Files&#92;Common Files&#92;Microsoft Shared&#92;vba directory.\n\nSetting Other Query Properties\nIn addition to the defining properties discussed above, the Query Property Page has two additional tabs for defining Parameters and advanced properties.\n\nThe Parameters tab on the query property page allows the developer to adjust properties for each parameter in the current query.\n\nParameters properties\n\n\n\nThe parameters shown in the Parameters list box are determined automatically from the query source, and cannot be changed here. Parameters are generated for each parameter marker in the SQL statement for the query (or call statement for stored procedures). Parameter markers are designated by a "?" in accordance with the ODBC specification. For example, the following query would contain two parameters:\n\nSELECT * FROM authors WHERE state = ? AND zip = ?\n\nThe parameter properties that can be changed here are the Name, Direction, ODBC Binding Data Type, and Visual Basic Data Type.\n\nThe Name property can be changed to allow your Visual Basic code to recognize the parameter by a familiar sounding name, if its actual name is complex or not intuitive.\n\nSetting the Direction of a parameter may be necessary for some ODBC databases for which the driver is not capable of determining the direction (input, input/output, or return values). The same is true for the data types, and you may wish to override the default type conversion into Visual Basic data types for use with your code.\n\nAdvanced Query Properties\nThe Advanced tab of the Query Properties page allows for fine-tuning the query by setting limits and thresholds.\n\nAdvanced properties\n\n\n\nThe Call Syntax text box lets you change the call syntax that RDO will use to call the stored procedure. This can be edited to adjust the number of parameters and presence of the return value. Editing the call syntax is an advanced operation and should only be done by developers who understand the ramifications.\n\nUsing the UserConnection Object in Your Code\nYou can insert the UserConnection object into your Visual Basic code just as you would with any class, by creating an object variable and instantiating it with a new instance of the UserConnection class you have defined. For example:\n\nOption Explicit\nPrivate MyConnect As M
987919
web design oracle java vb. Try sap
112568
refer these urls..\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5b1v.asp\n\njust surf through the bookmark on left hand side..\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_30s5.asp\n\n\nalso refer this one..simple n straight forward\nhttp://www.1keydata.com/sql/sql-create-index.html
1161694
If you are doing .NET work, have you looked in the machine.config to see what your connection string(s) is(are)?\n\nTake a look at this example:\n\n  <connectionStrings>\n    <remove name="LocalSqlServer"/>\n    <add name="MyDatabase" connectionString="data source=sql2k503.datamain.net;Initial Catalog=SQL20005_DB;User ID=Meuser; Password=abcdef" providerName="System.Data.SqlClient" />\n  </connectionStrings\n\nHope this helps, or at least points you in the right direction.
589940
yes it is possible to install oracle on XP. it requires some some net 8 configurations
1088663
Place in the first CD and start the Oracle Installer. What you'll need to install on your computer is not only the Oracle database but also the Oracle server (which from wht I've heard can be configured and installed only on the same partition windows is installed...). Then you'll be prompted for what kind of database do you want to configure on your system (depends..). After this Oracle will copy all the files needed... You'l have a hard time configuring users password, group id's in Oracle 9i...