We help IT Professionals succeed at work.

Data Direct Sequalink 5.4 odbc connection failure to FileMaker Server 8

ALASKASTREETMASTER
on
1,196 Views
Last Modified: 2008-08-18
Hi,
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 %>
<%
Option Explicit
Response.Expires = 0
Dim objConn, objRS, strQuery
Dim StrConnection
Dim seriala
Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "DSN=serialmgmt;DB=serialnum;UID=Bill;PWD=jello"
objConn.Open strConnection
seriala = Trim(Request.QueryString("SERIAL"))
strQuery = "SELECT NIC FROM serialm WHERE SERIAL = " &"'" & seriala & "'"
set objRS = objConn.Execute(strQuery)
response.write objRS("NIC")
objRS.close
objConn.close
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.

Thank you
Bob Johnson
Comment
Watch Question

Commented:
maybe you should move this Q to the asp section?
sure the passwd is jello, not hello?

Author

Commented:
From what I have read, I believe it is some type of a permissions issue with filemaker but i can't figure it out.  The same asp query works fine on an Microsoft Acccess ODBC connection.

When the password is incorrect a different message is displayed saying the password is incorrect.

With the right password, the following error comes up in the Filemaker event viewer.

The description for Event ID ( 0 ) in Source ( SLSocket54 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: SLSocket54@localhost,ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=192.168.0.171,Session=8

Thanks




Commented:
I thought it was ok to query the filemaker ODBC DSN from Access, and you were applying the same query to a Access DSN...
Rights?? try putting a full access account in the ODBC login parameters maybe
And about the msg you've got, it may rely on the netbios messaging service which is disabled on lots of machines since it has been used a lot in the past by spammers to display rubbish from an infected machine on the LAN. On my machine, it is off for instance.
If you run the query on the filemaker machine, is it the same?

Author

Commented:
I used the ACCESS DSN for a .mdb database before i switched to  Filemaker. The asp query was going to the Access DSN and it worked fine. I set up a Sequalink DSN to the Filemaker database, which i imported from the .mdb database. I set the DSN username and password the same in both DSN and pointed the asp query to the Sequalink DSN. That is where I get the error message. I can access the Sequalink DSN from other machines using other programs and it works fine, just not from the asp page.

Both DSN are on the same Windows 2003 Server machine.

By full access, do you mean - Windows Account or Filemaker rights. The username and password in the DSN are for the Filemake username and password and it is a full access account.

Thanks

Commented:
I meant full access filemakerwise, but that's what you did... stuck for now...

Author

Commented:
Thanks, i gotit figured out.  The DSN connection string did not requite a database be defined.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Not sure,


I am guessing the DSN establishes the connection to the database when you set up the DSN so you don't need to define it in the connection string or i was not defining it correctly. It does work with out it though.

You can only access one Database for each DSN you create as far as i can tell since you can only select one Databse when setting up the DSN connection.

Thank you for your input.





Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.