RE: Database with W2k

[Steve Howard]

I'm not sure I am seeing everything that is required in your connection
string:


$dbh = DBI->Connect("dbi:mysql:logs","xperl","002255") or die("Where is
connection:",DBI::errstr);

You are using DBI:mysql:logs          but where is the location and port
number?

This is an example of the connection info as I connect to MySQL using WIN2K.
You don't have to use the same structure, but I find it easy to read this
way. The items that are not in your connection string are the last two
variables  I have defined as part of the my $database line.


  use DBI;
  my $database_name     = "test";
  my $location          = "localhost";
  my $port_num          = "3306"; # This is default for mysql


  # define the location of the sql server.
  my $database          = "DBI:mysql:$database_name:$location:$port_num";
  my $db_user           = "sa";
  my $db_password       = "sa";

  # connect to the sql server.
  my $dbh       = DBI->connect($database,$db_user,$db_password);



Hope this gets you going. Let me know if it doesn't

Steve Howard


-----Original Message-----
From: XPerl [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 12:08 PM
To: Steve Howard; [EMAIL PROTECTED]
Subject: Re: Database with W2k


>Could you include the script you are running when the >error is thrown?

Here is the script..

Thanks.


----- Original Message -----
From: "Steve Howard" <[EMAIL PROTECTED]>
To: "XPerl" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 7:42 PM
Subject: RE: Database with W2k


Could you include the script you are running when the error is thrown?

Steve Howard

-----Original Message-----
From: XPerl [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 11:31 AM
To: [EMAIL PROTECTED]
Subject: Database with W2k


Hi to all,

I want to use Mysql database with Perl on a w2k professional system.

Firstly I installed the mysql-3.23.38 to the system. I started mysql, create
some databases and tables as ordinary.

After this installation process, I use the activeperls package manager to
install the DBI module and to install the DBD-Mysql module. I installed two
of the modules as ordinary.

But when I write a script and wish to connect a database I give an error,
that the perl debuuger can't locate the "auto/DBI/Connect.al" file.

Have you any idea, about this problem?
What is wrong with the modules?
And of-course, I wanna ask you that how can I solve this problem?

I started to work with these modules and mysql and of-course w2k newly.

Thanks for your interest...
Sorry for my bad language..