Can't access stored procedures

[Vido81]

Hi everyone,

let me start by saying that I am totally new to Pervasive (I am working on the version 8). I need to take some data out of Pervasive to use it in some Sql Server Stored Procedures.

I have created some Stored Procedures in Pervasive to facilitate my work and they worked just fine.

Unfortunately, I had to do some operations in the software that uses Pervasive and my stored procedures are no longer accessible. I can see them through the Pervasive Control Center (as icons), but when I click on them I get the following message:

[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: X$Proc.

I looked through the various tables and I find out that I have to insert a record in the table X$File as to make the X$Proc table come back into the database.

Unfortunately, though, I cannot inser records in the X$File table by using the INSERT INTO sql statement.

My question to you experts is the following: how can I insert a new record into the X$File table? Or is there another way to make the X$Proc table come back into the database?

If I call the stored procedures through the CALL sql statement, they return the correct data, so I assume their sql must be stored somewhere. It must still be there.

Thanks for your help.

 

[mirtheil]

Sounds like your DDFs were replaced at one point. To make the X$PROC entry come back, you'll need to:
1. Temporarily rename PROC.DDF to PROC.OLD
2. Create a stored procedure (doesn't matter what it's called or what it does).
3. close the PCC (and any applications using the DDFs.
4. delete the new PROC.DDF (it's created in step 2).
5. rename PROC.OLD back to PROC.DDF.
THe Procedures should be available at that point.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Vido81]

Mirtheil,

just tried your solution and it worked!

Thank you SO MUCH!