JDBC to Coldfusion

I have successfully got coldfusion talking to a Filemaker 9 database. It turned out to be pretty simple really.

I enabled ODBC/JDBC in Filemaker server. Installed the latest SequeLink on the coldfusion server. Setup a System DSN and pointed to it in the coldfusion admin. The only odd thing I ran into is in Filemaker field names can have spaces so when I do an insert into a field I have to put double quotes on the field name.

Share and Enjoy:

February 18th, 2008 at 1:11 PM by Damon Ledet in Adobe, Coldfusion, Tutorial | tags: Coldfusion, filemaker server | Trackback: trackback

Comments

ahamadApril 14th, 2008 at 1:38 am

Cool…

web developmentOctober 8th, 2008 at 11:31 am

I have been using Lasso with Filemaker, but I recently saw a need to use Filemaker With ColdFusion 8. Glad to see it worked out for you. Hopefully it will as easy for me.

ChrisApril 29th, 2009 at 1:47 pm

Hi, this is a great little post and is giving me hope but I am a bit stuck. I am trying to use FileMaker with Coldfusion. I am actually taking over the site and setting it up on a new server so I can see the CF datasource but not sure how it works. I am using Filemaker Pro 10 and CF 8. I have enabled ODBC/JDBC in filemaker but now need help with SequeLink. I'm not sure what version I should be using or how exactly to set it up. I am on a Windows 2003 server.

Thanks in advance.

damonledetApril 29th, 2009 at 2:45 pm

On the Filemaker database create a user File -> Manage Accounts & Privileges and give that user the rights that you want Coldfusion to have (read only, write, etc)

Run Filemaker server admin and make sure you have ODBC/JDBC checked for the database you want to access via ODBC.

On the server running Coldfusion install SequeLink, create a System DSN using the ip address of your filemaker server and the user credentials you created in step one.

Lastly in coldfusion administrator create a new datasource point to the system DSN you created.

ChrisApril 29th, 2009 at 5:55 pm

ok, i now have sequelink installed but need to set port 2399 to listening for sequelink to work. I get sequelink error 2306 when trying to set up the DSN. how can i edit ports.. can't find this info anywhere

damonledetApril 29th, 2009 at 6:15 pm

You will have to open port 2399 on the filemaker server computer.

If on Windows Control Panel -> Firewall
If on Macintosh System Preferences -> Security -> Firewall

ChrisMay 3rd, 2009 at 10:58 pm

I am just trying to make this connection on the local web server for a development site. I am using Filemaker Pro 10 and sequelink 6.0 but still getting error 2315 when trying to create the system DSN. Any thoughts?

damonledetMay 8th, 2009 at 1:38 pm

Not sure about this error I did find this http://media.datadirect.com/download/docs/slnk/er...

"Error 2315. The server received the handshake request and returned a non-IIOP reply that the client could not understand.

# You may be connecting with a previous, incompatible version of the SequeLink Client (SequeLink 4.x) to a SequeLink 5.5 Server:

* The client receives an error message that informs you that the server has closed the connection during the initial handshake."

M	T	W	T	F	S	S
« Jan				Mar »
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29

DamonLedet.comWriting about technology, daily life, and other things I find interesting

Home » Blog » Filemaker ODBC/JDBC to Coldfusion

Related Posts:

Archives

Blogroll

Recent Posts

Recent Comments

Tags