Cannot find DSN in connection string
I'm trying to use a connection string in my Crystal report, connecting to a SQL 2000 server. I use this string in my ASP page just fine, but when I try to use it in my Crystal report, I get the error "Cannot find DSN in connection string"
here's the string that works fine for my .net app:
Data Source=servername;Initial Catalog=dbname;Persist Security Info=True;User ID=username;Password=password
I enter this string in the first window, and it asks me for the server, user and pw again, but never connects. I can connect using a DSN, but would prefer to use the connection string.
Any help is appreciated. -Eric