Connection Problems for a report from ASP

[Craigs]

CRAXDRT Error occur on server. Server has not yet been opened.

This is the error i come up with when i refresh the report that im running using ASP and crystal reports 8.5 Connecting to SQL2000. I've looked through the forums. Im using
Database.Tables(1).SetLogonInfo "Servername", "Databasename", "sa", ""

As the connection.

Any help would be good.

Thanks

Craig

 

[mmaz]

Are you using SetLogonInfo for each sub report, if you have any?

 

[Craigs]

Im not using any sub reports.

 

[mmaz]

Do you have more than one table for this report? If you do, you should use SetLogonInfo for each table.

 

[balves]

If all of the tables in the report come from the same data source, then connecting to the first table is good enough. Of course, it wouldn't hurt to connect to each table.

Is the Web server a different box than the database server?

One thing to always try is connecting with another tool like Access or SQL Query, using the same parameters to the same server/database/user/password. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer