Connect to Pervasive database remotely

First things first:  Using the PCC, can you connect to the server from the Client?  If you've not done so yet, right-click the Engines and select Add/Server.  Enter the server name, and it should connect.  Now, verify that you can open the server and see the named databases.

Second, what kind of connection are you attempting?  DSN? DBName? DSN-less?  If possible, provide your complete connection string.  Also, if possible, provide a screenshot of both the PCC showing the named databases on the server.  If using a local DSN, provide a screenshot of the ODBC Administrator showing the DSN you have configured.

Bill,
Yes on the local network I can connect from a client (windows 7) using PCC and can see the named database. Same on the server itself, I can see databases and tables.

I'm attempting to use DNS. So far all I have attempted is connect from the remote server using PCC to the local server.

Here is the screenshot

The server is working fine, then, as is the PSQL Client.

Is your odbc application 32 bit or 64 bit?
Is the dsn that you created 32 bit or 64 bit?
Can you post the screenshot of the dsn?

32 bit. On the remote server, I'm trying to create a DNS and when I enter the IP of the server with the PSQL database I get the following. I'm not sure I'm doing is the correct way.

Here is the screenshot where I'm trying to create a DNS to the remote server when I click get DNS List
 

Since the pcc is working, stick with the server name, not the ip address.  Clearly, WIN-SQL is working. Why are you trying to use the ip here?

The WIN-SQL is the local server name. On the remote server, the WIN-SQL does not resolve to the database server. The last screenshot is on the remote server

In the remote server PCC is not works as I mentioned before

You have me confused, now.  In your message above, you state: "Yes on the local network I can connect from a client (windows 7) using PCC and can see the named database."  Then, you say "In the remote server PCC is not works".  So, is the PCC working or NOT working?

While you are checking that, check for valid name resolution.  On the client PC in a command prompt, run "PING WIN-SQL" and check that the server responds AND that it is the correct IP address for the server.

By remote server, I mean over the WAN

I have the local server with Pervasive and the database which is server A. I have the remote server B from where I want to connect to the server A (WAN).

When I test PCC on server A it works. Also when using PCC on the local network using a Windows 7 computer to server A it works

When using PCC from server B (remote over WAN) to server A (local) it does not work.

Yes, there is name resolution on the local network.

On server B there is no name resolution to server A and that is why I'm trying to use public IP with port forwards.

In my first post, I did already mention that I can telnet from remote (WAN) to the local server on port 1583 so port forward is working.

I will try the rest

That was it! All I did is forward port 3351 and it works! Thanks Bill for your help.

Oops forgot to close the question

Port 3351 was needed.