Secure ACCESS 97 SQL toolkit

[swatzy@my-deja.com]

I've been trying all day to get my VI to connect to a Secured Access
Database, using UID and PWD as the connection string to no avail. Has
anyone else been through this or am I doing something stupid.
I can get to the database by logging in via the dialogs provide with
Access, but not using the LabVIEW database browser or the SQL connect
vi.
Please help!!!


Sent via Deja.com http://www.deja.com/
Before you buy.

[Dennis_Knutson]

Access security is a little weird. When you setup your odbc driver, under
System Database, select the Database control and then click the "System Database..."
button. You'll then have to find and select the .mdw file that is associated
with the database that you're using. The .mdw file contains the security
information.

swatzy@my-deja.com wrote:
>I've been trying all day to get my VI to connect to a Secured Access>Database,
using UID and PWD as the connection string to no avail. Has>anyone else been
through this or am I doing something stupid.>I can get to the database by
logging in via the dialogs provide with>Access, but not using the LabVIEW
database browser or the SQL connect>vi.>Please help!!!>>>Sent via Deja.com
http://www.deja.com/>Before you buy.

[Jared 323]

I'm new to this database stuff too, but i might be able to help. I got a vi
from NI that does the task of registering ODBC data sources so this task
can be automated (first time boot). When building the attributes input,
each seperate item must be seperated from the last (and the whole string
terminated with) a null string (\00). So to send user id and password the
string is built like : UID=Me\00PWD=pswd\00. I dont know how you seperate
each connection parameter that is sent to the VI in your case. This might
help.

Jared

swatzy@my-deja.com wrote:
>I've been trying all day to get my VI to connect to a Secured Access>Database,
using UID and PWD as the connection string to no avail. Has>anyone else been
through this or am I doing something stupid.>I can get to t
he database by
logging in via the dialogs provide with>Access, but not using the LabVIEW
database browser or the SQL connect>vi.>Please help!!!>>>Sent via Deja.com
http://www.deja.com/>Before you buy.

[wiebe@CARYA]

I've had this problem, using SQLServer. I've wired the DSN normally, to the
connection parameters, I've had to wire:

Trusted_connection=NO;
DSN=DSN_NAME; >again!!!<
UID=user_id;
PWD=user_password;

With SQLServer, if you do not add Trusted_connection=NO, the system will
automaticlly connect using windows (nt) account. It will ignore the UID and
PWD.

Please let us (=group) know if this works for Access too.

Regards,

Wiebe Walstra.

--
AIR technical Automation
www.air.nl
wrote in message news:8vbn6p$kns$1@nnrp1.deja.com...
I've been trying all day to get my VI to connect to a Secured Access
Database, using UID and PWD as the connection string to no avail. Has
anyone else been through this or am I doing something stupid.
I can get
to the database by logging in via the dialogs provide with
Access, but not using the LabVIEW database browser or the SQL connect
vi.
Please help!!!


Sent via Deja.com http://www.deja.com/
Before you buy.