SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Report SqlBase bugs and possible workarounds.
Clifford Bass

SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 07 Jan 2015, 21:07

Hi,

When connecting through ODBC to a database, if I don't want the default database that is specified, it does not allow me to enter a database name longer than 13 characters. It should allow for names up to 16 characters.

Thanks,

Clifford Bass

Mike Vandine

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Mike Vandine » 07 Jan 2015, 23:56

Hi Cliff,

Sorry for being a bit dense, but where do you see the dialog. In the ODBC Administrator? What is the front-end that you are using that shows this?

Best regards,

Clifford Bass

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 08 Jan 2015, 01:56

Hi Mike,

It would either be when you do a test connect from the ODBC Administrator; or any program that uses ODBC (i.e. Access, ODBCTest, etc.).
Capture.JPG
Using ones for visual effect. You see I can only enter thirteen characters in the "Database" line.

Cliff
You do not have the required permissions to view the files attached to this post.

Mike Vandine

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Mike Vandine » 08 Jan 2015, 09:42

OK. I can see this.

This is definitely a bug, but has an easy workaround.

In any ODBC connection setup, remove the 'database' name (i.e. ISLAND) and do a 'Test Connect'. You get the prompt as you've shown below. The database dropdown will not have anything in it.

Put in your server name and press the tab. You can now use the dropdown to connect to any database on the server, including one that is 16 characters long. The DB names are shown correctly in the dropdown even though they don't show fully in the database selection field.
ODBC.jpg
I will log a defect.

Best regards,

Mike
You do not have the required permissions to view the files attached to this post.

Clifford Bass

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 08 Jan 2015, 18:58

Hi Mike,

That is an interesting work-around. Tested; and it works for me!

Thanks,

Clifford

Mike Vandine

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Mike Vandine » 09 Jan 2015, 06:27

Hi Cliff,

Glad that worked for you too.

I have created defect SQLB-2204 for this issue.

Cheers!

Mike

Clifford Bass

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 20 Jan 2015, 22:09

Thanks Mike!

Say. For some reason I am no longer getting notifications by e-mail of replies to posts; nor of receipt of private messages. Any idea why? I have not changed my e-mail address and it is still valid. My settings remain as they have been for a long time which specify to notify me in both instances.

Also; no, the notifications are not ending up in my junk folder.

Thanks,

Clifford

Mike Vandine

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Mike Vandine » 21 Jan 2015, 01:31

Hi Cliff,

This was a known problem with responses. I've been working with IT for a couple of weeks to get it resolved. They had changed to a new mail server; they've now changed it back. :)

I am now getting notifications (I got one for your response here). Can you please verify that you got a notification of a response to this one?

Best regards,

Mike

Clifford Bass

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 21 Jan 2015, 01:35

Hi Mike,

Got the notification! Yeah!

Cliff

dosborne

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by dosborne » 16 Jun 2015, 21:28

I have fixed this issue.
It will be released when SB 12.0 comes out.
I also queued it for the next 11.7 release.

Clifford Bass

Re: SQLBase ODBC 11.7.3 Connect Dialog Database Name Length

Post by Clifford Bass » 17 Jun 2015, 01:07

Cool! Thanks!

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests