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
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
ASKER
Thanks for your time Alan, did not really answer my question, but thats not your fault, I appreciate your help.
Cody
Cody
ASKER
It did have lots of useful info though.... thanks again
Cody
Cody
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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