PrimalSQL Oracle Connection

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
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.
This topic is 11 years and 5 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Last visit: Tue Jan 03, 2023 3:55 pm

PrimalSQL Oracle Connection

Post by gbecerra@hotmail.com.ar »

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,
User avatar
Alexander Riedel
Posts: 8479
Last visit: Thu Mar 28, 2024 9:29 am
Answers: 19
Been upvoted: 37 times

PrimalSQL Oracle Connection

Post by Alexander Riedel »

Can you please provide information as to what Oracle version, what provider version etc you are using?
Alexander Riedel
SAPIEN Technologies, Inc.
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Last visit: Tue Jan 03, 2023 3:55 pm

PrimalSQL Oracle Connection

Post by gbecerra@hotmail.com.ar »

Sorry, sure.

The oracle version is 11g.
The Client installed version is 11.1.0.6.0
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Last visit: Tue Jan 03, 2023 3:55 pm

PrimalSQL Oracle Connection

Post by gbecerra@hotmail.com.ar »

Do you need some additional information?
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Last visit: Tue Jan 03, 2023 3:55 pm

PrimalSQL Oracle Connection

Post by gbecerra@hotmail.com.ar »

This is the connection string. (I just replaced the user and password)
Data Source=RAAP;Integrated Security=False;User ID=UserName;Password=Password
User avatar
Alexander Riedel
Posts: 8479
Last visit: Thu Mar 28, 2024 9:29 am
Answers: 19
Been upvoted: 37 times

PrimalSQL Oracle Connection

Post by Alexander Riedel »

Thanks, I will forward this to the PrimalSQL Team and see what they come up with.
Alexander Riedel
SAPIEN Technologies, Inc.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

PrimalSQL Oracle Connection

Post by davidc »

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
SAPIEN Technologies, Inc.
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Last visit: Tue Jan 03, 2023 3:55 pm

PrimalSQL Oracle Connection

Post by gbecerra@hotmail.com.ar »

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.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

PrimalSQL Oracle Connection

Post by davidc »

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
David
SAPIEN Technologies, Inc.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

PrimalSQL Oracle Connection

Post by davidc »

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
David
SAPIEN Technologies, Inc.
This topic is 11 years and 5 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.