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!

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

Server has not yet been opened ????????

Status
Not open for further replies.

121278

Programmer
Aug 6, 2001
35
AT
Ive got this strange error message:
when i_m looking at reports without any content
from databases they work correctly and i can
see them with the activex viewer.
When i insert Database fields the following message
occurs:

Error Occurred Reading Records: Server has not yet been opened.

why does this happen?
the reports work local(through crystal reports 8.5)
i gave them into a virtual directory in the IIS,
and started them with the Code Samples (aspxmps85.zip)
from seagate (simlpepreviewreport.asp)-
did i forget something?
 
Someone gave me this information and it worked. but right now I am having the connection not opening. Give it a try.

rptServer = "serverName"
rptDatabase = "DBName"
rptUserid = "ID"
rptPassword = "PWD"
' Set the location
set crtable = session("oRpt").Database.Tables.Item(1)
crtable.SetLogonInfo CStr(rptServer),CStr(rptDatabase), cstr(rptUserid), cstr(rptPassword)
'to test whether or not connection is made to the server
response.write crtable.testconnectivity

Also if you are using ODBC connection make sure all are the same on the server and your machine.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top