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

Posted on 2004-11-07
Last Modified: 2008-02-01
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
Question by:codydoyle
    LVL 26

    Expert Comment

    by:Alan Warren
    Hi Cody,

    Pervasive not my thing really, but found some troubleshooting info here:
    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.


    Author Comment

    Thanks for your time Alan, did not really answer my question, but thats not your fault, I appreciate your help.

    Author Comment

    It did have lots of useful info though.... thanks again
    LVL 26

    Accepted Solution

    Hi Cody

    Thats ok, hope you get it sorted out, usually with odbc sources and Access we set up a system data source in
    Contol Panel > Data Sources(ODBC)

    Sorry I couldn't be more informative.
    I did a search on EE using this querystring:

    Here are some of the results

    You may be able to post a comment linking to this Q in any of the links you find possibly useful, try to drum up some support.

    If your Question doesn't gain any further attention in the near future you can post a request in the community support TA to have your point refunded

    Hopefully someone will have something for you though.

    Take care...


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction After workin in a plethora of programming languages like C, Pro*C, ESQL/C, C++, VC++, VB, Java, HTML,JavaScipt etc, technologies and frameworks like JSP, Servlets, Struts, Spring, IBatis etc and databases like MS Access, SQLServer, Inf…
    In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now