469,949 Members | 2,165 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

Crystal Report Login Problems in ASP


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 mainReportTableCollection
With mnTable.ConnectionProperties
.Item("user ID") = "sa"
.Item("Password") = "m-m-t-12:26pm-m"
.Item("DSN") = "odbc_winwin"
.Item("Server") ="MMXP"
.Item("Database") ="dbmlm_winwin"
End With
Nex
-
jeremylim200
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

Jul 19 '05 #1
2 6406
On Wed, 6 Oct 2004 02:15:29 -0500, jeremylim2000 <je******************@mail.codecomments.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 mainReportTableCollection
With mnTable.ConnectionProperties
Item("user ID") = "sa"
Item("Password") = "m-m-t-12:26pm-m"
Item("DSN") = "odbc_winwin"
Item("Server") ="MMXP"
Item("Database") ="dbmlm_winwin"
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..
Jul 19 '05 #2
You're setting connection properties AFTER you try to go through the Table
Collection?? How do you get the collection itself??

Jeff
"jeremylim2000" <je******************@mail.codecomments.com> wrote in
message news:je******************@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 speci
fied'.

I use below syntax,

For Each mnTable in mainReportTableCollection
With mnTable.ConnectionProperties
Item("user ID") = "sa"
Item("Password") = "m-m-t-12:26pm-m"
Item("DSN") = "odbc_winwin"
Item("Server") ="MMXP"
Item("Database") ="dbmlm_winwin"
End With
Next

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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jeremylim2000 | last post: by
1 post views Thread by codepuller | last post: by
3 posts views Thread by Deasun | last post: by
3 posts views Thread by Shawn H. Mesiatowsky | last post: by
1 post views Thread by CBKowitz | last post: by
19 posts views Thread by Michael O'Donnell | last post: by
12 posts views Thread by Murali via DotNetMonster.com | last post: by
reply views Thread by kolalakitty | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.