nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

6755_en-US

liliconcom

JMP Connection with OLEDB Providers

While we have no trouble with regular ODBC database connections, can anyone advise on if JMP supports OLEDB connections using a PROVIDER within a script. I am trying to use the string connection information from a udl file I created that does a successful connection test to the database, however JMP seems to insist on having a DSN specified and that string does not work with Open Database or Create Database Connection callson. TIA.

Re: JMP Connection with OLEDB Providers

Hi John,

I just created OLEDB Database Tools Addin to help with this task.

Try it out and let me know what you think.

Best,

Stan

Re: JMP Connection with OLEDB Providers

The last time I checked ODBC was the only option. However, if you have a SAS server, you can query data via OLEDB, Oracle, Sybase, etc. if you use JMP to connect to the SAS server and submit pass-through SQL code using those database connections.

Comments

There are no comments yet