Check with the database administrator that you have the correct Oracle
service name entered in the DSN configuration. The service name refers
to the database used for the connection. The service name is a string
that is the global database name, a name that comprises the database
name and domain name, for example ssa.acgov.org
Also check that have the correct SID. In the DSN configuration dialog,
there generally is a "Test Connection" button. It is useful to see if
that works!
Jason
On 10/27/06, Raffe, Sydelle, SSA <
[hidden email]> wrote:
> I found this problem posted a couple of years ago in the archives:
>
> >Warning. Command name: GET DATA
> >SQLExecDirect failed :[Oracle][ODBC][Ora]ORA-24324: service handle not initialized
>
>
> We just installed ver 12 making sure the data accesspack was also installed. But, we got the same message.
>
> Besides making sure that the odbc data accesss pack was installed, the other suggestion was to make sure we had the appropriate Oracle client libraries -- how would we go about that?
>
> Thanks.
>
> Sydelle Raffe, Alameda County Social Services Agency
> Information Services Division
> e:mail:
[hidden email]
> phone: 510-271-9174 fax: 510-271-9107
> If you have a request for information, please submit an ODM request form at:
https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm>
Locked
