Article:
  ColdFusion MX on Mac OS X, Part 3
Subject:   Pointbase? And MySQL?
Date:   2003-01-15 03:07:07
From:   lolajl
Response to: Pointbase? And MySQL?

Thanks . . . I still haven't been able to get the Pointbase driver installed in SQL4X (need to figure which goes into what field, etc), but I was able to get the MS SQL driver installed (thus bringing me one more step to being able to work at home - waiting for PGP's VPN client).


Yeah, I know about the instructions from Apple but these are a bit esoteric and I think there are some steps that were left out, and I think I have MySQL installed somehow but can't figure how to access it. I've heard that there's work on a GUI installer for MySQL, and I may wait for this.

Full Threads Oldest First

Showing messages 1 through 4 of 4.

  • Pointbase? And MySQL?
    2003-01-15 06:45:51  dicklacara [View]

    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
  • Pointbase? And MySQL?
    2003-01-15 08:56:37  lolajl [View]

    Thanks! Followed the steps accordingly, there seems to be a problem in my ability to connect to the database, though. The problem line seems to be the JDBC URL. I doublechedked to make sure the path was correct. When I clicked on Connect, I got a java.sql.SQL.exception error: database does not exist. It seems to think that the database is somewhere else other than this directory. Checked db directory and cfsnippets does reside here as cfsnippts.dbn.
    • Pointbase? And MySQL?
      2003-01-15 12:06:50  dicklacara [View]

      Can you verify the cfsnippets database in the CFMX Administrator?

      If so, you should be able to copy the driver class and URL files from that definition to the corresponding fields in the SQL4X connection.

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

        Not sure what I'd done wrong before, but copying/pasting the paths worked like a charm. Thanks! I'm starting up a blog that will be devoted solely to Macs and CFMX, located at <http://www.lolajl.net/macfmx/>. It's up now but nothing much in there yet.