Shane Richard wrote:
>
> ----- Original Message -----
> From: Shane Richard
> To: msql-mysql-modules@stripped
> Sent: Sunday, August 15, 1999 1:15 PM
> Subject: mSQL - Perl Problems
>
> I am trying to use a Perl script to connect to a mSQL database. I have created a
> single table in the database (called Restaurants), and have created a sequence on that
> table. I have verified the existence of the table and sequence using the Control Panel
> provided by my website host (Hiway). To my knowledge, mSQL 2.? and Perl 5.0.? is being
> used.
>
> When I try to run the following script:
>
> print "Content-type: text/html\n\n";
>
> use Msql;
>
> $db1 = Msql->Connect("", "{database name}") or die;
>
> $sth = $db1->Query("select City from Restaurants");
>
> print $Msql::db_errstr, "\n";
>
>
>
> I get the following error:
>
> Error reading table "Restaurants" definition
>
> When I try to run the following script:
>
> print "Content-type: text/html\n\n";
>
> use Msql;
>
> $db1 = Msql->Connect("", "{database name}") or die;
>
> $sth = $db1->Query("SELECT _seq FROM Restaurants");
>
> print $Msql::db_errstr, "\n";
>
> I get the following error:
>
> Syntax error near "_"
>
> I would appreciate any help that you can provide me in finding the cause and fixing
> these 2 errors.
>
> Thanks,
>
> shane@stripped
mSQL and MySQL are two very different things. This list is for MySQL
issues. There are two things you can do:
- find an mSQL list ( not recommended)
- upgrade to MySQL ( recommended)
--
Sasha Pachev
http://www.sashanet.com
