Question about Computers & Internet

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 sem.so,i need your help.if possible plz help me.

Posted by on

Ad

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

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)



AMIRA FOODS INC

Posted on May 23, 2012

Ad
  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 244 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What is .sdf file


The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.

Sep 03, 2011 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

How to do vb.net 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 | Computers & Internet

1 Answer

What is sql condition in visual basic?


sql is used for databases. Something like sql server, oracle, or access uses sql. It is a group of tables configured to reference eachother, so if you are programming in visual basic, you are trying to reference something on your sql server.

Feb 28, 2011 | Microsoft Xbox 360 Console

3 Answers

Visual Basic and SQL


Hi,

Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. VB.net 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
Dim SQL

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

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'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.")
Else
'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>"
Recordset.MoveNext
Loop
End If


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

May 16, 2009 | Microsoft Windows Vista Ultimate 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 | Computers & Internet

2 Answers

Need a banking project on visual basic


go to following site : http://www.programmer2programmer.net/live_projects/project_1/ebilling_invoice_system.aspx

download ebilling project.

Good Day

Dec 11, 2008 | Microsoft Step by Step Visual Basic 6.0...

1 Answer

Oracle SQL Error


Does it connect after the error ?. First try to connect from your client to Oracle server using SQL plus client.

Second - Do a tnsping <server name>

This will give you the correct Host name, SID and Port number.

Make sure that your JDBC connection parameters match with the actual connection from TNS output

Sep 04, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

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 | Computers & Internet

4 Answers

QUEST SQL Navigator 3.2 with Oracle 10g Fails


I followed the advice given above and copied the ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. copy ociw32.dll ora73.dll
And the software worked immediately.

Dec 21, 2006 | Quest Software SQL Navigator Professional...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

212 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...