Results 1 to 6 of 6

Thread: Connectors and Recordsets

  1. #1
    Junior Member
    Join Date
    Apr 2016
    Posts
    7

    Default Connectors and Recordsets

    Good day,

    I have a Netobjects Connector with some Recordsets.
    For some reason that I do not understand, the databases' tables disappear from the connector (leaving just the database icon).
    In the connector, the Recordset tag is greyed-out (see the attached image). The odd thing is that the recordset drop down list still remains on the text boxes properties and it works.

    My checks.
    - I've deleted and try to redo a new connector.
    - I've checked (and redid) a new connection.
    - MySQL Database (local) is up and running.
    - I've tried to connect throughout an ODBC... No luck.
    - I'm using xampp to start Apache and MySql and re-started it.
    - MySQL Privileges are OK.
    - I replaced the actual template with a backup.
    - I did reboot the machine, MySQL and Apache.

    Note: The same issue happens with all connectors of all pages.

    Any help is appreciated
    Cheers
    Carlos


    Click image for larger version. 

Name:	connector.jpg 
Views:	167 
Size:	57.7 KB 
ID:	2459
    Last edited by innovision; 05-13-2016 at 01:53 PM.

  2. #2
    Junior Member
    Join Date
    May 2016
    Posts
    4

    Default

    It seems to be that you have lost the connection to your database (ODBC & DIRECT). this happens if you only have Java 8, because Java 8 has no jdbcodbc.dll (Java-ODBC-Bridge). Install an older Java (i.E.Java 7).

    Oracle says:
    The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. The Bridge is itself a driver based on JDBC technology ("JDBC driver") that is defined in the class sun.jdbc.odbc.JdbcOdbcDriver. The Bridge defines the JDBC sub-protocol odbc.

    The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8. In addition, Oracle does not support the JDBC-ODBC Bridge.

    Hope this helps
    Stefan

  3. #3
    Junior Member
    Join Date
    Apr 2016
    Posts
    7

    Default

    I will try your suggestion
    Many thanks Stefan
    Carlos

  4. #4
    Junior Member
    Join Date
    Apr 2016
    Posts
    7

    Default

    Database is MySQL. Do you think it is about the same problem?
    Cheers
    Carlos

  5. #5
    Junior Member
    Join Date
    May 2016
    Posts
    4

    Default

    Hi Carlos
    Oracle is the current owner of Java - and of course - owner of Oracle database.

    In your attached Image "Connector - rssf" on tag Database there is a Option "Import from Connection". Set the checkbox checked and NOF reads the database Schema from your MySQL-database.
    If NOF cannot read the database Schema then the Recordset tag is greyed-out in the connector dialog.

    The textbox properties with the recordset drop down list and the recordset definitions are stored in the .nod-file.
    The connector data and database Schema together with the Publishing Profile names are stored in: C:\Users\<your username>\Documents\NetObjects Fusion 2015\NetObjects System\Profiles\<your language-id>\NetObjects Inc\DBLib\MetaData\Cache.xml
    You can read this file with InternetExplorer to see it´s ok.

    Stefan

  6. #6
    Junior Member
    Join Date
    Apr 2016
    Posts
    7

    Default

    SOLUTION Found
    1 - On this directory:
    C:\Users\[your user name]\Documents\NetObjects Fusion 2015\NetObjects System\Profiles\enus\NetObjects Inc\DBLib\MetaData\
    2 - Rename (or delete) the file cache.zip and replaced it with a backup
    My connectors and recordsets were back.
    Have a great week-end
    Last edited by innovision; 05-20-2016 at 08:41 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •