Java Discussion Boards

Hi all!

I want to get the database info( eg.instance;username)by using only IP.I don't know how to start.

thank you!

modified 5-Nov-12 10:27am.

XMafei wrote:
I don't know how to start.

You could start by giving some more details about your problem. You do not get information from a database just by giving the IP address, but by creating a connection to a database server and making requests, the IP address is just part of the connection string.

One of these days I'm going to think of a really clever signature.

eg input IP,UserName,UserPwd
output database info such as database instance,database user

XMafei wrote:
eg

input IP,UserName,UserPwd

output database info such as database instance,database user

I have no idea what that is supposed to mean. However, I suggest you spend some time reading about Java Database Access[^].

One of these days I'm going to think of a really clever signature.

XMafei wrote:
I don't know how to start.

You are referring to information that is database specific. So you research database specific protocols.

As an example of one such possibility you can look at the following

http://www.sqlmag.com/article/active-directory-service-interfaces-adsi/publishing-sql-server-in-active-directory[^]

And keep in mind that it is possible that one cannot get that information for some databases either because the database doesn't support it or because it is not published. That of course suggests that the best way and certainly the easiest is to just require that the user must provide that information.