Cannot find DSN in connection string

[Former Member]

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

[former_member11696]

Data Source=servername is where your DSN name should be specified not servername

[Former Member]

Thanks for the response, Don, but I am trying to AVOID using a DSN, which is why I wanted to use a connection string.

I have actually found out the problem. I was missing the driver name in my connection string.

I entered DRIVER=SQL Server into the connection string field on the ODBC configuration screen, hit next, and it let me enter my server, username, password and database name. After that it worked like I wanted.

Edited by: chihuachsund on Feb 16, 2010 4:30 PM