Thought inc.

The Dynamic O/R Mapping Company
     

CocoBase Technical Support Forums
For access to developer site with software download and doc's, please request CocoBase download and password
will be emailed to you. Response to posts will appear when answered by THOUGHT Support team.
NOTE:You must register separately with forum in order to post your questions, please click on register icon below.
Home   Frequently Asked Questions   Search   Edit your profile   Registration is free!  
Email This Page to Someone!
Show a Printable Version
CocoBase Enterprise O/R Forums > Forum Francais Questions
ODBC et Oracle (question de debutant)
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
entdemo
Member

Registered: Jul 2001
Posts: 64

J'ai acc?s ? une base Oracle avec un sch?ma par d?faut.
Apres avoir configur? Cocoadminlocal.properties pour qu'il prenne en compte le pont JDBC/ODBC, le fichier Oracle.properties est lu.
Comment faire pour ne pas avoir ? preciser de SCHEMANAME?
Meme avec la propri?t? NULLSCHEMA= true, la connection est refus? (utilisateur n'existant pas dans le schema : "")


10-04-2001 06:37 AM
Click Here to See the Profile for entdemo    Find more posts by entdemo        Edit/Delete Message    Reply w/Quote    IP: Logged
admin
Administrator

Registered: Apr 2001
Posts: 19

Bonjour,

pour vous connecter ? une base Oracle vous devez avoir un login et un pwd cr??s par un administrateur, ainsi que les droits d'acc?s inh?rents.
La syntaxe sous sqlPlus ressemble ? :
1) create user nomutilisateur identified by nomutilisateur;
2) grant connect, resource, dba to nomutilisateur identified by nomutilisateur;

, ensuite pour plus de simplicit?, ouvrez le fichier Oracle.properties et modifiez la valeur de la cl? SCHEMANAME pour lire NOMUTILISATEUR ? la place de SCOTT (d?faut)

Assurez vous enfin que le fichier %ORA_HOME%\jdbc\lib\classes12.zip est dans le CLASSPATH de d?marrage de cocoadmin. Il contient le driver jdbc fournit par Oracle.

Relancez cocoadmin et connectez vous, si tout se passe bien vous devriez voir l'assistant d'initialisation de CocoBase (dbInstall).

Thought Support

10-05-2001 01:19 AM
Click Here to See the Profile for admin    Find more posts by admin        Edit/Delete Message    Reply w/Quote    IP: Logged
All times are PST (US)    Post New Thread     Post A Reply
Forum Jump:
< Previous Thread     Next Thread >

Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author. Messages can be deleted by their author.
Posts: HTML code is OFF. Smilies are OFF. vB code is OFF. [IMG] code is OFF.

Admin Options:
Open / Close Thread
Move Thread
Delete Thread
Edit Thread

< Contact Us - THOUGHT Inc. >

Copyright © Jelsoft Enterprises Limited 2000.
Copyright 2001 All Rights Reserved, THOUGHT Inc.