ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  ColdFusion MX on Mac OS X, Part 3
Subject:   Pointbase? And MySQL?
Date:   2003-01-15 06:45:51
From:   dicklacara
Response to: Pointbase? And MySQL?

I was able to connect to the MySQL & PB databases with SQL4X Manager J.


I gave you some wrong information in my previous post, the following is correct.



  1. Make a copy of the PointBase driver file and put it where SQLEX Manajer J can find it. Copy pbserver42RE.jar from:


    /Applications/JRun4/servers/cfmx1/cfusion/WEB-INF/cfusion/lib


    to:


    /Library/Java/Extensions

  2. Restart SQL4X Manager J, so it can locate the copied driver


  3. Setup a connection:


    Database Server: Generic JDBC
    Driver Installed: Yes


    The following can be copied from the cfsnippets DSN in the CFMX Administrator


    Display Name: cfsnippets


    JDBC Driver: com.pointbase.jdbc.jdbcUniversalDriver


    JDBC URL: jdbc:pointbase:cfsnippets,database.home=/Applications/JRun4/servers/cfmx1/cfusion/WEB-INF/cfusion/db


    USER: PBPUBLIC


    PASSWORD: PBPUBLIC


  4. Connect to the cfsnippets Database
  5. Open a new Navigator window to recognize the new connection
  6. Select the PBPUBLIC schema to view the cfsnippets schema


Dick


1 to 1 of 1
  1. Pointbase? And MySQL?
    2003-01-15 08:56:37  lolajl [View]

    • Pointbase? And MySQL?
      2003-01-15 12:06:50  dicklacara [View]

      • Pointbase? And MySQL?
        2003-01-15 12:51:08  lolajl [View]

1 to 1 of 1