Error 20599 Cant open sql server - parameters

[Maximark]

I have a crystal 8 report based on a System DSN ODBC connection to a sql database. The report has a parameter that asks what record you want to print report for. From crystal the report works fine.

I set up a VB6 shell that has one button on it to print the report. When i call the report the parameter screen comes up then the error message. I was getting a type mismatch but that has gone away. Any idea why the report is having so many errors being called from the VB app. Everything is on my machine, i have full rights everywhere.

 

[Maximark]

How do you pass server name, id and password on the call to the report?

I think that is where i am having the trouble.

 

[vidru]

Try something like this:

CrxRpt.Database.Tables(1).SetLogOnInfo [ODBC Name] , [databaseName], [username], [password]

--dave

 

[Maximark]

So i used this
CrystalReport1.Database.Tables(1).SetLogOnInfo ["SSSIRIMS"], ["IRIMSSample"], ["sa"], [""]

It came back saying SSSIRIMS - external name not defined.

How do you define the ODBC name

 

[GPOTony]

I get this error when the limit on the number of simultaneous connections to the database is exceeded. Also, if the User DSN is not set up correctly, which must be done from a fully privileged account.