I am making a Pervasive ODBC connection on a Novell 4.11 network. The client and engine seem to be pointed in the right direction where a DDF file exists. Had to Add programs, XP Standard and added MSQuery this afternoon.
"Error during connection". It is telling me I can not get to...
Dreamboat,
Last week I was in Excel refining a project, making the command button for the person who could not remember to data >refresh. Decided I didn't like the refresh upon open but rediscovered the minute by minute option. My user is a picky person and likes to CYA. So I knew she would...
Did you check out the External Data Range Properties? You can set it to refresh upon open or tell it how many minutes. I've only used the refresh on open. In the data range, this would be tool > get external data >External Data Range Properties.
Or
I recorded a marco and got this...
Humm. On my home/office NT network I was able to duplicate the problem. I can import a table into Access but get an error message with a Link file. The application can create a DDF file for each folder (each folder is a company) and this must have some workaround for their field naming...
"Somebody" moved a database that used pervasive from a workstation I will call WSPSQL (which acted like a server) to a Linux server. They also moved an Access database that does a simple file import on user demand.
Why is WSPSQL the only workstation that can import a file into...
It could be many things and I offer moral support.
These kind of non-specific error messages drive me nuts. I got this message a year ago because I needed to put in the IP address instead of the server name, while so called experts outside this forum "never had any problems" with...
Our hero discovered the cause. In ODBC (Control Panel > ODBC32) There is a tab called Tracing, with two confusing buttons in Win98. Make sure the button is toggled to read "Start Tracing Now", so that it is turned off. See the default SQL.log file? That is where all the activity...
Ditto above comment and a suggestion in the meantime.
Turn the calculation mode to manual instead of automatic. Tools>options>calculations . You will get to know the F9 key but at least you can change data without waiting for it to recalc.
I would edit>move sheet to a new workbooks and play...
Client moved a Pervasive database to a RedHat sever from a workstation. In Access I have a routine that imports 6 files and a button on the switchboard that triggers the process. Before the move, when Access, its databases and the pervasive databases were all on the workstation, it took less...
Thanks for this tip, did not know about ODBC.ini
Wouldn't it be nice just to copy the file from the old to the new. I think I see why that will not work when I look at my Pervasive links.
Chris
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.