473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 6586
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 sourcename no found and no default driver...
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 the connection string. how I can crystal reports...
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 'Set the connection information...
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 Login failed! I know the login info is good so...
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 for the data, and I want to display the report...
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 view the report in Microsoft Word format the...
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 reports directly in crystal report viewer control it...
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 am getting a "Login Failed" message. At first 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 Crystal reports8.5, I have used the CRViewer in...
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 application is being coded in C# using Visual Studio.Net...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.