Crystal Report Login Problems in ASP

[jeremylim2000]

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 n
default driver speci
fied'.

I use below syntax,

For Each mnTable in mainReportTable Collection
With mnTable.Connect ionProperties
.Item("user ID") = "sa"
.Item("Password ") = "m-m-t-12:26pm-m"
.Item("DSN") = "odbc_winwi n"
.Item("Server") ="MMXP"
.Item("Database ") ="dbmlm_winw in"
End With
Nex
-
jeremylim200
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

[Turkbear]

On Wed, 6 Oct 2004 02:15:29 -0500, jeremylim2000 <je************ ******@mail.cod ecomments.com> wrote:

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 speci
fied'.

I use below syntax,

For Each mnTable in mainReportTable Collection
With mnTable.Connect ionProperties
Item("user ID") = "sa"
Item("Password ") = "m-m-t-12:26pm-m"
Item("DSN") = "odbc_winwi n"
Item("Server ") ="MMXP"
Item("Database ") ="dbmlm_winw in"
End With
Next

Be sure that there is a DSN named odbc_winwin on the SERVER that is running the crystal servers..

Be sure that the account under which the pageserver and jobserver runs have access to that DSN.

Be sure the DSN can connect to that database..

[Jeff Dillon]

You're setting connection properties AFTER you try to go through the Table
Collection?? How do you get the collection itself??

Jeff
"jeremylim2 000" <je************ ******@mail.cod ecomments.com> wrote in
message news:je******** **********@mail .codecomments.c om...

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 speci
fied'.

I use below syntax,

For Each mnTable in mainReportTable Collection
With mnTable.Connect ionProperties
Item("user ID") = "sa"
Item("Password" ) = "m-m-t-12:26pm-m"
Item("DSN") = "odbc_winwi n"
Item("Server") ="MMXP"
Item("Database" ) ="dbmlm_winw in"
End With
Next

--
jeremylim2000
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------