on 08-14-2016 12:16 AM
Recently have started using SQL Server for my databases… when it came time for me to run some reports in Crystal I cannot get a connection. I have Crystal Reports 2013 and SQL Server 2012. I have Googled and YouTube to death any help would be appreciated.
What is the error message you get when running the report?
Also I hope that you have created a 32bit ODBC system DSN connection for the report?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for the late reply I had to turns things off yesterday. I have attempted to make a DSN connection. From the Administrative tools>Data Sources (ODBC)>System DSN, with all different kinds of selections relating to SQL server and Crystal Reports. I don't want to send you snapshots of all my configuration settings for each one but every time that I hit test connection it failed. My PC is a (Windows 7 64 bit), not sure what or how to create a 32bit ODBC system DSN connection. Have a good day.
its a good practice to connect Crystal Reports to MS Access database via an ODBC connection. Then use it in the report.
Another reason for doing this is on the BO server if the same location is not available then you only need to create an ODBC connection with the same name and Crystal Report will pick the connection automatically. As the database configuration is done with the same connection name.
Problem solved!!!!! Database Expert>New Connection>OLE DB (ADO)>OLE DB Provider>Microsoft OLE DB Provider for SQL Server>(make sure that your server name is the correct one!. I had to run a SQL statement for server name on my PC
SELECT @@SERVERNAME AS 'Server Name';
The name of the Server that I was using was wrong.
Select Integrated security> then in the Database section when you select the down arrow the SQL database/s will appear. Amen thanks for the help. Good night
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.