Subscribe Bookmark RSS Feed

Oracle and JMP 12

larssimony

Community Trekker

Joined:

Sep 1, 2014

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
Solution

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

3 REPLIES
Solution

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

Community Trekker

Joined:

Sep 1, 2014

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

Community Trekker

Joined:

Sep 1, 2014

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

Thanks for your help.

Lars