on 11-14-2015 12:29 PM
Hello,
I have Visual Studio 2010 on my desktop computer and SQL Server 2014 Express on our Windows Server 2012 server.
In Crystal Reports > Database Expert > Create New Connection > OLE DB (ADO)
There is no Server Name in the "Server:"
How Can I connect Crystal Reports to our server?
Thanks
Hi Stevie,
You'll need to type in the Server Name.
You'd also need to use the 'SQL Server Native Client' driver.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is more of a SQL Server configuration issue.
Here's a possible resolution:
-Abhilash
Stevie, I am not sure what version of CR you are using - but seeing that you have VS 2010, I'd assume you are using 'SAP Crystal Reports, Developer Version for Visual Studio .NET" (?).
You need to be on SP 10 at minimum and I'd highly recommend SP 15 (). Additionally, according to the SAP Crystal Reports, developer version for Microsoft Visual Studio - Supported Platforms you should be using ODBC driver 11 for SQL Server (MSODBCSQL11.DLL).
If all of the above is satisfied, try the connection with SAP Crystal Reports 2013 - an eval of which can be downloaded from here:
SME Free Trials | SME Software | SAP
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter
Got Enhancement ideas? Use the SAP Idea Place
Hi Stevie,
If you are connecting to SQL Server 2012, I believe the native client should be 11.0. Version 10 is for SQL Server 2008.
The version I have is 2011.110.3407.00. Check to see if you have the latest drivers and update them if you don't.
I am also using Crystal 2008 with the 16 bit driver connecting to both SQL Server 2008 and 2012. So it should work as long as you have the updated driver.
Try using ODBC and see if that works better for you instead of ADO.
Good luck,
Brian
Hi Stevie,
From your Development machine, are you able to connect to the SQL Server database with SQL Server Management Studio?
When you configure your ODBC datasource in the ODBC Administrator, does the Test Connection work? You must be using the 32 Bit ODBC Administrator for Crystal.
Can you also verify the version of Crystal Reports you are using? Are you using 2008 or Crystal for VS2010?
I have had problems if you have the same datasource in both 32 and 64 bit ODBC. ODBC gets confused and doesn't know which one to open.
I checked our database server and we have NamedPipes as a protocol for SQL Server disabled. That's our configuration though so I would recommend you talk to your DBA before making any changes to the SQL Server configuration.
Good luck,
Brian
Hi Stevie
I am not sure about the namedpipes, but if you can, go with Brian's suggestion as at least we know that this works in his environment.
I'd also like to see what the CR 2013 designer says when you try to connect it. An Eval of CR 2013 (v.14.x) is available from here:
SME Free Trials | SME Software | SAP
- Ludek
Abhilash,
Just wanted to inform you that I'm able to connect now and this is what I did.
Also, wanted to thank Brian Dong and Ludek Uher for adding to the discussion.
Best regards
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.