Hi Justin,
The backslash is used to escape the letter following it, which in your
case converts '\S' to a 'S'. To insert a backslash you need to escape
it so it keeps it's leteral meening.
Try:
$dbh = DBI->connect("DBI:ODBC:ok","MITSOL\\SQLExec");
or even this should work
$dbh = DBI->connect("DBI:ODBC:ok",'MITSOL\SQLExec');
This should work because single quotes do not perform interpolation of
it's contents and pass it through literally.
Gary
On Friday 04 May 2001 11:13 am, justin todd wrote:
> Hi
>
> This is my connect string.
> $dbh = DBI->connect("DBI:ODBC:ok","MITSOL\SQLExec");
>
> This is the error message.
>
> The specified CGI application misbehaved by not returning a complete
> set of HTTP headers. The headers it did return are:
> DBI->connect(ok) failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Login failed for user 'MITSOLSQLExec'. (SQL-28000)(DBD:
> db_login/SQLConnect err=-1)
>
> As you can see the back slash has been omitted from 'MITSOLSQLExec'.
> Why is this happening? I have tried putting two backslashes but that
> dont work either. I know that the backslash is a type of ignore
> command in perl so is this a problem?
>
> Any suggestions?
>
> Justin
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
