Jump to content
Sign in to follow this  
kwebb

ODBC Drivers Won't Initialize to create a DSN

Recommended Posts

I am unable to create ODBC DSN entry for a FM database. The FM drivers appear in the list; however, I am unable to create a System DSN or User DSN. I am able to create a File DSN; however, this setup is much slower than User DSN and even slower than System DSN.

Has anyone else encountered this problem before? I get the following message, "The Setup routines for FileMaker Pro ODBC driver could not be loaded due to system error code 126."

Then the next error displays, "Could not load the setup or translator library."

Can anyone help me out?

------------------

Thanks,

Kevin

Yahoo! Messenger: prof_bunsen

Share this post


Link to post
Share on other sites

quote:

Originally posted by kwebb:

I am unable to create ODBC DSN entry for a FM database. The FM drivers appear in the list; however, I am unable to create a System DSN or User DSN. I am able to create a File DSN; however, this setup is much slower than User DSN and even slower than System DSN.

Has anyone else encountered this problem before? I get the following message, "The Setup routines for FileMaker Pro ODBC driver could not be loaded due to system error code 126."

Then the next error displays, "Could not load the setup or translator library."

I have successfully done what you are trying. I might suggest simply reinstalling both the Filemaker ODBC and the OS (you did not specify if you are on Windows or Mac) ODBC drivers. Some kind of file/translator is obviously corrupted or missing.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:FmPro@home.com

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Share this post


Link to post
Share on other sites

The ODBC Drivers for Windows NT cannot be the problem because they are working for other ODBC DSNs.

I uninstalled FM, rebooted, and reinstalled FM. No effect.

Has anyone else had problems with FM ODBC drivers? If so, what was the problem and how did you correct it?

------------------

Thanks,

Kevin

Yahoo! Messenger: prof_bunsen

Share this post


Link to post
Share on other sites

I found out that FileMake Pro must be installed using the Typical option. Even the custom option will not properly include the ODBC drivers.

Now that the drivers are in properly, I am having problems with having ODBC connections via ASP pages. If I connect through Access, the Query works; however, the Table link does not. The FM DB is open in FM Unlimited. I am using the userid (group) and password that is setup through the Access Privledges and the SQL Statement created by Access; however no luck.

Can anyone provide ASP code that shows an example of connecting via ASP?

Here is mine:

dim cn, rs, stsql

set cn = CreateObject("ADODB.Connection")

on error resume next

cn.Open "DSN=FiltranApplicationGuide;UID=groupName;PWD=grouppwd;"

if Err.number <> 0 then

Share this post


Link to post
Share on other sites

When you re-install FMP, select typical, I have had the same problem b4 and if you look closely (during the install process), you will notice that any other install selection doesn't install ODBC in the system folder. I know it sounds crazy, but it has worked for me smile.gif

Share this post


Link to post
Share on other sites

Thanks for the feedback.

I finally figured that our earlier. That is such a stupid requirement. They even state that Custom is for experienced users, yet if you want the ODBC drivers, you have to install everything.

If you have any problems with ODBC check out my other post: http://www.fmforums.com/ubb/Forum29/HTML/000030.html

------------------

Thanks,

Kevin

Yahoo! Messenger: prof_bunsen

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By puterco
      I have published my database using CDML pages and I want each web address field to act as a link witch goes directly to the address contained in the field. Example of the HTML code on the search results page:
      [FMP-FIELD: email] *how can I link this field to act as "mailto://(value in the field)"

      [FMP-FIELD:web-address] *how can I link this to act as "http://(value in the field)"
      Any help will be highly appreciated the dead line for these pages were yesterday and I need to get these features online as soon as possible. Thanks...
    • By kwatson
      Does anyone know how to allow users to input graphics into a database posted on the web? Home Page tells me container fields won't work.
    • By Randy Abulon
      Has anyone tried the connector on Windows 2000 and had some success with it? The company I work for just got FMPro5 Unlimited, but we mostly a Win2K shop; including the intranet server... How do I make it work?
    • By OSXS
      Dear all:
      I am facing the following problem: I am setting up a www-interface using CDML for the first time. I get the behavior I want, and everything works fine.
      But there's one big question: In the CDML reference, I cannot find any tags that allow authentication of users using the FM-database built-in access privileges.
      Any ideas?
      Cheers,
      Ron
    • By pem
      Does portals work i www mode?
      I have a field in a portal that works in filemaker but not in www mode. In filemaker it
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.