473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Error reading password-protected FM in SQL Server

I'm trying to pull certain Filemaker 5 tables into SQL Server 2000 in
an automated import job using a file DSN. Everything resides locally
on a Windows XP machine. My process works fine on a test FM file with
no password, but with the real FM files, all password protected, it
fails with this error:

******
Error Source: Microsoft OLE DB Provider for ODBC Drivers

Error Description: Unspecified error
[FileMaker][ODBC FileMaker Pro driver]An error has occurred while
trying to gather a list of available tables.
[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed.

Context: Error calling GetRowSet to get DBSCHEMA_TABLES schema info.
Your provider does not support all the schema rowsets required by DTS.

******

This happens whether or not I supply a password to the SQL Server job.
It has been nagging me for days and I can't find any documentation on
it. Has anyone else encountered this?

Thanks very much.
Scott
Jul 20 '05 #1
1 1943
Scott,

Do you have Filemaker open on the SQL server desktop? Filemaker 5 requires the file(s) used in OLE be open for the Filemaker supplied driver to see it. This is true even if the files are served out by FM server.

Mark
Jul 28 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Sharif Tanvir Karim | last post by:
Can anyone send me a php.ini file that is used by almost by all hosts? My damn computer's (winxp) mini server is messed up and I am starting over so I am trying ot get php to behave on my system....
0
by: Matt | last post by:
I'm trying to get the HTML data off of a webpage. Let's say for the sake of argument it's the python homepage. I've googled around and found some examples that people said worked. Here's what...
0
by: David Moore | last post by:
Hello I posted a thread about this a while back, but I can't actually find it again so I can reply to it with the solution I found, so I'm making a new thread and hoping it goes to the top of...
1
by: Duncan Allen | last post by:
I'm trying to use aspnet_setreg to encrypt user names & password used in the web.config file for use in the indentity element. When the website runs I get the message 'Error reading the password...
20
by: ctyrrell | last post by:
Does anyone have any idea how to recover from a run-time error 3002 which I get after creating a workspace 242 times? Or better yet, avoid getting it in the first place? I am creating a...
5
by: TurboDisk | last post by:
Hello,I am a fresh man to study the DB2.An error occured when I try to Run a Java class. Details of the Error: Code: -------------------- com.ibm.db2.jcc.b.SqlException:DB2 SQL...
2
by: Creascripts | last post by:
I'm having some problem with reading an .xml file: <?xml version="1.0" encoding="utf-8"?> <UserInfoListResult xmlns:xsd="http://www.w3.org/2001/XMLSchema"...
35
by: jeffc226 | last post by:
I'm interested in an idiom for handling errors in functions without using traditional nested ifs, because I think that can be very awkward and difficult to maintain, when the number of error checks...
3
by: Adrock952 | last post by:
I have been trying for ages to work out how to highlight a form field using css when there is an error during validation. I have got the form to validate fine but i don't know how to change the...
68
mideastgirl
by: mideastgirl | last post by:
I keep getting this error and I cannot figure it out. My curly brackets are closed, and I am using the correct tags for <?php to open and ?> to close my code. Can someone please help me! Here is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.