Question about Operating Systems

2 Answers

How to connevt visual basic with oracle(sql)

I dont't have idea to connect both of them.because of i have project on databse designing in 4th,i need your help.if possible plz help me.

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers
Re: how to connevt visual basic with oracle(sql)

First, you need to Install Oracle client software and make sure you are able to connect to the database (test the connection from SQL*Plus)


Posted on May 23, 2012

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert that hasĀ over 500 points.


    An expert who has answered 200 questions.

  • Expert
  • 244 Answers
Re: how to connevt visual basic with oracle(sql)

You need to install oracle client on client machine, and than you can use datasource (ODBC) to connect from vb to oracle.

Posted on Jan 23, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

How to do framework ??

You need Visual Studio from Microsoft. Inside this visual Rapid Application Development (RAD) tools, you can use c++, c#, or basic language. It is lot of learning to become programmer.
You can find SharpDevelop free programing studio if you want to learn more. With this program, you will need .NET packages on your computer. It is like JAVA from Sun (Oracle). It is copy from Microsoft of JAVA ideas. Like free NetBeans IDE for JAVA development.
Inside studio you will have option for create New project. It can be grafical with graphical designer for draw some button, text input frame ... You will have properties for this objects, and possibility to write programming code. It is lot of learning to do real application. When you write some application you can compile it to exe output.
Visual Basic is only simplest part of this technology. C# (C-sharp) need more learning, and C++ is hardest thing.
Good luck!

Aug 26, 2011 | Operating Systems

3 Answers

Visual Basic and SQL


Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. is compatable with sql 2005 which is inbuilt as well.

Jul 07, 2009 | Microsoft Windows Vista Ultimate Edition

2 Answers

Printing syntax

'declare the variables
Dim Connection
Dim ConnString
Dim Recordset

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _

'declare the SQL statement that will query the database

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
End If

'close the connection and recordset objects to free up resources
Set Recordset=nothing
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

How to write jdbc connections


welcome_title_image.gif Java JDBC Tutorial Java JDBC Tutorial
The JDBC ( Java Database Connectivity) API defines interfaces and classes for writing database applications in Java by making database connections. Using JDBC you can send SQL, PL/SQL statements to almost any relational database. JDBC is a Java API for executing SQL statements and supports basic SQL functionality. It provides RDBMS access by allowing you to embed SQL inside Java code. Because Java can run on a thin client, applets embedded in Web pages can contain downloadable JDBC code to enable remote database access. You will learn how to create a table, insert values into it, query the table, retrieve results, and update the table with the help of a JDBC Program example.

Although JDBC was designed specifically to provide a Java interface to relational databases, you may find that you need to write Java code to access non-relational databases as well.
JDBC Architecture jdbc.jpg Java application calls the JDBC library. JDBC loads a driver which talks to the database. We can change database engines without changing database code.
JDBC Basics - Java Database Connectivity Steps Before you can create a java jdbc connection to the database, you must first import the
java.sql package.
import java.sql.*; The star ( * ) indicates that all of the classes in the package java.sql are to be imported.
1. Loading a database driver,
In this step of the jdbc connection process, we load the driver class by calling Class.forName() with the Driver class name as an argument. Once loaded, the Driver class creates an instance of itself. A client can connect to Database Server through JDBC Driver. Since most of the Database servers support ODBC driver therefore JDBC-ODBC Bridge driver is commonly used.
The return type of the Class.forName (String ClassName) method is “Class”. Class is a class in
java.lang package.
try { Class.forName(”sun.jdbc.odbc.JdbcOdbcDriver”); //Or any other driver } catch(Exception x){ System.out.println( “Unable to load the driver class!” ); } 2. Creating a oracle jdbc Connection

The JDBC DriverManager class defines objects which can connect Java applications to a JDBC driver. DriverManager is considered the backbone of JDBC architecture. DriverManager class manages the JDBC drivers that are installed on the system. Its getConnection() method is used to establish a connection to a database. It uses a username, password, and a jdbc url to establish a connection to the database and returns a connection object. A jdbc Connection represents a session/connection with a specific database. Within the context of a Connection, SQL, PL/SQL statements are executed and results are returned. An application can have one or more connections with a single database, or it can have many connections with different databases. A Connection object provides metadata i.e. information about the database, tables, and fields. It also contains methods to deal with transactions.
JDBC URL Syntax:: jdbc: <subprotocol>: <subname> JDBC URL Example:: jdbc: <subprotocol>: <subname>•Each driver

Feb 01, 2009 | Microsoft Windows XP Home Edition

1 Answer

I want connet foxpro databse to visiual basic

Using a DSN-less connection to open a free table
cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Vfp\Samples\Data;" _
& "Driver={Microsoft Visual FoxPro Driver}"

Jan 20, 2009 | Operating Systems

1 Answer

Connection of Oracle9i with Visual Basic 6

if oracle scott
password tiger
if not acccepted go to control panel ,administrative services put
oracle services manually & start it.
ur's kishore chowdary.(+919441133420)

Mar 28, 2008 | Operating Systems

2 Answers

Howto load data to datagrid using visual basic 2005 and sql 200

May I suggest providing us with the programming language enviroment, which you're using, as in, Visual Basic or something, that way, I think it would be easier for the experts to give you an answer.

Here is a helpful link about Databases, but it's for Visual Basic Express Edition 2008

The best of luck with your project.

Mar 19, 2008 | Operating Systems

1 Answer

Installing SQL server and VB.NET on VISTA Home Basic

installl SQL SERVER 2005 is fine its your sql that will mess things up

BTW visual studio come with an SQL server

Jan 09, 2008 | Microsoft Windows Vista Ultimate Edition

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

201 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts


Level 3 Expert

18258 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

6993 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides