getting 'exit status 3221225595' when trying to run a simple connect test about ora HOT 10 CLOSED

@klauern ok, it seems that a lack of VC++ won't be a problem lol. Can you please check that:

1. Your Oracle client is 64 bit
2. C:\instantclient_12_1 is in your PATH

I managed to reproduce the exact same error (exit status 3221225595) by putting only the 32 bit version in my PATH and trying to run with 64 bit Go. When I removed it from PATH I got error 3221225781 instead.

from ora.

Hi Nick,

Can you try resetting your env variables using forward slashes? I think Go is used to unix format only. For example, for your installation:

CGO_CFLAGS=-IC:/instantclient_12_1/sdk/include/
CGO_LDFLAGS=C:/instantclient_12_1/oci.dll

If that doesn't work I would try the TDM GCC compiler if you aren't already.

Let me know how it goes.

Thank you,

Rana

from ora.

@klauern do you have msvcr100.dll (64 bit) somewhere in your PATH? If not, try installing this: http://www.microsoft.com/en-us/download/details.aspx?id=14632

from ora.

Maybe this is 'cause we now (since 954d56e) automatically call ora.Register, and if the DLL is not loadable, then it panics.

The cause is the missing/misconfigured DLL, but the symptom (error on import) is 'cause the automatic import calls OpenEnv right on import.

from ora.

@rana I changed it to forward slashes (/), but the same result came back

@ricsmania I tried downloading that, but I got an error

from ora.

As for what I do have installed, here's the list of Visual C++ things:

from ora.

Ah, that did it. I didn't have c:\instantclient_12_1 in my path, and--because it was pushed to my machine from IT-upon-high--I had a much older (and probably 32-bit) c:\ORACLE\ora102 in my path as well.

from ora.

The fix for me was just ensuring that the C:\instantclient_12_1 preceded other things in my path and the import worked. I still have some issues with my code, but I don't get the error anymore.

from ora.

I don't see anything in the installation instructions about putting that in my path, so that could be why things didn't work. I simply downloaded and unzipped the instant client on my computer and set those two CGO_ flags.

from ora.

Glad to hear it worked @klauern. Maybe it's not in the installation instructions because this is not required to build the application, only to run it. But a reminder there would definitely help.

from ora.