Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved ODBC170.INI file entry for MySQL

  1. Issue
0
Votes
Undo
  1. Daniel Vivier
    Daniel Vivier
  2. PowerBuilder
  3. Thursday, 17 August 2017 16:10 PM UTC

I'm not finding an entry for MySQL in the ODB170.INI file, so retrieval of identity keys isn't working. I found the following on the web somewhere:

[MySQL]
PBSyntax='MySQL_SYNTAX'
PBNoCatalog='YES'
PBTableOwner='NO'
DelimitIdentifier='NO'

[MySQL_SYNTAX]
;GetIdentity='SELECT LAST_INSERT_ID()'
GetIdentity='Select @@identity'

(I actually added the 2nd through 4th lines in the [MySQL] section.) I think either version for GetIdentity in [MySQL_SYNTAX] will work.

Is there anything else I should add there? What I have so far definitely solves the retrieval of identity keys problem.

Thanks.

  1. Build
  2. MySQL
  3. ODBC
Sybase.Datawindow in C#.NET
Date/Time issue with Appeon
Responses (1)
Daniel Vivier
Daniel Vivier Accepted Answer Pending Moderation
  1. Thursday, 17 August 2017 19:36 PM UTC
  2. PowerBuilder
  3. # 1

I'm observing a problem with the minimal ODBC170.INI section I added for MySQL (or perhaps the problem is with something else).

In the database painter, if I connect to a MySQL datasource, open Tables, and then try to open one of the tables to see its columns, I get a messagebox saying "Table foo has no columns; possible invalid table format".

I tried adding a few lines into the [MySQL_SYNTAX] section that were present in another of my sections for another DB (where I can see a table's columns fine), as follows, in case they were relevant:

CreateTable='CREATE TABLE &TableName (::ColumnElement[::ColumnElement]...)'
ColumnElement='&ColumnName &DataType'
DropTable='DROP TABLE &TableName'
 

But that didn't make any difference. (Yes, I exited and restarted PB 2017 so it would see the change.)

Any bright ideas?

Comment
Gerry Whitmarsh
  1. Gerry Whitmarsh
  2. Friday, 18 August 2017 07:13 AM UTC
Hi Dan,



I think that the problem lies elsewhere. I am using MySQL 5.7 with the 32 bit ODBC connector 5.3 and have no problem. I also do not have any MySQL section in the PBODB170.INI.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.