Hi,
I am trying to connect to an SQL database in a script using the
Open Database command.
Now, when I work interactively, I create a "Machine Data Source" from
the database conect widget. When I connect, a window opens up asking
for username and password. When I insert them, I can succesfully connect
to the database and import tables into JMP.
So I would like to try the same from a script. Unfortunately, I don't see
where I would insert the username and password. When I try to connect
I get the following error message in the log window.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
I guess this is not surprising since I didn't specify how to authenicate...
The code is
DataBase = Open Database(
"DSN=myDatabase", // data source
"myTablename", //table
"JMPtable" // new table name
);
So how can I specify my authentication details?
Ciao,
Paolo