BreakPoint

cancel
Showing results for 
Search instead for 
Did you mean: 

can connect to Oracle db in LabVIEW, not Python

This works:

jcarmody_0-1662046953637.png

This doesn't:

jcarmody_1-1662047069104.png

 

The "Data source name not found" confuses me because I'm not trying to use a DSN, and it works in LabVIEW.  What am I doing wrong?

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 Kudos
Message 1 of 2
(1,356 Views)

You blurred out the interesting part.

 

Not the user name and password, or even the data source, but the beginnings of those strings.

 

What is interesting is if and how those strings are quoted...

 

If there are spaces in the string (esp. data source) it probably needs to be quoted. If it is quoted, the Python string needs to be double quoted, or the quotes need to be escaped. (See for instance python - Single quotes vs double quotes - Stack Exchange).

 

This could be nothing, but again, we can see...

 

Another thing is the bitness. Maybe LV 64 bit and Python 32 bit? Or LV 32 bit and Python 64 bit? Those drivers can be picky that way...

Message 2 of 2
(1,329 Views)