Getting ODBC error when testing connection in ODBC DSN setup

[SBendBuckeye]

I haven't worked with Pervasive before so please bear with me if the answer to this is obvious (I have created quite a few DSNs using SQL Server). We have 2 user level DSNs defined, one for test and one for production. Both were working earlier this morning.

Then all at once I started to get the following error when I click the Test connection button during DSN setup:

[Pervasive][ODBC Client Interface][Client LNA]Disconnect Error; Transaction rolled back.

This is true at other work stations also. If I was going to get an error something like the above, would I not expect to get a Connection error instead of a Disconnection error?

Thanks for any ideas, suggestions, etc!

Have a great day!

j2consulting@yahoo.com

 

[TomKane]

I was curious to know how you got on with that problem.

 

[SBendBuckeye]

Hello Tom,

Someone ended up rebuilding the server DSNs somehow. I'm not sure exactly what they did.

Have a great day!

j2consulting@yahoo.com