Jump to content

ODBC Drivers Won't Initialize to create a DSN


kwebb
 Share

This topic is 7467 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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

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

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

This topic is 7467 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By Eva-Wien
      Who can help me by telling me the possibility about communication between FM Pro and an LDAP server?
      It's realy very important and urgent.
      Thanks in advance
      Eve
      SilverTop.fp7.zip
    • 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 Fog
      We are using Filemaker5 Unlimited currently as a web server along with Filemaker5 Pro Server as a site for our databases. Both computers are Macs. We are using Home Page 3.0 for Web interaction. How do we make our Web server site secure? This would be the first step to taking payments over the Web. I'm new at this, please help.
    • 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
    • By jjacques
      Okay, I've played with FileMaker 5 and have been impressed. I'd like to publish a few databases on the web but I'm finding the "Instant Web Publishing" limitations unacceptable.
      I've worked with GoLive 4 and found it a useful tool. With GoLive 5 now available, it provides some useful upgrades.
      I've got a Beige G3 300Mhz machine with a static IP hooked to the University backbone.
      I'd like to combine these resources....
      Is someone using GoLive5 with FM Pro Unlimited on a Mac? Is it reasonable to combine these tools to create educational college level courseware for survey research classes?
      Can you recommend some useful resources that will enable efficient integration of these tools and equipment?
      Thanks,
      jeff
  • Who Viewed the Topic

    10 members have viewed this topic:
    JOSUAN  GlV  siroos12  millmaine  Bertie  DDDan  arni  LAIRY  Tony Diaz  comment 
×
×
  • Create New...

Important Information

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