Skip to main content
Question

Can't access Pervasive database

  • March 29, 2018
  • 3 replies
  • 85 views
chris_m
Participant
Forum|alt.badge.img+1

I get the following error when trying to access a Pervasive SQL database

Starting translation...

FME 2018.0.0.0 (20180308 - Build 18284 - WIN32)

FME Database Edition (node locked-crc)

Temporary License: 16 days left.

Machine host name is: cmcclain

Operating System: Microsoft Windows 10 64-bit (Build 16299)

Copyright (c) 1994 - 2018, Safe Software Inc.

Safe Software Inc.

Creating reader for format: Pervasive PSQL

Trying to find a DYNAMIC plugin for reader named `PERVASIVE'

Loaded module 'PERVASIVE' from file 'C:\\apps\\FME\\plugins/FME_ADO.dll'

FME API version of module 'PERVASIVE' matches current internal version (3.8 20180209)

Pervasive Reader: Read 0 DEF line(s). Found 0 attribute(s)

Pervasive Reader: Opening `mcsdb' for read operation

Pervasive Reader: Connection failed. Connection string `Provider=MSDASQL;DSN=mcsdb'. Provider error `(-2147217843) [PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine][Data Record Manager]Invalid user authorization specification.'

Failed to open reader

Failed to obtain any schemas from reader 'PERVASIVE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

FME Session Duration: 0.3 seconds. (CPU: 0.1s user, 0.1s system)

END - ProcessID: 5376, peak process memory usage: 40568 kB, current process memory usage: 40528 kB

Failed to obtain any schemas from reader 'PERVASIVE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Program Terminating

Translation FAILED.

Workspace generation failed. Parameter file was C:\\Users\\cmcclain\\AppData\\Local\\Temp\\FME_1522349455173_6808.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

trentatsafe
Safer
Forum|alt.badge.img+6

Hello @chris_m,

At first glance, this appears to be a permissions error.

At what point does this error occur? Does this occur when trying to select a table, or after selecting a table and trying to add it to the workspace(clicking OK on the reader)?

chris_m
Participant
Forum|alt.badge.img+1
  • chris_mParticipant
  • Author
  • Participant
  • April 3, 2018

Hello @chris_m,

At first glance, this appears to be a permissions error.

At what point does this error occur? Does this occur when trying to select a table, or after selecting a table and trying to add it to the workspace(clicking OK on the reader)?

I get the error when i hit the button to get the list of tables

 

chris_m
Participant
Forum|alt.badge.img+1
  • chris_mParticipant
  • Author
  • Participant
  • April 3, 2018

Hello @chris_m,

At first glance, this appears to be a permissions error.

At what point does this error occur? Does this occur when trying to select a table, or after selecting a table and trying to add it to the workspace(clicking OK on the reader)?

@trentatsafe I was also able to import the data into MS Access 2010 via the ODBC connection

 

Community Stats

32,182
Posts
122,179
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.