Jump to content
WAPT Forum
Sign in to follow this  
Guest Matt01SS

WAPT Pro - Collect SQL performance counters statistics

Recommended Posts

Guest Matt01SS

When I click to Test ODBC connection I receive the message: "Data source name not found and no default driver specified".

 

I have configured a System DSN for the sql server to connect to. What am I missing?

Share this post


Link to post
Share on other sites
Guest angela
When I click to Test ODBC connection I receive the message: "Data source name not found and no default driver specified".

 

I have configured a System DSN for the sql server to connect to. What am I missing?

 

 

Open Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN. Select data source and click Configure... Check all settings when finish dialog opens click Test Data Source... . If test secceeded check the name of Data Source in WAPT.

Share this post


Link to post
Share on other sites
Guest holyl

I have setup on server that holds the sql server a dsn as described above

 

in the wapt workplace, i check collect sql performance

dsn = is the name of dsn that i named on server

user and password are for what ?

 

i enter sa user and password .. but still get "Data source name not found and no default driver specified".

 

how does the workplace knows from dsn name where the sql server

 

what to do to have this working?

 

 

 

 

Share this post


Link to post
Share on other sites
Guest angela
I have setup on server that holds the sql server a dsn as described above

 

in the wapt workplace, i check collect sql performance

dsn = is the name of dsn that i named on server

user and password are for what ?

 

i enter sa user and password .. but still get "Data source name not found and no default driver specified".

 

how does the workplace knows from dsn name where the sql server

 

what to do to have this working?

 

 

What server do you have?

Share this post


Link to post
Share on other sites
Guest holyl
What server do you have?

ok..i know how to do it now.

 

on my local pc, need to create a dsn that references database on server

then call it from wapt pro

 

 

Share this post


Link to post
Share on other sites
ok..i know how to do it now.

 

on my local pc, need to create a dsn that references database on server

then call it from wapt pro

 

Yes, you are right. You should configure system DSN on a computer where WAPT Pro Interface is installed.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×