Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1576
  • Last Modified:

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
0
Alaska Cowboy
Asked:
Alaska Cowboy
  • 4
  • 3
1 Solution
 
boriskalavskyCommented:
You should have renamed drives in Windows.
0
 
boriskalavskyCommented:
E:\ to K:\
F:\ to E:\
K:\ to E:\
0
 
Alaska CowboyAuthor Commented:
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
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
boriskalavskyCommented:
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?
0
 
Alaska CowboyAuthor Commented:
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
0
 
Alaska CowboyAuthor Commented:
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.
0
 
Alaska CowboyAuthor Commented:
Boris, sorry I've been away. Can you provide some suggestions for my 5/25 7:14am comment?

Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now