SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-06-08 15:44:42

sqldbxhelp
Administrator

SqlDbx release 4.2

SqlDbx 4.2 is available for download

New and changed features:
1. Full support for Teradata
2. Improved Informix support
3. Improved PostgreSQL support
4. Improved MySQL support
5. Server Explorer now supports MySQL, PostgreSQL and Informix
6. Added ability to connect using ODBC configured DSN's
7. Improved Intellisense
8. Separate configuration pages for all supported databases

Fixes:
1. TIMESTAMP columns not detected correctly in some cases
2. BIGINT values truncated to INT
3. Potential crash when retrieving data
4. Incorrect case conversion in some rare cases
5. Relative directories not handled correctly
6. Backup files not overwritten anymore
7. Mac formatted files displayed incorrectly
8. System objects loaded from wrong database (SQL Server)

Offline

#2 2014-06-09 13:18:21

jhjdhfurzs
Member

Re: SqlDbx release 4.2

Hi

as a registered user, when clicking on [Check for updates] - currently using 4.1 - no new updates are found ?

Any suggestions ?

Cheers
Robert

Offline

#3 2014-06-09 20:38:13

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

Not sure, but may be timeout connecting.

Offline

#4 2014-06-10 01:30:54

jhjdhfurzs
Member

Re: SqlDbx release 4.2

Well, possible but I tried to update in 2 different networks, all works fine so I dont think thats the problem. Is there another possibility to download professional version ?

Cheers
Robert

Offline

#5 2014-06-10 05:37:23

geo
Member

Re: SqlDbx release 4.2

"5. Relative directories not handled correctly": not fixed?

In portable setup (and Options>General>Script Files=.scripts, File Browser=.scripts, Speed Typing=SpeedType.xml), whenever I save a script (to, say, folder X), this is what happens:
1. file is saved to folder X
2. immediate popups for all files opened via the File Browser (This file has been modified. Do you want to reload it?)
3. saving a speedtype change creates a new SpeedType.xml in folder X instead of updating the file in the sqldbx folder

Restarting sqldbx fixes the problem (until the next Save), so the .ini file is OK.
It would seem that the "current folder" (which changes along the way) is used to resolve relative paths, while the executable's folder would be a safer option.

Offline

#6 2014-06-10 06:32:45

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

Please send email to support. They will let you know from where you can download latest version.

Offline

#7 2014-06-10 06:33:57

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

It should be relative to executable folder. Will have to take a look

Offline

#8 2014-06-17 00:55:42

jhjdhfurzs
Member

Re: SqlDbx release 4.2

After upgrade from 4.1 pro to 4.2 pro I cannot connect to any MySQL Server anymore. Error is for all of my 7 machines the same: SQLSTATE = HY010.

Any ideas what changed ?

Cheers, Robert

Offline

#9 2014-06-17 09:04:09

jhjdhfurzs
Member

Re: SqlDbx release 4.2

Grouping (cmd format=group ...) does not work anymore

Cheers, Robert

Offline

#10 2014-06-17 09:43:39

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

Can you check Tools->View Application Log for what MySQL ODBC drivers SqlDbx tries to load.
Do you have ODBC DSN's with the same name as Server in Login Dialog?
cmd format looks to work fine. There were no changes from 4.1. to 4.2 in this area

Offline

#11 2014-06-17 13:26:30

jhjdhfurzs
Member

Re: SqlDbx release 4.2

Well, all connections worked on this machine and I didnt install a new odbc driver fro MySQL nor is the connectionname used as a DSN.

Log:

Using Driver: MySQL ODBC 5.2a Driver (C:Program FilesMySQLConnector ODBC 5.2ANSImyodbc5a.dll)
DriverConnect: DRIVER={MySQL ODBC 5.2a Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=bpitc_staging;UID=root;PWD=******;APP=SqlDbx(robert.brooks);

Cheers, Robert

Offline

#12 2014-06-17 20:44:34

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

What version of MySQL?

Offline

#13 2014-06-19 00:26:56

jhjdhfurzs
Member

Re: SqlDbx release 4.2

Hi, there are different versions maily 5.5 and 5.6; the strange thing is that it worked before wink

Cheer,
Robert

P.S.: Could it be that the directory where SqlDbx searches for drivers changed ? Now I tried on a different machine and the directory is [Drivers64] instead of [Drivers] in SqlDbx directory ?

06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxmyodbc5.dll
06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxDrivers64myodbc5.dll
06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxmyodbc5a.dll
06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxDrivers64myodbc5a.dll
06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxmyodbc5w.dll
06/19/14 06:28:21    Failed to load driver dll: C:Users obert.brooksOneDriveProgrammeACS TechnologiesSqlDbxDrivers64myodbc5w.dll

I have all my drivers in ...SqlDbxDrivers folder.

P.P.S: Thats it, I changed the folder to [Drivers64] and voilá.

Last edited by jhjdhfurzs (2014-06-19 00:33:14)

Offline

#14 2014-06-19 06:22:54

sqldbxhelp
Administrator

Re: SqlDbx release 4.2

x86 version of SqlDbx will look in Drivers directory and x64 version will look in Drivers64 directory.
Looks like before you run x86 and now you running x64 version

Offline

Board footer

Powered by FluxBB