Link to home
Start Free TrialLog in
Avatar of codydoyle
codydoyle

asked on

local client dsn setup for connection to pervasive SQL server using remote desktop connection XP Pro

hello everyone,
I am having a hard time setting up a connection to a remote pervasive SQL server. I created the client DSN on the remote server and the engine dsn is already created. When I try to set up the DSN on my local machine I cant find the path for the server. Which Driver should I choose? I have attempet to connect using the sql driver but I dont have the option to browse for the connection. \\servername is not working. what is the correct path to the Remote Desktop Connection? I have virtually no experience with databases and do not want to do anything to corrupt the server's data. Your help would be appreciated. Thanx
Cody
Avatar of Alan Warren
Alan Warren
Flag of Philippines image

Hi Cody,

Pervasive not my thing really, but found some troubleshooting info here:
http://www.dataaccess.com/whitepapers/PervasiveWebApp.htm
see the section on:
Creating a Client Interface to Access a Database on the Server

Dont think you need to provide a path, just the server name.

Alan
Avatar of codydoyle
codydoyle

ASKER

Thanks for your time Alan, did not really answer my question, but thats not your fault, I appreciate your help.
Cody
It did have lots of useful info though.... thanks again
Cody
ASKER CERTIFIED SOLUTION
Avatar of Alan Warren
Alan Warren
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial