?
Solved

cannot open sql server

Posted on 2001-06-29
15
Medium Priority
?
876 Views
Last Modified: 2011-09-20
I've got a vb6 app that uses the crystal activex control to open a crystal report
this vb app runs on a win2000 terminal server and connects to a sql2000 db.
When i log in as the administrator everything works,
but any other user ( even if that user is a member of the administrator group) I get a "cannot open sql server" error.

PS. All programs are installed using the add/remove programs applet

Please help!!
0
Comment
Question by:Heinrichsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +4
15 Comments
 
LVL 4

Expert Comment

by:jsweby
ID: 6237088
There are a couple of mentions of this on the Seagate Community site, some may be more relevant to you
than others:

1. "A default database must be set up in the ODBC Data Source Name (DSN). Once a path to a default database
was selected, the report ran without errors."

2. "This error message appears because the Crystal Reports physical server DLL for Microsoft SQL Server (P2ssql.dll) does not support using integrated security with the OCX.

In order to use integrated security with the OCX, use an ODBC or an OLEDB connection. For further information on using ODBC or OLEDB with integrated security, refer to kbases c2008291 and c2004937"

3. "This error occurs because the report uses the user id saved in the report rather than the NT Logon ID. To resolve this error, pass a blank value for the user id and password.

If you are connecting natively to a SQL type database, use the "Connect" property to specify the server and database name, but leave the user id and password blank. For example:

CrystalReport1.Connect = "DSN = server name; UID = ; PWD = ; DSQ = database name"

If you are connecting using ODBC to a SQL type database, use the "Connect" property to specify the server name, but omit the database name and leave the user id and password blank . For example:

CrystalReport1.Connect = "DSN = Your ODBC DSN; UID = ; PWD = "

Note: ======

- When using ODBC, your DSN should have "Use NT Logon" checked on in the ODBC Administrator."

Hope this helps,

J.
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6238604
If you want to use SQL security instead of NT security, use

CrystalReport1.Report.LogonServer("pdsodbc.dll","server name", "database name", "user name", "password")

0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6239290
Heinrichsa

Every question you have asked this year is still open.
0
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 
LVL 1

Expert Comment

by:kavithag
ID: 6248223
CrystalReport1.Connect = "DSN=dsnname;UID=user'PWD=Pwd;"
0
 

Author Comment

by:Heinrichsa
ID: 6248402
Thanks everyone for the comments

I found the solution.

The article c2007518 on www.crystaldecisions.com explains

I followed the advise and it solved the problem.
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6248998
There is no such article number.
0
 
LVL 1

Expert Comment

by:kavithag
ID: 6255875
If Ure not passing anyquery from VB to crystal report , check to see if the dsn name is hardcorded in the query in the Report (Design).
It can checked by Sql syntax.
0
 
LVL 4

Expert Comment

by:jsweby
ID: 6255903
Seeing as this question is dealt with, can you close it. Whoever you feel deserves the points should get them, although I did point you towards the Crystal Community!

;)


J.
0
 

Author Comment

by:Heinrichsa
ID: 6255992
DRRYAN3,
i'm sorry
the article no is c2007581
0
 
LVL 1

Expert Comment

by:Orion_Blastar
ID: 6270794
Windows 2000 and the P2SODBC.DLL file have some issues. You need to download the latest version of PS2ODBC.DLL from http://support.crystaldecisions.com/communityCS/FilesAndUpdates/p2sodbc8.zip.asp?rdrcnt=1

Or just do a search for p2sodbc8.zip on the Knowledge Base.

It fixed the problem for us, I hope this helps you out!
0
 
LVL 1

Expert Comment

by:Orion_Blastar
ID: 6270806
If you don't already have an account at Crystal, create one.

Enter P2SODBC8.ZIP from this web site:
http://support.crystaldecisions.com/updates/
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6402492
This question was LOCKED with a PROPOSED ANSWER and awaits your decision today.  Once a question is LOCKED with a Proposed Answer, few new experts will step in to help on that question, since the assumption is, you've been helped.  If the Proposed Answer helped you, please accept it and award that expert.  If it did not help you, please reject it and add comments as to status and what else is needed.
 
If you wish to award multiple experts, just comment here with detail, I'll respond as soon as possible.  As it stands today, you asked the question, got help and not one expert was awarded for the contribution(s) made.  Your response is needed.  I'll monitor through month end, and if you've not returned to complete this, we'll need to decide.  Expert input is welcome (as always) to determine the outcome here if the Asker does not respond.
 
Your response in finalizing this (and ALL) your question(s) is appreciated.
 
Moondancer
Community Support Moderator @ Experts Exchange

0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6403615
Moondancer,

This question was locked AFTER the user stated he had solved his own problem.
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6403708
Thanks, DRRYAN3, points have been refunded here, moving to PAQ at zero points.
Moondancer
Community Support Moderator @ Experts Exchange
0
 
LVL 27

Expert Comment

by:Dabas
ID: 11286195
jsweby,

If you are still around:

----------
If you are connecting using ODBC to a SQL type database, use the "Connect" property to specify the server name, but omit the database name and leave the user id and password blank . For example:

CrystalReport1.Connect = "DSN = Your ODBC DSN; UID = ; PWD = "

Note: ======

- When using ODBC, your DSN should have "Use NT Logon" checked on in the ODBC Administrator."

Hope this helps,

J.
----------

Three years later it did for me!
Thanks!

Dabas
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month12 days, 6 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question