Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 16, 2010 at 02:25 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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