Jump to content

Execute sql statement on an ODBC connection


zhouyong22
 Share

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

Recommended Posts

  • Newbies

Hi, I'm a FP newbee, forced to learn this by my boss.

I have set up a system DSN with FP ODBC driver, then I wrote a test Perl script to try to open a table and print content to screen.

The sql looks like this: SELECT * FROM [specialists_Database.FP5]

returned error is: Error: "-151[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed10"

Could anybody see the posible problem here? Thanks.

Link to comment
Share on other sites

Is the database you are accessing Local or Remote?

If local make sure you have the Local Data Access companion running under Plugins.

If Remote make sure you have the Remote Data Access companion running under Plugins.

also are you running Windows or Mac??

Link to comment
Share on other sites

This topic is 7423 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

×
×
  • Create New...

Important Information

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