C#, MS ACCESS and Oracle

[Guest]

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!

 

[Andrew Faust]

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.

 

[Guest]

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.

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

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!

 

[Andrew Faust]

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

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.

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

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!

 

[Guest]

That's the website I usually use too ^_^
I had tried as you said but that didn't work ... Maybe I did it wrong ...

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

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.

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


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!

 

[Gordon Moore]

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