473,473 Members | 2,243 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Oracle database connectionstring problem

88 New Member
What's the connectionstring to connect to the Oracle9.0 Database Server irrespective of servername,username and password using VB.Net2002 (.Net framework 1.0)?

In case of Microsoft SQL Server the connectionstring is something like:
"Provider=MSOleDB4.0; Server=localhost; Datasource=pubs;
Integrated Security=SSPI".
'Server=localhost' allows the front-end application to identify the database server irrespective of servername. 'Integrated Security=SSPI' allows the front-end application to connect to the database irrespective of username and password.

But I'm looking for the Oracle counterpart of the connectionstring (Provided I'm not using TNS).
In my case I'm simply calling a module that contains a procedure having the connectionstring. I'm providing all the requsites in it namely- Provider, Hostname, Database/Schema name and Password (the default 'scott' and 'tiger' respectively). It looks something like this:
"Provider=MSDAORA 4.0, Server=Self, Username=scott, Password=tiger"
(Server=Self, this is the name of the oracle db sever in my machine).
If it succeeds, it'll open up another form or proceed to some other code fragment. But what happens if the oracle db server needs to be re-installed with a different name (something other than Self) at a later time or the username or password gets changed? I'll have to change the core code again and again. That's what I wanna skip. This portion is kinda foggy to me. Can anybody give me the exact connectionstring?
Nov 5 '07 #1
1 2170
debasisdas
8,127 Recognized Expert Expert
You need to frame the connection string dynamically at run time by taking value from user input. Let the user enter the username,password and connection string.
Nov 6 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
0
by: ʹÃûÑï | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access...
6
by: ´ï´ï | last post by:
How to connect asp.net with Oracle Database? Where and How to? Thanks very much.
1
by: Top Poster | last post by:
Hi all, I am trying to work out how I can use impersonation to connect to an Oracle 9i database such that I can avoid sending a clear text username and password to the Oracle server. We are...
0
by: simonth | last post by:
hi guys i m writing a VB.NET app using the Oracle Lite database as the data source. Got a problem with inserting unicode chars e.g. chinese into the database when using the dataadapter and...
1
by: noor | last post by:
Hi, I'm trying to connect to my Oracle 10g Database i m facing the problem of connection string, following code is that i use, please tell me how to use the connection string for accessing the...
1
by: Magnus Flisberg | last post by:
Best programmer, My mission is to execute a sql statement in vb.net and retrive the data into a file. I have managed to detect som issues with my code: queryString = "SELECT ...." ...
1
by: priyamtheone | last post by:
What's the connectionstring to connect to the Oracle9.0 Database Server irrespective of servername,username and password using VB.Net2002 (.Net framework 1.0)? In case of Microsoft SQL Server the...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.