O/S: Windows 7 Enterprise 64-bit
PrimalScript 6.5.123
When running a SQL query by clicking on SQL Queries in the View ribbon, I cannot run the query. It states "No database connection selected. Please use the database toolbar to select or create a connection". I have the database selected in the Tools ribbon in the Database section. A database toolbar does not exist. Also, when opening a .sql file and trying to run by right-clicking and selecting "Excute entire file as query" does nothing. Clicking on Run Query under the Tools ribbon does not work either - nothing happens.
Run queries from PrimalScript
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.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Run queries from PrimalScript
Just noticed that when version 6.5.123 was downloaded. It installs version 6.5.122 not 6.5.123. The application was fully removed and re-installed.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Run queries from PrimalScript
This was not corrected with 6.5.123. It is still an issue. Just checked with the current version.
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
Run queries from PrimalScript
I'll find out what's going on with that.
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Run queries from PrimalScript
This was corrected with version 6.5.125. Thanks.
Please note that is is quite slow when dealing with large databases though.
Please note that is is quite slow when dealing with large databases though.
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
Run queries from PrimalScript
Can you define "large" for us?
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Run queries from PrimalScript
Over 100 tables with 100's of thousands+ records in each table. The query runs fast once connected to the database but the connection is what takes so long. PrimalScript quits responding and just have to wait until it is finished.
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
Run queries from PrimalScript
Ok, can you provide some more information?What database vendor, what type of connection? I am assuming the database is remote, but is it LAN, VPN, HTTP?When exactly do you experience the delay? When selecting the connection in the combo box?
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Run queries from PrimalScript
What database vendor? Oracle
What type of connection? LAN/WAN (TCP/IP)
When exactly do you experience the delay? Selecting the connection in the combo box.
What type of connection? LAN/WAN (TCP/IP)
When exactly do you experience the delay? Selecting the connection in the combo box.
- Alexander Riedel
- Posts: 8488
- Last visit: Tue Apr 16, 2024 8:42 am
- Been upvoted: 37 times
Run queries from PrimalScript
Thanks, I will see what I can find out.
Alexander Riedel
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.