Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2004-11-07
4
Medium Priority
?
588 Views
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
Cody
0
Comment
Question by:codydoyle
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:Alan Warren
ID: 12521194
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
0
 

Author Comment

by:codydoyle
ID: 12557084
Thanks for your time Alan, did not really answer my question, but thats not your fault, I appreciate your help.
Cody
0
 

Author Comment

by:codydoyle
ID: 12557092
It did have lots of useful info though.... thanks again
Cody
0
 
LVL 26

Accepted Solution

by:
Alan Warren earned 2000 total points
ID: 12560679
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:
http://www.experts-exchange.com/Databases/MS_Access/Q_10299054.html?query=Pervasive+SQL&topics=39

Here are some of the results
http://www.experts-exchange.com/Databases/MS_Access/Q_21125663.htm
http://www.experts-exchange.com/Databases/MS_Access/Q_20416968.html
http://www.experts-exchange.com/Databases/MS_Access/Q_10315385.html
http://www.experts-exchange.com/Databases/MS_Access/Q_20923327.html


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 http://www.experts-exchange.com/Community_Support/

Hopefully someone will have something for you though.

Take care...

Alan
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 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