Witango-Talk: FMPro7 JDBC

[Peter Link]

	I've gotten a little further on the installation of the xDBC 
plugin for FMPro 7 on OSX. I used the testforjdbc shell (only works 
with bash on my system) and registered the driver. After doing this, 
Witango 5.5 Lite was able to connect to a FMPro 7 database that had 
ODBC/JDBC turned on. I created the datasource using Witango and have 
included it here (I just opened the TimeCards.fp7 file that was 
included with FMPro 7; use Admin for logon, no password):

(edited out the extra properties lines)
                <DataSource ID="fmpro7">
                        <DSN>fmpro7</DSN>
        <DriverClass>com.ddtek.jdbc.sequelink.SequeLinkDriver</DriverClass>
        <URL>jdbc:sequelink://127.0.0.1:2399;databaseName=TimeCards.fp7</URL>
                        <Properties />
                </DataSource>
---
	When I tested, it gave me the connection. When I opened the 
datasource, I entered the Admin logon but it only shows the table, no 
fields. I removed the databaseName part and it still connected. The 
notes talk about problems trying to connect to more than database. It 
says to use serverDataSource instead but there's no instructions on 
the syntax.

--
Peter Link
System Manager, OISSO
Administration and HR Directorate
Lawrence Livermore National Laboratory
P.O. Box 808, L-664
Livermore, CA 94550
[EMAIL PROTECTED]
(925) 423-1230
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf