Can't verify Oracle datasource

[KatieAron]

HI there, I'm using CF 5.0 (on Windows 2000) and for the first time ever I'm
connecting to an oracle database (on Solarus Unix) rather than a sql database.
I got the System DSN set up properly in the Control Panel and the 'Test
Connection' button successfully connects, but when I go to the CF Administrator
and see the DSN that's listed in the 'ODBC Datasources' page for 'Oracle in
OraHome92' (the one that showed up automatically after I put it into the
Control Panel), it is unable to verify even when I put the username and
password into the CF Datasource Info page. Am I missing something? Do I need
to also enter some type of connection string? If so, what would be the format?
I know I have the driver installed properly and I know I can connect to the
database through the Control Panel's ODBC Datasource area, so why can't I do it
from the CF admin? By the way, when I try to access a CF page that uses this
Oracle datasource it gives this error: Error Diagnostic Information ODBC Error
Code = S1010 (Function sequence error) [Microsoft][ODBC Driver Manager] The
driver is incapable of supporting the current environment attributes. Data
Source = 'PROD3' Any help would be much appreciated. I'm under the gun here
to get this connection up and running. THANK YOU!!! -Katie :-):confused;

[KatieAron]

I figured out what the problem was. It was simply that the server hadn't been
rebooted after the Oracle 9i installation. The installation never said to
re-boot, and I assumed re-starting the CF service would be enough, but it was
not. Once I rebooted, the datasource was able to verify in the CF Admin and I
was able to query without error. What a simple fix! If only everything were
that easy. :-)