Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Error

Status
Not open for further replies.
malk

malk

MIS
Dec 12, 2000
84
US
When I view my report with the ActiveX Viewer on the PC i designed the report on, it works fine. However, when I try running it on another computer, I get SQL server violation error. The report uses ODBC data, but not SQL. When I checked the crystal site for patches they told me the problem was fixed in the latest release of CR 8. I installed that version, and resaved all the reports, but i am still getting the error when I try to run it on other workstations. Does anyone know anything about this error? Please Help!
 
Sort by date Sort by votes
malk: I think your problem may bee logon problems with your data source. Suggest you check your code includes a LogoffServer call before you LogonServer or SetLogonInfo to 'force' a re-connection David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
Upvote 0 Downvote
Where do I put that code? I have no logon server now, it is just a CSV file declared as ODBC
 
Upvote 0 Downvote
i have a menu of reports. When you click on the report you want it runs thst report. with the ActiveX viewer.
 
Upvote 0 Downvote
malk: How is the menu produced? Is this a VB app which gives you the menu in the first place? David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
Upvote 0 Downvote
Have you confirmed that the DSN is configured correctly on the other PC to read the CSV file? Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Upvote 0 Downvote
How can I set that up? Should it not be part of the setup? If it is not, how do I do it manually?
 
Upvote 0 Downvote
I am not sure what setup you are referring to.

It appears that you have a VB application launching the report. Did you write the application yourself? How is the text file created? Who setup the ODBC DSN on the original PC?

DSN's are created in the ODBC Administrator, which is in the Control Panel.

Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Upvote 0 Downvote
The CSV file is creaed through my DOS program. The ODBC was created by me in CR8, and the VB app was also created by me in VB6.
 
Upvote 0 Downvote
It sounds like you expected the VB App setup to automatically create the necessary DSN? I think that is the mistake. If you open up the ODBC Adminstrator on the target PC I think you will find that the DSN is missing. To create it you would have to do what you did when you created the DSN on your PC. You don't need CR to do that, you can do it in the ODBC Admin. You can also have your applicatin installation do it, but I couldn't tell you how. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
Error when creating parameter fields
Replies
4
Views
197
kray4660
kray4660
Maverick2021
  • Locked
  • Question
runtime error 20567 "page header/footer is larger than page"
Replies
0
Views
202
Maverick2021
Maverick2021
TariqMehmod
  • Locked
  • Question
Query from Sqlserver to Crystal Report
Replies
1
Views
134
kray4660
kray4660
aj3221
  • Locked
  • Question
DAO Error Code: 0xcca
Replies
3
Views
236
SkipVought
S
patsylipp
  • Locked
  • Question
Crystal Reports 2013 -sql expression
Replies
3
Views
115
APB-Reports
APB-Reports

Part and Inventory Search

Sponsor

Back
Top