topic Oracle and JMP 12 in Discussions

Oracle and JMP 12

larssimony — Thu, 26 Nov 2015 12:59:36 GMT

I have created a JSL i JMP 11.1.1 which connects to my Oracle database and runs fine with following code:

Clear Globals();

databaseConfig = "DRIVER={Oracle in OraClient11g_home1};DBQ=MyServicenameFromOra;UID=MyLogin;SPWD=MyPassword;";

sql =

select *

from MyTable

MyData = Open Database( databaseConfig, sql, "My Data" );

Why can't I use same code in JMP 12.1.0?

Iget following error message in log:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

If I go back to JMP 11.1.1 it works fine again. I have both versions of JMP installed.

I have Oracle driver installed with a TNSNAMES.ORA file.

Lars

Re: Oracle and JMP 12

pmroz — Mon, 30 Nov 2015 13:41:54 GMT

Hi Lars,

I can connect to Oracle using JMP 11.2.1 and 12.1.0 with no problem. Are the two versions the same "bit-ness"? I.e. 64-bit JMP needs 64-bit Oracle, and 32-bit JMP needs 32-bit Oracle.

Not sure if it's a typo, but my connection string has PWD, not SPWD.

Regards,

Peter

Re: Oracle and JMP 12

larssimony — Tue, 01 Dec 2015 13:02:55 GMT

Hi Peter

Sorry, it was a typo when I removed my password ect.

I will try installing a 64 bit Oracle driver to my 64 bit JMP.

Regards,

Lars

Re: Oracle and JMP 12

larssimony — Tue, 01 Dec 2015 13:07:40 GMT

Just noticed my JMP 11 is 32 bit and 12 is 64 bit.

Thanks for your help.

Lars