Can't create Oracle ODBC connection
I set up Personal Oracle set up on an external hard drive ("E:\"). Everything was fine, ODBC drivers worked great.
Then I got a 2nd external hard drive, and it somehow took over "E:\" drive and my first drive (with Oracle) became "F:\" drive.
I got most things back in order by editing the Registry, so my IDE (Pl/Sql Developer) was out of commission until I changed the Registry, that's fine now.
But now I can't create an Oracle ODBC driver. I went back to the Registry and changed "Oracle in OraHome92" in ODBCINST.INI to point to "F:\" drive. That allowed me to start to set up an Oracle ODBC connection, but when I went to test the connection, I got an error:
"Unable to connect. SQL State = IM004. [Microsoft][OCBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
Any ideas? I looked around in the Registry for something like this but with no luck.
Thanks.
Bill
Then I got a 2nd external hard drive, and it somehow took over "E:\" drive and my first drive (with Oracle) became "F:\" drive.
I got most things back in order by editing the Registry, so my IDE (Pl/Sql Developer) was out of commission until I changed the Registry, that's fine now.
But now I can't create an Oracle ODBC driver. I went back to the Registry and changed "Oracle in OraHome92" in ODBCINST.INI to point to "F:\" drive. That allowed me to start to set up an Oracle ODBC connection, but when I went to test the connection, I got an error:
"Unable to connect. SQL State = IM004. [Microsoft][OCBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
Any ideas? I looked around in the Registry for something like this but with no luck.
Thanks.
Bill
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
boris,
That's a great tip, but can I correct the situation without re-naming the drives.
After switching the registry to "F:\", I'm just a little nervous about switching back.
Do you think there's some registry item I missed changing? Or anything else I can do without re-naming the drive?
Thanks.
Bill
That's a great tip, but can I correct the situation without re-naming the drives.
After switching the registry to "F:\", I'm just a little nervous about switching back.
Do you think there's some registry item I missed changing? Or anything else I can do without re-naming the drive?
Thanks.
Bill
There a lot of thinngs that need to be changed in Registry as well as Oracle Inventory etc.
Very easy to miss things. Do you know what you changed in registry? Did you backup registry before doing it?
Very easy to miss things. Do you know what you changed in registry? Did you backup registry before doing it?
ASKER
Boris, hi, sorry for the delay.
No I didn't back up the registry - how do you do that?
It seemed so easy, I just changed Oracle things from "E:\" to "F:\". It worked for the main thing I was doing but then the ODBC Oracle driver lost its mind.
OTHER ISSUES:
not sure if this is related or not, but now I can't see my imaged checks from my bank. I get an error message "Java Plug-in 1.3.1_01 cannot be located because values in the registry key . . . . cannot be located". But I actually have Java Plug-in 1.3.1_09 in the spot where the 1.3.1_01 is supposed to be.
Also, not sure if it is related or not, but now my wireless connection doesn't work. Two other PC's at home have wireless connections fine, but now I'm having fits. It says it is connected to the WAP, but it is not receiving packets.
I ran a script, "Java Virtual Machine scripten", that I got from the network guy at work, that didn't seem to change anything.
Also, I checked Internet Explorer, Advanced tab, then in Microsoft VM, I have the first and third boxes checked.
Bill
No I didn't back up the registry - how do you do that?
It seemed so easy, I just changed Oracle things from "E:\" to "F:\". It worked for the main thing I was doing but then the ODBC Oracle driver lost its mind.
OTHER ISSUES:
not sure if this is related or not, but now I can't see my imaged checks from my bank. I get an error message "Java Plug-in 1.3.1_01 cannot be located because values in the registry key . . . . cannot be located". But I actually have Java Plug-in 1.3.1_09 in the spot where the 1.3.1_01 is supposed to be.
Also, not sure if it is related or not, but now my wireless connection doesn't work. Two other PC's at home have wireless connections fine, but now I'm having fits. It says it is connected to the WAP, but it is not receiving packets.
I ran a script, "Java Virtual Machine scripten", that I got from the network guy at work, that didn't seem to change anything.
Also, I checked Internet Explorer, Advanced tab, then in Microsoft VM, I have the first and third boxes checked.
Bill
ASKER
Boris,
you mentioned a lot of things need to be changed in Registry - such as what? I got everything under oracle but are there other things I can look at?
Thanks.
you mentioned a lot of things need to be changed in Registry - such as what? I got everything under oracle but are there other things I can look at?
Thanks.
ASKER
Boris, sorry I've been away. Can you provide some suggestions for my 5/25 7:14am comment?
Thanks.
Thanks.
F:\ to E:\
K:\ to E:\