This content has been marked as final. Show 2 replies
VMAR:Thank you for your post.ODBC/JDBC is only available with FileMaker Server 8 Advanced. If you don't have Advanced, then you will not be able to enable ODBC/JDBC.Assuming you do have FileMaker Server 8 Advanced, make sure you followed the installation instructions, and make sure it appears in the Registry as outlined on page 7 of the "Installing FileMaker ODBC and JDBC Client Drivers". If you misplaced that documentation, you can get it from our web site, directly at:TSGalFileMaker, Inc.
I have created an odbc connection to a Data Direct Sequalink 5.4 driver being hosted by Filemaker Server 8.
Using Windows Server 2003 with active directory.
I can connect to the database using Microsoft ACCESS and Adobe Acrobat using the data source.
I can't however connect using an asp page with the following code:
<% @LANGUAGE = VBScript %>
Response.Expires = 0
Dim objConn, objRS, strQuery
Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "DSN=serialmgmt;DB=serialnum;UID=Bill;PWD=jello"
seriala = Trim(Request.QueryString("SERIAL"))
strQuery = "SELECT NIC FROM serialm WHERE SERIAL = " &"'" & seriala & "'"
set objRS = objConn.Execute(strQuery)
Set objRS = Nothing
Set objConn = Nothing
I get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[DataDirect][ODBC SequeLink driver][SequeLink Server]The specified data source is not defined.
The data source is defined. The test connection works and i can access it from other sources.
Any help would be appreciated.