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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBI Question

Status
Not open for further replies.
yim11

yim11

MIS
Jun 26, 2000
35
0
0
US
Hello,

If my perl scripts are on 1 server, and the SQL database I need to talk to is on a different server,
is there a way via DBI to connect to that database?

Something like:
my $DSN='dbname';
my $user = "loginname";
my $pass = "password";
my $DBD='ODBC';
my $server='123.456.789.0'
my $DBH=DBI->connect($DSN,$user,$pass,$DBD,$server);

I have read the DBI docs, but no mention is made of this so I was wondering if anyone has seen or done this before.

TIA for any and all assistance!
-jim
 
Sort by date Sort by votes
Hi Jim,

Two ways, that I know of, to do this.

1: Simplest way: If can install a ODBC driver on your client server you can connect to the Database through that.

2: There is a utility called dbiproxy which you can run on your database server, it listens for connection requests and allows remote clients to attahc to the DB in the way you need.

Any advance on wo ways anyone? Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PaulSc
  • Locked
  • Question
Find and Replace Regex question please 1
Replies
6
Views
116
PaulSc
PaulSc
meetme
  • Locked
  • Question
Perl format question
Replies
1
Views
65
1DMF
1DMF
1DMF
  • Locked
  • Question
DBI using DBD::ODBC on MS SQL 2008 R2 corrupting Unicode characters
Replies
0
Views
62
1DMF
1DMF
jcarrott
  • Locked
  • Question
Trying to use DBI::SQLite 1
Replies
6
Views
126
jcarrott
jcarrott
whn
  • Locked
  • Question
Questions about Getopt::Long 1
Replies
6
Views
145
rharsh
rharsh

Part and Inventory Search

Sponsor

Back
Top