ODBC question.

From: Maikel van Gorkom <M.P.vanGorkom_at_KUB.NL>
Date: Fri, 01 Oct 1999 16:22:11 GMT
Message-ID: <7t2g2j$t3m$1@mailnews.kub.nl>

Hoi All,

First of all, i'm not a oracle whizzkid so please keep it simple, Thanx in advance.

I'm trying to connect a piece of software (Tasktimer 4.0) to a Linux Server (redhat 6.0 incl. updates to make oracle run)running Oracle 8.0.5 using oracle ODBC driver version 8.00.0400.

Let me explain what Tasktimer is: It is agenda software. Now the software needs a database to put all the info in. Now we want it to put the data in a oracle database.

Here is the problem:

I've configured the Linux server and installed Oracle, the default database is running and the listener is listening.

I can read from the database using MS. Access 97, when i write to it using MS. Access, MS A. gives the error: ODBC--call failed.

When i try to start Tasktimer for the first time i have to build the database it wants to use. So i configure the ODBC zo that he has all (i think) rights to the database (i've tried it as sys, system and tasktimer (selfmade user)) but everytime it give the errormessage : (translated from dutch) The fields have not been found.
I think it can not create the database

I can't figure out what to do next! Do i need to create a new user with what rights and how do i need to do this. Do i need to create a empty database, how do i do this?!

THANX IN ADVANCE Received on Fri Oct 01 1999 - 11:22:11 CDT