Connecting Tech Pros Worldwide Help | Site Map

oracle backend connection

SalimShahzad
Guest
 
Posts: n/a
#1: Nov 13 '05
dear gurus,

i have converted database from access to oracle due to lack of capacity
soring limits in access.

now i can see all tables of oracle via using ms access front end, using
ODBC connection very easy.

but the issue is that, on every time whenever i open any forms of
access, it ask me database password, however userid,dbname,dsn name is
gtg from odbc connection. there is no option to save password

so can any one tell me how it can be done via programming on opening
forms and populate ms access fields or say form is connected directly
to oracle.but again it asks one time password that is very bed 4 us and
our staff to show them this secret truickyway

ur students,
salim shahzad

ByteMyzer
Guest
 
Posts: n/a
#2: Nov 13 '05

re: oracle backend connection


"SalimShahzad" <salimshahzad@gmail.com> wrote in message
news:1111923689.463104.297280@g14g2000cwa.googlegr oups.com...[color=blue]
> dear gurus,
>
> i have converted database from access to oracle due to lack of capacity
> soring limits in access.
>
> now i can see all tables of oracle via using ms access front end, using
> ODBC connection very easy.
>
> but the issue is that, on every time whenever i open any forms of
> access, it ask me database password, however userid,dbname,dsn name is
> gtg from odbc connection. there is no option to save password
>
> so can any one tell me how it can be done via programming on opening
> forms and populate ms access fields or say form is connected directly
> to oracle.but again it asks one time password that is very bed 4 us and
> our staff to show them this secret truickyway
>
> ur students,
> salim shahzad
>[/color]
You will need to modify the connection string to include the UserID and
Password. For example:
....DSN=MyDSN;UID=MyUserID;PWD=MyPassWord;...


deko
Guest
 
Posts: n/a
#3: Nov 13 '05

re: oracle backend connection


> i have converted database from access to oracle due to lack of capacity[color=blue]
> soring limits in access.[/color]

On what platform are you running Oracle? Windows? Linux? Solaris?



Closed Thread