• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

odbc dsn - how do I found out the datasource ( the ip address )

I have an ms access program that use odbc to link to a sqlbase database.

In the ODBC Data Source Administrator, under system DSN, i could see the dsn name
and the driver it using.

However I would like to more information regarding the DSN such as the machine
it is pointing to or any other info.
0
phiadmin
Asked:
phiadmin
  • 4
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Look at the server name.  Drop down to a command prompt and do:

 PING  <server name>

 and you'll have the IP.

Jim.
0
 
phiadminAuthor Commented:
I do not know the server name.  That is what I am trying to get know the DSN.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Here's how a ODBC connection works; at the point of making the connection, you need the server name, database name, and possibly a user name and password.  There may be other things as well that can be used, but those are the basics.

 That is supplied in a connection string, which may or may not reference a DSN.  If it does, information is first read out of the DSN.  Then anything in the connection string is applied.  Then a connection is attempted.  If anything is lacking, your prompted for it.

  Here's an example of a connection string:

Driver =SQLBaseODBC; ServerName =myServerAddress; Database =myDataBase; LogonID =myUsername; Password =myPassword;

  This one doesn't point to a DSN.

  So either the server name is in the DSN, or it's in the connection string in the application your using.  I'm assuming you have hit the "configure" button with the DSN selected and are not finding the server name in any of the configuration screens, which means that the server name is embedded in the connection string.

Jim.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  BTW, if you can open the DB with Excel or MS Query using the DSN alone, then the server name is in the DSN somewhere and your just not spotting it.

Jim.
0
 
phiadminAuthor Commented:
found the solution another way.

this solution helped but was not it.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<found the solution another way.

this solution helped but was not it. >>

  You should have posted that, accepted your own comment as answer and then gave me an assist if you felt that I helped you get there.

  Otherwise, I don't deserve the accepted answer and a B grade because you never returned to the question and asked for more direction.

Jim.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now