Problem with Oracle connection Scriptcase 8.1

Scriptcase 8 Discussion
#1

Hello,
i configured an Oracle connection and the test works fine but when i try to create an application and i select the database i receive an error :
Scriptcase could not connect with the database OR there are no tables imported in this database. You might fix this by doing one of the following options:

  • Check the parameters of the connection at [B]Edit Connection[/B].
  • Make sure you have imported your application tables to this new database.
The user of the connection is the owner of the schema data an there are a lot of tables. It is a 11g r2 Oracle db and i'm usign the 12c istant client 32 bit.

What could be the problem (the test connection works) ?

Gianpaolo

#2

Do you mean that you can not connect on your scriptcase development server or is it that you can not connect on your deployment server?
I suggest first to use the instant client commandline sqlplus to connect to the database. That HAS to work, if it doesnt then your settings of the client are wrong.
connect username/password@databasename is the thing you need to do.
Also be aware that the instant client directory MUST be in your path settings on your deployment (and development) server. Generaly if you run for example apache as service (assuming you are using windows) then the dos paths are not copied in the environment.

#3

Hi.
i mean my scriptcase development server:
i create the connection and with the test button it works
if i use database builder the connection works and i can see all the tables
but if i try to create an application i have the error of my first post.

#4

Ok, I solved the problem.
I wasn’t due to connection but to the fact that the user was in lowercase and Oracle use the upper case .
Usually it is handled automatically

Regards
Gianpaolo