Connecting to SQL Server thru System ODBC

[jnphillips1970]

Using Version 8.5 of Crystal, SQL Server 7.0, NT 4.0 OS

I am attempting to connect to SQL Server stored procedures through Crystal Reports, using a system ODBC driver. All the stored procedures have execute permissions using the id and password referenced in the ODBC connection. However, when in development, the only stored procedures (or any other database object) that can be referenced from Crystal are those that have specific permissions to my NT/2000 login.

Researched on Crystal website, found article C20007581 which references problems accessing ODBC connections when you don't have administrator rights (I don't) applicable to version 8 only. Tested by having an administrator login and using the same ODBC connection, still could not see any objects. Tested on another box using Crystal 8, same issue resulted.

I would like to be able to access and develop using these stored procedures without having to give myself (or any other developer) specific access on their NT login. Any suggestions would be appreciated!

 

[FredHelm]

The problem arises because Crystal Reports stores the UserName and Password as part of the rpt file. I solved the problem by connecting to the database through a database user instead of a NT user. In the production environment the database user does not have to exist because that information is being passed by the SetLogonInfo function. I assume that you are creating an external application to call your Crystal Report. When setting up you ODBC on your development machine use the database user option.