DBI drivers? 1

[Krel]

OK, I got the DBI module installed on my system, as well as mySQL. Now, I read that the syntax for connecting to the database is $dbh = DBI->connect("dbi:driver:instance","username","password"

My question is, what do I put for "driver" and "instance" if I'm using mySQL?

Sorry for the pathetic question; I just decided to learn about databses, so right now I'm totally clueless, hehe. =)

 

[Krel]

Actually, I found out that I had to install the mysql driver first. I d/l it, but I'm unsure of where to put it...

 

[markbanker]

Krel,

$dbh = DBI->connect("dbi:MySQL:dataSourceName","username","password"

The driver is the name of the driver you have installed. It is likely MySQL or ODBC.

The instance is the data source name you have set up to represent your database.

Username and Password are optional....if you don't use them, you may skip them.

I hope this helps.

Mark Banker

 

[Krel]

Ok, I got the driver installed fine. I don't understand this, though:

"The instance is the data source name you have set up to represent your database."

How to I set this up? Is it just the name of the database?

 

[Krel]

Nevermind, I got it working. Thanks for your help.