Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




How To Connect To Oracle 10g XE


Dear All,

How to connect to Oracle 10g XE ? .. I didnot find correct connectionstring..

please help

TIA

Winanjaya




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Connect To Oracle.
Hi there,
When I use an ADO to connect to Oracle I get an error "Connecting failed while initializing provider ORA-01019". Does anyone know while this error occurrs and how to correct it.

Thanks in advanced.

Is Is Possible To Connect To Oracle With DAO?
Before I start to beat my head against the wall, is it possible to connect to Oracle databases using DAO?

The client does NOT want to install MDAC on all the client machines.

In other words, is it possible to connect to an Oracle db without using MDAC?

Cheers

Swiss

How To Connect Oracle And Vb Without A Dsn
Hi,

I heard there is a way to connect oracle and visual basic without using a DSN.

Will you let me know , please


shoba

Connect To Oracle
I have Visual Basic installed on my system
I have an application which can be used where Oracle client is not installed.
Would my application still run on that system?
What are the possible alternative solutions?
San

How To Connect VB To Oracle
Hi everybody,
Friends please can anybody explain me the what r th procedures to connect VB to Oracle, I have VB6.0 and Oracle i my PC, I am doing a project in VB, for that I need to connect i with the Oracle, please explain me the connection with code an concept. Please friends urgent.

Kanth

Connect To Oracle From VB
I have Visual Basic installed on my system
I have an application which can be used where Oracle client is not installed.
Would my application still run on that system?
What are the possible alternative solutions?
San

Connect VB Through Oracle 9i
Hi,

How I connect to Remote Oracle Server (installed 9i server on windows 2000 server) from Client PC (Installed VB 6 on window XP) by using ADO

Remote Oracle Server's IP = 192.168.30.1, Name = ServerPC, SID= orcl, User ID = system, Password = manager

Client Pc's IP = 192.168.30.10

I have succesfully Installed VB6 and it connect Locally with MS Access 2003 using following code.

Code:Public Sub OpenDatabase(ByVal db_name As String)
Set DB = New ADODB.Connection
    ' Access Database password
    db_name = App.Path + "PassportDetail.mdb;Jet OLEDB: Database Password=GTS;"
    DB.Open _
        "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Persist Security Info=False;" & _
        "Data Source=" & db_name
end sub

Can you guide me ?

Thanks

With best regards


Tanweer


<Edit> AbbydonKrafts - Moved from "Code Bank - VB6" to "VB & Databases". Also added CODE tags. </Edit>




Edited by - AbbydonKrafts on 6/12/2007 7:04:24 AM

How To Connect Vb6 And DB In Oracle 8
How I can connect a DB (oracle) to a VB6 project.
the complete process of how to connect the data base of Oracle with VB6 project
My VB project has a mdi form as well, and the name of my DB is "tps"

How To Connect VB6.0 To Oracle 9i
Hi Friends,

I am a BSc IT Student. I have to make a project, with VB6.0 as front-end and Oracle 9i as back-end.

I would like to know :-
a) how to connect the text box, combo box etc... to Oracle database.
b) how to insert data from VB form to Oracle database.
c) how to retrieve data from Oracle database to VB form
d) how to delete a record from VB form in Oracle database.

Friends, if you know any website that I can refer for the above information, please let me know. Thank you

How To Connect Oracle
hi
how to connect from a vb client which is running on windows98 and oracle8i server which is running on unix server.

thanking u

How To Connect Oracle
hi
any one can help out me to solve this problem
i have installed oracle8i server in UNIX system and i want to connect it through vb windows98 client. i have instaled oracle client at my client system.

thanking u

How To Connect Oracle
Hai everybody,
I want know how to connect oracle with remote server..using provider...how to declare the conn string ?
If anyone knows can u help me pls ?

VB 6.0 Oracle 8i Connect
ATTENTION mgn0528-

But I put the data correctly. I have four fields-Emp_Id(Numeric), First_Name(Varchar2),Middle_Name(Varchar2) and Last_Name(Varchar2) and the data I put was 2, Rahul, Pathian, Barua. Hope all are correct.But... the first data i.e Emp_Id =1, I entered from the oracle and not from the VB form...So what is your opinion....

Vb-oracle Connect
I've set up aconnection between VB and Oracle8.When I start my application ,where I use ODBC DSN to connect, stat databaseoperation fails.Ihave to start the database first from Oracle StartDatabase icon.and then start the application.Only then it works.Is there a way to start the application so that the Oracle database starts automatically.

Connect To Oracle Through Excel
Hi, I have been able to access Oracle tables using VBA within Access but I now need to do the same thing from within Excel. Can this be done? How?

What I need is to run an SQL query and dump the result to a worksheet. I already have code (used within Access) that creates the data I need - just need to know how to execute from within Excel.

Thanks in advance for your help.

Connect To Oracle Thro' VBA
I am using the following code, but it gives error on machines that DON'T have oracle client installed (ORA-12154 TNS:Could not resolve service name).

Is there a way to connect to oralce thro' VB WITHOUT installing client by using some other 3rd party driver or some other method as we have about 5000 user machines and it does not make sense to install the client on all the machines to have this functionality.


Code:
Dim ProdConnectString as String
Dim conn As New ADODB.Connection

ProdConnectString = "provider=msdaora.1;user id=xyz;password=abc;data source = testsource;option=1+2+8+32+2048+16384"
conn.ConnectionString = ProdConnectString
conn.CursorLocation = adUseClient
conn.Open
Thanks.

-BS

How To Connect To Oracle With ADO Without ODBC
I want now how to connect to Oracle in VB6 and VB.NET without ODBC.

Connect To Oracle Without Connectstring
I've developed a S/w in Vb 6.0 on Win XP system.I've used connectstring to connect to the oracle 8i db.However, the application doen't connect to the database if I run it from a system that doesn't have oracle client installed on it. How can I come over this problem?

Connect To Oracle Thro' VBA
I am using the following code to retrieve data from DB thro' excel VBA, but it gives error on machines that DON'T have oracle client installed (ORA-12154 TNS:Could not resolve service name).

Is there a way to connect to oralce thro' VB WITHOUT installing client by using some other 3rd party driver or some other method-- as we have about 5000 user machines and it does not make sense to install the client on all the machines to have this functionality.


Code:
Dim ProdConnectString as String
Dim conn As New ADODB.Connection

ProdConnectString = "provider=msdaora.1;user id=xyz;password=abc;data source = testsource;option=1+2+8+32+2048+16384"
conn.ConnectionString = ProdConnectString
conn.CursorLocation = adUseClient
conn.Open


Thanks.

-BS

Syntax For Connect To Oracle
hi



any one can help me..i want to establish
a connection with oracle8 using vb...please send me syntax & example or refer to a tutorial link



Thanx in advance

How To Connect To Oracle 8.0 From CRViewer
Hello all,

How can we connect to Oracle 8.0 database from our CRViewer control through code? I know to connect to MS Access. Can anybody tell me similar kind of procedure for Oracle?

Thanks in advance
Satya

Connect To Remote Oracle DB
Hi,

Iam creating an ActiveX control, which will be on a ASP page that should connect to a oracle Db which is in the server. This ActiveX control should access database so that it can update or select data from it.
Can I use ADO to connect to the server? If yes what should be the connection string used for it.
Thanks in advance for your help.

Thanks,
Pres

How To Connect Oracle Using Odbc
Hai all.

I request your valuable help.

I have VB 6.0 and Oracle 8 personnel edition in my system. I would like access oracle database using ODBC. I tried by creating a user DSN through Windows Cotrol Panel. Then while accessing through VB it asks SQL Server login. SQL server is not there. There it terminates. Can someone tell me the exact procedure starting from the very begining, for connecting the Oracle database through ODBC and how to access the data.

Thanking You.

Connect Oracle Database
any ine know how to connect an oracle db ib VB

Oracle Connect Error
dear friends i am having an error in connecting to oracle9i database by adodc control when i press test connection i get "error in initializing provider an oracle error occured but message couldn't be recieved HELP

Connect To Oracle On Solaris Using VB.
Hello Vb Experts

I want to connect to oracle on solaris using VB.

Can anybody help me in the same.

Thanx in advance.



Rajiv Goel
email@removed

VB 6 Failed To Connect Oracle 9i, HELP!!
Hi all,

I encountered problem when using VB 6 with Oracle 9i, can anyone give me some ideas how to solve it? or any other good methods? Many thx...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};" _
& "SERVER=xxx;" _
& "DATABASE=xxx;" _
& "UID=xxx;" _
& "PWD=xxx;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
conn.Open

Error : [Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={Oracle in OraHome92};" _
& "SERVER=xxx;" _
& "DATABASE=xxx;" _
& "UID=xxx;" _
& "PWD=xxx;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
conn.Open

Error : [Oracle][ODBC][Ora]ORA-12560: TNS: protocol adapter error

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I wonder is there any problem about the "DRIVER" or Oracle setup problem?

Best Regard,
dumdum


Cannot Connect To Oracle Database With VB6
I made a form with some textboxes to show the employee details from the emp database of oracle. But I cannot make a connection to oracle through ADODC control or even Data environmrnt. Its showing TNS 21514 error , some problem with server or service name.
How to solve the problem?

ADO Through VB To Connect Oracle Database
hi all,
i am facing a specific problem.
i have written a program in VB6 , using ADO and DBGRID for database connectivity in oracle. I have oracle 8 and VB installed on PC having Windows NT Server 4 as Operating system.
         It works fine when run on this PC. There are some other PCs on LAN which are having Windows NT workstation as operating system, but none of VB, Oracle is installed on them.

What i want to do is to develop a package on Windows NT server 4 PC. and install the project on other PCs on LAN so that they can use the database on SERVER.
i am facing following problems...
1) while creating package following errors come
      a) no dependencies found for MSADO20.TLB
      b) MSSTDFMT.DLL file is out of date
2) when i run package developed by using PDW i get following message while running the programs on PCs on LAN
   " Oracle client and networking components were not found. these components are supplied by oracle corporation and are part of oracle 7.3.3 or higher client software installation. you will not be able to use this provider untill these components are installed."

if i install the client part of oracle on these PCs then following error comes
"Run time error 2147467259 (80004005)
ora-12154: TNS: could not resolve service name"


where is the problem.
what i want to do is to
1) develop a package for the code.
2) install it through setup files on all the computers on LAN ( i don't want to install oracle and VB on these PCs)
3) run the program on these PCs on LAN to access oracle datbase placed on my server through this VB program.

Please help me out

Best regards,
amit

Connect To Oracle From Excel
How can I make a connection to oracle from Excel macro and get all the tables in the excel sheet

The folowing code dint work
Public Sub Connection()
Dim con As New ADODB.Connection
con.Open "DSN=dse", "daim", "fsdf"
End Sub



Thanks

Connect To Oracle On Unix
I am trying to connect to an Oracle 8.1.6 database on a unix Solaris 2.7 box via VB 6.0.
I am using the OLEDB Activex Object library 1.0
I can connect to it fine and even open the recordset BUT
When I try to read the contents of the Recordset I get the error:

Variable uses an automation type not supported in Visual Basic

Why is that?

Connect To Oracle Without Using ODBC
Hi All,

Can it is possible to connect to Oracle in VB without using ODBC ?

How?

Use ADO To Connect To Oracle Database
I use ADO to connect to Oracle Database.I've installed Oracle Net 8 Client.In Oracle SQL PLUS i can connect to Database but in my Program it show error :
"oracle (tm) client and networking component not found, this component are supply by Oracle Company, You must install it"
How I have to do now?

How To Connect To A Oracle Database From Java??
We have few Batch processes which run for payroll and printing checks and report etc etc..We use a combination of UniX,Speedware (4GL language) and Oracle database to accomplish this task. We are planning to replace Speedware with Java and I am wondering the ways to access the Oracle database from Java. If anyone has done anything similar, please provide me with some info.

Thanks

How Can I Connect To An ORACLE Database From Access?
I need to know how can I set up access to read an oracle database

How To Connect The Oracle Database In Network
Hi all,

I am not an experienced programmer.

I am doing a Database project, VB as front end and Oracle as a backend. I know how to connect the Oracle database in a local system. There will be single user in that system. I used to work with MS Access. If we work in network there will be multi user. My question is, If it is a Access database, we know there will be an .mdb file. We can place it in a network drive and share it amoung users. In Oracle how it will be treated? Where all the tables will be stored? How can I share amoung users? If I create a table using SQL it will be stored in a local sytem. Right! Pls help.

Thanks in advance!

CS.

Connect To An Oracle Database Without Using ODBC?
Is there a way to connect to an Oracle database without using ODBC?

Thanks...

Crystal Report (v9) / No Connect To Oracle With VB6
Hello,

i have made an report with Crystal Report (v9) connecting an oracle database. Thatīs well. This Report should be shown in an VB6-Application with the CRViewer9.dll, but I donīt know how to give the connection-parameters.

This Code: (CRViewer9.dll, Craxdrt.dll)

Public rptApp As New CRAXDRT.Application
Public rpt As New CRAXDRT.Report

Private Sub Form_Load()
Set rptApp = New CRAXDRT.Application
Set rpt = rptApp.OpenReport("C:Test.rpt", 1)

CRViewer.ReportSource = rpt
CRViewer.ViewReport
End Sub

With the last CRViewer.ViewReport the Viewer start to load the Report, I see it because reportparamters used from then Report has to give in dialog, but then the loginerror will be shown.

Please help . . .

Sir Dark

Creating A COM Component To Connect To Oracle....
Hi All, I need some help here...

Currently I have an application based on a client-server model where the application connects to an oracle database server through the oracle client (which is installed on every machine).

We want to migrate it to an N-Tier model where the client would not connect directly to the oracle server, but instead it would connect to a Middleware (com?) component running on a dedicated server with the oracle client installed, which would then connect to the oracle database. The middleware piece would handel all the data processing requests.

Since this is the first time I have done something like this I am looking for any tips, example source code etc that would help.

I am very experianced writing queries and front end apps that connect directly to a DB but this N-Tier issue is tripping me up.

Any tips you can offer would be greatly appricated!

Thanks,

Chris Meyer

How To Connect To Oracle Database From VS.Net 2003?
Hi,


Using VS.Net 2003 how can I connect to an Oracle database?
Do you need to install Oracle Client in order to use Microsoft OLE DB Provider for Oracle? Is there a free Oracle Client I can download? Does it have to be the same version as the database or it can be the latest version?
What about using ODP.NET – what do I need to do to use it?

I need a simple example of connecting to Oracle 8 or 9 database and updating few fields in a table.

Thanks in advance,

Connect To Oracle Database In Solaris With VB
Hello everybody,
We have a server with solaris and oracle database.I want to make an application in VB which can fetch data from that server.
Please guide me what to do.
I tried to contact database thru Oracle client on a windows machine but could not do it.
Please help me out.
Thanx i advance

Adodb Connect To Oracle: No Null Date?
Hello,
i've build an application that works connected to an Oracle DB.
i use an adodb.recordset, that i open, and than i disconnect from the DB, to work on it.
i connect the fields to TextBoxes, and every field assume the right value....
except when i try to delete a value inside a data field!

i mean:
i can insert a date, i can modify it.... no problem on it!
but if i delete the value inside the textbox, in the recordset there's the last data value... not NULL!!!

any suggestion?

Connect To Oracle From Visual Basic Remotely
have a computer with no oracle installed, but visual basic 6 is installed

i am trying to connect to a machine where oracle is installed, when i am trying

to create an driver for MICROSOFT ODBC FOR ORACLE in my machine, i am getting the error

"The oracle(tm) client and networking components were not found. These
components are supplied by oracle corporation and are part of oracle version 7.3

(or greater) client software installation.

You will be unable to use this driver until these components have been installed."



my system (system A) is windows xp, visual basic 6

another system (system B) is windows 95, oracle 7.3...

i want to create tables in system B, and with the help of vb code in system A,

i want to update / insert tables in system B...


what steps should i take?

is it ok if i install the appropriate drivers in both the systems, that is the same drivers

in both the systems for this to work ? apart from lan??

How To Connect All Possible Way Of Oracle And Sql Server With Visual Basic Using ADO
Hi,

I am trying to use oracle8i and SQL SERVER2000 in my visual basic6 application.

I need to make connection between oracle and visual basic and sql server and visual basic

Please help me out all possible way of connection.

Thanks.

Crstal Report Connect With Oracle Problem
I am using Oracle 8.0.6.0.0 as my database, when I connect the crystal report through ODBC or OLE DB, I was successful to connect, however, I can't see all of the tables in the "Database Expert". I have over 30K tables in my database. Can someone help me?? Thank you!!

How To Connect Oracle Server (Crystal Reports 8) With VB 6
Hello everyone, I need your help.
I need to make a report in a Vb's project using oracle server of Crystal Reports but I don't know how to establish the cennection into VB, do you know how is the connection string that I have to introduce in the code?????

I appreciate your help.....thanks a lot

MS-ACCESS Version Oracle CONNECT BY PRIOR
Hi,

Can anybody tell me what the MS-ACCESS version for Oracle's CONNECT BY PRIOR is? (to make a hierarchy structure I.e. Mother - Child relations visible!)?

Thanx

John

How Connect VB6 Application (ADODB And ADODC) With Oracle Database
Hi every body
I hope Every one is fine in good health.

I am a programmer in vb6,so far I use back end as SQL SERVER AND MSACCESS
but now I have to use Oracle as back end ,I am not able to connect to oracle.
I use adodc control -> from properties of adodc -> I select Build ->
then I select oracle drivers, after this is is asking me for datasource name
and server name, from here I cant Proceed Can any one help me.

 case 1 : consider i am working on home PC with win 98 and oracle 8 /7.3
           installed on my pc (No seperate oracle Server) and I like to use
           Default Tables of oracle (i.e emp,dept ...).
    
 
         1. what should be the Server name and Database name in this case?

         2. what should be the User name so that any user can use this application
             his own username and password?

 case 2: consider the same above senario in client server environment.

 Please Write for both types (ole db) and (odbc).

How To Connect Vb 6.0 And Oracle 10G ?remember Its A Client Server Kind Of Thing
hello everybody,

                        How can I connect VB 6.0 and Oracle 10G ? Its like client and server connection where i will need a connection string as told my professor but please tell me the whole procedure for connecting them as I am totally new to it. So please dont say that its same as vb and oracle 9i please give me some proper guidence thanks everybody

Copyright Đ 2005-08 www.BigResource.com, All rights reserved