Support Forums

PrimalSQL Oracle Connection

Product support for PrimalSQL users
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE 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.
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Joined: Wed Oct 03, 2012 4:30 am

PrimalSQL Oracle Connection

Postby gbecerra@hotmail.com.ar » Wed Oct 03, 2012 4:30 am

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: 5858
Joined: Tue May 29, 2007 4:43 pm

PrimalSQL Oracle Connection

Postby Alexander Riedel » Wed Oct 03, 2012 6:55 am

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
Joined: Wed Oct 03, 2012 4:30 am

PrimalSQL Oracle Connection

Postby gbecerra@hotmail.com.ar » Thu Oct 04, 2012 2:39 am

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
Joined: Wed Oct 03, 2012 4:30 am

PrimalSQL Oracle Connection

Postby gbecerra@hotmail.com.ar » Thu Oct 04, 2012 2:39 am

Do you need some additional information?
User avatar
gbecerra@hotmail.com.ar
Posts: 9
Joined: Wed Oct 03, 2012 4:30 am

PrimalSQL Oracle Connection

Postby gbecerra@hotmail.com.ar » Thu Oct 04, 2012 4:45 am

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: 5858
Joined: Tue May 29, 2007 4:43 pm

PrimalSQL Oracle Connection

Postby Alexander Riedel » Thu Oct 04, 2012 8:15 am

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: 4452
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL Oracle Connection

Postby davidc » Mon Oct 08, 2012 3:41 am

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
Joined: Wed Oct 03, 2012 4:30 am

PrimalSQL Oracle Connection

Postby gbecerra@hotmail.com.ar » Mon Oct 08, 2012 4:16 am

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: 4452
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL Oracle Connection

Postby davidc » Wed Oct 10, 2012 4:35 am

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: 4452
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL Oracle Connection

Postby davidc » Mon Oct 22, 2012 9:11 am

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.

Return to “PrimalSQL”

Who is online

Users browsing this forum: No registered users and 3 guests