SqlDbx
You are not logged in.
Pages: 1
Is it a limitation in the personal edition that I cannot run multiple scripts concurrently?
Thank you,
Carl.
Offline
If you mean to run concurrently scripts from different tabs then it's not possible,
because they use same connection.
You can run scripts concurrently when multiple connections opened
Offline
When I try to open a concurrent connection using file, new Connection, it blows away my sqldbx window that I was running (and the 10 scripts that I was working on ) and replaces it with a brand new window. All I want to do is run a second script. What steps do you do to do that?
Offline
Personal Edition does not allow multiple connections. I do not understand what you mean by "blows away window".
You should see message box with message "You can have only one Active Connection in Personal Edition" and that's it.
Offline
I am running professional edition (paid for it).
"Blow away" scenario:
1. sqldbx is up and running
2. execute a script that takes a long time to run
3. while first script is running, click file, new connection
4. sqldbx server login dialog box appears with my remembered server settings, click ok
4. sqldbx program window (the one that had the script running in it) is replaced with a new sqldbx program window with a single blank script tab. The query that was running is no longer running and is not in a script tab. Its as if I closed the sqldbx application and clicked on my sqldbx desktop icon to start sqldbx anew.
I wouldn't think its supposed to work that way. Am I doing something wrong to get a second connection running so that I can run a second query/script?
Offline
It can not be replaced. It opens new one.
What about combo box on a main toolbar?
It should show two connections to the same database.
Are you sure that other window is not behind the new one?
Offline
>>It can not be replaced.
That is not my experience.
>> It opens new one.
I wish that were true in my case.
>>What about combo box on a main toolbar?
What does that look like? I see no icon with the label "combo box"
>>Are you sure that other window is not behind the new one?
Quite. Task Manager shows only one sqldbx application running. This is a screenshot of sqldbx with taskmanager sitting on top of it right after I clicked file, new connection, ok (to server login info). https://dl.dropboxusercontent.com/u/420 … hot016.jpg
Offline
You have connection window maximized inside main SqlDbx window.
That is why when you open new connection it looks like the window replaced.
It is not. It is behind.
Connection combo box shows connection to "ibmposdb32, ibmpsdb, gworona".
If you click on arrow you will see that you have multiple connections.
Why you use ODBC connection to IBM DB2?
ODBC is very limited compare to native connection
Offline
Thank you! I didn't know the connections were managed like that.
I don't know why I am using ODBC to connect to my Informix database. I will ask the database manager.
What are the advantages of using a native connection?
Offline
Pages: 1