cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
larssimony
Level I

Oracle and JMP 12

Hi

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

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: Oracle and JMP 12

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

View solution in original post

3 REPLIES 3
pmroz
Super User

Re: Oracle and JMP 12

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

larssimony
Level I

Re: Oracle and JMP 12

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

larssimony
Level I

Re: Oracle and JMP 12

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

Thanks for your help.

Lars