472,337 Members | 1,284 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,337 software developers and data experts.

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 6508
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: jeremylim2000 | last post by:
Hi! I try to preview a crystal report using asp, it prompt 'CRAXDRT error Occured on server. -2147189176 : logi failed' Details : IM002 : Data...
3
by: Michael S | last post by:
only my server get the report whitout the dialogue database login. I think it is where the database is localhost and the crystal report know not...
1
by: codepuller | last post by:
Consider this approach: Embed the report in your project (add it to the project) Then put this code in the page that holds the viewer control...
3
by: Deasun | last post by:
I need some help please! Crystal is driving me nuts. Heres my code so far, see below. Problem: On the .export() line it comes back with error #5...
3
by: Shawn H. Mesiatowsky | last post by:
I have come across lots of information regarding this, but nothing seems to work. I have created a Crystal Report that access's a SQL server backend...
1
by: CBKowitz | last post by:
I have an intermittent problem, when viewing a crystal report. This problem only happens to some users and some report formats. When they try to...
1
by: Harshil | last post by:
Hi All, I am working on Vb.net application with oracle as my database. I have developed reports using crystal report 9. Usually when you open...
19
by: Michael O'Donnell | last post by:
Hi All Am having major problem with crystal reports...Have designed my report no problem, its when I try to run and display ther report that I...
12
by: Murali via DotNetMonster.com | last post by:
Hi All I am new to .net, as i worked majorily on VB6.0 & Crystal reports, I have developed an Window application in VB.net/SQL Server2000 and using...
0
by: kolalakitty | last post by:
Hello, I'm new to using Crystal Reports and have run into a problem. I'm currently designing a new database for a company. The front end...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.