Hello,
I have a mdb file(ms access) that connects to an oracle database using a
userID and password.
Now, I created a software to run this file and excute a query.
To be clear, the file has a query called "TRADES" that will select all
trades of a day for example.
So, the C# software opens the file and the query "Select * from TRADES".
That works well because I used the OleDB connection.
The problem is that when I open the file, it asks for the password ... how
can I set it automatically?
What is worse is that it used to work properly but not anymore! >_<
I hope someone will help me!
Thank you!
5  1407 
Is there any particular reason you can't have your app talk directly to
Oracle? Is the Access file doing any data processing? If all your access
file is doing is merely turning around and calling queries in Oracle you'll
have less maintenance and better performance to cut out the middle man and
talk directly to Oracle.
--
Andrew Faust
andrew[at]andrewfaust.com http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:F6**********************************@microsof t.com...
Hello,
I have a mdb file(ms access) that connects to an oracle database using a
userID and password.
Now, I created a software to run this file and excute a query.
To be clear, the file has a query called "TRADES" that will select all
trades of a day for example.
So, the C# software opens the file and the query "Select * from TRADES".
That works well because I used the OleDB connection.
The problem is that when I open the file, it asks for the password ...
how
can I set it automatically?
What is worse is that it used to work properly but not anymore! >_<
I hope someone will help me!
Thank you!
Yes, the access file process data. The software is just made to automate a
task.
I (actually a colleague) found a solution.
I hard coded the password in the reistry, under local machine/softwares/ODBC.
Thank you for your time.
"Andrew Faust" wrote:
Is there any particular reason you can't have your app talk directly to
Oracle? Is the Access file doing any data processing? If all your access
file is doing is merely turning around and calling queries in Oracle you'll
have less maintenance and better performance to cut out the middle man and
talk directly to Oracle.
--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:F6**********************************@microsof t.com...
Hello,
I have a mdb file(ms access) that connects to an oracle database using a
userID and password.
Now, I created a software to run this file and excute a query.
To be clear, the file has a query called "TRADES" that will select all
trades of a day for example.
So, the C# software opens the file and the query "Select * from TRADES".
That works well because I used the OleDB connection.
The problem is that when I open the file, it asks for the password ...
how
can I set it automatically?
What is worse is that it used to work properly but not anymore! >_<
I hope someone will help me!
Thank you!
Fair enough. You could also pass the username, password along on the
Connection String rather than storing it in the registry.
Connectionstrings.com is the location I usually go to when I need to figure
out how to build a connection string for some database. http://www.connectionstrings.com/
--
Andrew Faust
andrew[at]andrewfaust.com http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:55**********************************@microsof t.com...
Yes, the access file process data. The software is just made to automate
a
task.
I (actually a colleague) found a solution.
I hard coded the password in the reistry, under local
machine/softwares/ODBC.
Thank you for your time.
"Andrew Faust" wrote:
>Is there any particular reason you can't have your app talk directly to
Oracle? Is the Access file doing any data processing? If all your access
file is doing is merely turning around and calling queries in Oracle
you'll
have less maintenance and better performance to cut out the middle man
and
talk directly to Oracle.
--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:F6**********************************@microso ft.com...
Hello,
I have a mdb file(ms access) that connects to an oracle database using
a
userID and password.
Now, I created a software to run this file and excute a query.
To be clear, the file has a query called "TRADES" that will select all
trades of a day for example.
So, the C# software opens the file and the query "Select * from
TRADES".
That works well because I used the OleDB connection.
The problem is that when I open the file, it asks for the password ...
how
can I set it automatically?
What is worse is that it used to work properly but not anymore! >_<
I hope someone will help me!
Thank you!
That's the website I usually use too ^_^
I had tried as you said but that didn't work ... Maybe I did it wrong ...
"Andrew Faust" wrote:
Fair enough. You could also pass the username, password along on the
Connection String rather than storing it in the registry.
Connectionstrings.com is the location I usually go to when I need to figure
out how to build a connection string for some database.
http://www.connectionstrings.com/
--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:55**********************************@microsof t.com...
Yes, the access file process data. The software is just made to automate
a
task.
I (actually a colleague) found a solution.
I hard coded the password in the reistry, under local
machine/softwares/ODBC.
Thank you for your time.
"Andrew Faust" wrote:
Is there any particular reason you can't have your app talk directly to
Oracle? Is the Access file doing any data processing? If all your access
file is doing is merely turning around and calling queries in Oracle
you'll
have less maintenance and better performance to cut out the middle man
and
talk directly to Oracle.
--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com
"kurisutofu" <ku********@discussions.microsoft.comwrote in message
news:F6**********************************@microsof t.com...
Hello,
I have a mdb file(ms access) that connects to an oracle database using
a
userID and password.
Now, I created a software to run this file and excute a query.
To be clear, the file has a query called "TRADES" that will select all
trades of a day for example.
So, the C# software opens the file and the query "Select * from
TRADES".
That works well because I used the OleDB connection.
The problem is that when I open the file, it asks for the password ...
how
can I set it automatically?
What is worse is that it used to work properly but not anymore! >_<
I hope someone will help me!
Thank you!
re changing the registry to get password less access to oracle database through access database
good temp fix, but what would the "proper" way using a connection string?
Gordon
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: xtanto |
last post by:
Hi All,
We need to develope application & report that run on windows accessing
Oracle on Linux. and we use Crystal Report as reporting tool.
Can Crystal Report on windows access...
|
by: tristant |
last post by:
Hi All,
I am the poster of the thread : 'Has anybody succesfully used VB.NET on
Oracle on UNIX ? '
Some has teplied that It will be just fine.
I forget to mention, we are using Crystal report...
|
by: pembed2003 |
last post by:
Hi all,
I have to write a C++ application to access some data from an Oracle
database. I will be using gcc running on Solaris. Can you tell me how
to do this if it's possible? Some sample code or...
|
by: DFS |
last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security
in place, ODBC linked tables.
100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters
and ReadOnly....
|
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...
|
by: noor |
last post by:
HI
Now a days I m building a web site using ASP.NET with Oracle 10g 10.1.0 as
back hand . I have set uped the server well but when i Tried to connect
through that server programaticaly from...
|
by: Reshmi Jacob |
last post by:
Hi
I am a beginner, don't know much about oracle. Pls help me in this....
Our oracle server is a system with Win XP OS. When the firewall is turned on, no network users can access the oracle...
|
by: danish |
last post by:
Hi,
Can anyone tell me how to access oracle from php. Im using CentOS 4
with php4 already installed. From what I found after a bit of
googling...php will have to be recompiled with oracle...
|
by: Jesse Houwing |
last post by:
Hey all,
I've been asked for a customer to write a piece of data access using
EntLib 2.0. I'd like to use the standard entlib database factory class
because a transition to SQL Server is still a...
|
by: Francois Stander |
last post by:
Hi,
I am struggeling to connect to an Oracle db 10.2 through vb.net.
Oracle client is installed on my maschine, Oracle.DataAccess in referenced in my app. this is how my code looks like:
Dim...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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,...
| | |
