Crystal Report Login Problems in ASP

Hi! I try to preview a crystal report using asp,
it prompt 'CRAXDRT error Occured on server. -2147189176 : logi
failed'
Details : IM002 :[Microsoft][ODBC Driver Manager] Data sourcename no
found and no
default driver specified'.

This is wat I done in the Internet Server.

1. Install Crystal Report in Server.
2. Add new ODBC - User DSN.
3. Sharing report folder in IIS with 'Read'
and 'Directory Browsing'.

I use below syntax,



For Each mnTable in mainReportTableCollection

With mnTable.ConnectionProperties
Item("user ID") = "username"
Item("Password") = "password"
Item("DSN") = "dsnname"
Item("Server") = "Servername"
Item("Database") = "databasename"
End With

after only setting connection properties through the Table Collection?


-
jeremylim200
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

Jeff
Fri Oct 08 11:47:35 CDT 2004

Needs to be a System DSN, not a User DSN

Jeff
"jeremylim2000" <jeremylim2000.1dsv5t@mail.codecomments.com> wrote in
message news:jeremylim2000.1dsv5t@mail.codecomments.com...
>
> Hi! I try to preview a crystal report using asp,
> it prompt 'CRAXDRT error Occured on server. -2147189176 : login
> failed'
> Details : IM002 :[Microsoft][ODBC Driver Manager] Data sourcename not
> found and no
> default driver specified'.
>
> This is wat I done in the Internet Server.
>
> 1. Install Crystal Report in Server.
> 2. Add new ODBC - User DSN.
> 3. Sharing report folder in IIS with 'Read'
> and 'Directory Browsing'.
>
> I use below syntax,
>
>
>
> For Each mnTable in mainReportTableCollection
>
> With mnTable.ConnectionProperties
> Item("user ID") = "username"
> Item("Password") = "password"
> Item("DSN") = "dsnname"
> Item("Server") = "Servername"
> Item("Database") = "databasename"
> End With
>
> after only setting connection properties through the Table Collection??
>
>
>
> --
> jeremylim2000
> ------------------------------------------------------------------------
> Posted via http://www.codecomments.com
> ------------------------------------------------------------------------
>