Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get servername and default database from ODBC DSN?

Status
Not open for further replies.
sonname

sonname

Programmer
May 18, 2001
115
0
0
US
I'm a perl newbie so apologies if this is really simple. I have a perl script where I access a DSN. What I'd want to do is retrieve the Server Name and the default database where the ODBC DSN is pointing to? For example I have

my $sourcedb = new Win32::ODBC("DSN=$sourcedsn;")

Is there a way to get the server name and the default database that is stored in the $sourcedsn? Is there such a call?
 
Status
Not open for further replies.

Similar threads

rob54321
  • Question
Perl how to read line from file with interpolation 1
Replies
6
Views
173
rob54321
rob54321
newbie1238585
  • Locked
  • Question
Perl how to read string in csv file * as wildcard operator
Replies
2
Views
110
mikrom
mikrom
ss_ham
  • Locked
  • Question
in Perl find call looking to exclude folder and ignore duplicate finds.
Replies
2
Views
73
ss_ham
ss_ham
Limbomusic
  • Locked
  • Question
Perl files getting accessed directly
Replies
0
Views
66
Limbomusic
Limbomusic
Dino_1000
  • Locked
  • Question
Use the perl debugger to dump all the data in a string variable
Replies
0
Views
78
Dino_1000
Dino_1000

Part and Inventory Search

Sponsor

Back
Top