Subscribe Bookmark RSS Feed

JMP Connection with OLEDB Providers

jwubbel

Community Trekker

Joined:

Oct 26, 2011

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.

2 REPLIES
mfisher

Community Trekker

Joined:

Jun 23, 2011

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.

stan_koprowski

Community Manager

Joined:

Aug 8, 2012

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