Dear All,
I'm trying to connect to Oracle Database but always is loading and not connecting properly.
I created a new connection with the following Information "Oracle > ServerName > Login or Schema > Password".
The database is added on the left connections panel, then I click on the database to see the objects inside and always is loading and not connecting properly. Do you have any idea if could I have some missing configuration?
Thanks in advance,
PrimalSQL Oracle Connection
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
- gbecerra@hotmail.com.ar
- Posts: 9
- Last visit: Tue Jan 03, 2023 3:55 pm
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
PrimalSQL Oracle Connection
Can you please provide information as to what Oracle version, what provider version etc you are using?
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- gbecerra@hotmail.com.ar
- Posts: 9
- Last visit: Tue Jan 03, 2023 3:55 pm
PrimalSQL Oracle Connection
Sorry, sure.
The oracle version is 11g.
The Client installed version is 11.1.0.6.0
The oracle version is 11g.
The Client installed version is 11.1.0.6.0
- gbecerra@hotmail.com.ar
- Posts: 9
- Last visit: Tue Jan 03, 2023 3:55 pm
- gbecerra@hotmail.com.ar
- Posts: 9
- Last visit: Tue Jan 03, 2023 3:55 pm
PrimalSQL Oracle Connection
This is the connection string. (I just replaced the user and password)
Data Source=RAAP;Integrated Security=False;User ID=UserName;Password=Password
Data Source=RAAP;Integrated Security=False;User ID=UserName;Password=Password
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
PrimalSQL Oracle Connection
Thanks, I will forward this to the PrimalSQL Team and see what they come up with.
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
PrimalSQL Oracle Connection
Are you able to query using the SQL Text document instead of the Visual Query Builder? For large databases it can take several minutes for the query builder to create the cache.
David
David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- gbecerra@hotmail.com.ar
- Posts: 9
- Last visit: Tue Jan 03, 2023 3:55 pm
PrimalSQL Oracle Connection
No, I'm not able to do nothing.
I select the database and always is status loading, when I select to do a query the database is in loading without showing the components.
I tried to run a simple query selecting the database but also the database is loading status.
I select the database and always is status loading, when I select to do a query the database is in loading without showing the components.
I tried to run a simple query selecting the database but also the database is loading status.
PrimalSQL Oracle Connection
The cache will take some time depending on the connection speed or if the database is very large. But if you use a "SQL Text" document you should be able to query the database while the Database browser is constructing the cache.
If you open a "Visual Query Builder" document then you will have to wait until the cache is complete.
David
If you open a "Visual Query Builder" document then you will have to wait until the cache is complete.
David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
PrimalSQL Oracle Connection
Please try the latest service build of PrimalSQL (v3.0.5)and let us know if it makes a difference.
Also in Options->Panes->Database Browser Try unchecking the "Load Fields" option. It should help speed up time it takes the cache to complete.
David
Also in Options->Panes->Database Browser Try unchecking the "Load Fields" option. It should help speed up time it takes the cache to complete.
David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.