LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Set password for DSN (SQL Toolkit)

Hello everybody,
I'm working on WinNT4.0 with LV5.1.1 and SQL Toolkit v5.0. I've got an ODBC
DSN for an Oracle7 database. I'm asked for a password when I make a connection
to the DSN, which I now enter manually.
After that I can read and write data to the database.
Does anybody know how I can set the password automatically with the SQL Toolkit
to avoid the dialog ?
Otherwise there always has to be a user present when a connection to the
database is made, which would be very unkomfortable.
Is there any solution ?

Many thanks in advance.
Ralf.
0 Kudos
Message 1 of 2
(3,011 Views)
Wire a string constant to the SQL Connect VI's Connection Parameters input
and include the appropriate connection parameters. For MS SQL7 the info
looks like this:
UID=username;PWD=password
I don't use Oracle, but I imagine it would be similar. If your unsure, create
a file DSN using the ODBC administrator in NT and mimic the parameters it
creates.

"Ralf Erdmann" wrote:
>>Hello everybody,>I'm working on WinNT4.0 with LV5.1.1 and SQL Toolkit v5.0.
I've got an ODBC>DSN for an Oracle7 database. I'm asked for a password when
I make a connection>to the DSN, which I now enter manually.>After that I
can read and write data to the database.>Does anybody know how I can set
the password automatically with the SQL Toolkit>to avoid the dialog ?>
Otherwise
there always has to be a user present when a connection to the>database is
made, which would be very unkomfortable.>Is there any solution ?>>Many thanks
in advance.>Ralf.>
Message 2 of 2
(3,011 Views)