December 11, 2013 at 3:13 pm
Hi all,
I have created a report on Microsoft Access by connecting to SQL Server using SQL Server Native Client 11.0 driver and was able to refresh the results with out any problem. The whole point of creating the report is that sales team can access it without any issue but, they are getting the error "ODBC-connetion to 'SQL Server Native Client 11.0' failed". Do they need to install ODBC driver or SQL Server 2012 installed on their laptop to access the file i created.
I thought they could do it without installing anything.
Can anyone please give me an idea?
Thanks
Sri
December 12, 2013 at 5:26 am
Sri,
Assuming Access is running the report on their machine, yes.
A better solution may be to make it web based to avoid Access altogether.
Mark
December 12, 2013 at 7:30 am
Mark,
Yes, the Access report will be running on their (sales team) machine.
May i ask what is a web based report?
Sri
December 12, 2013 at 8:00 am
Web Based report is like using SSRS, it's web based and it comes with the SQL licensed install. Just a guess at what Mark is talking about.
MCSE SQL Server 2012\2014\2016
December 12, 2013 at 8:03 am
You can use SSRS or create a small web site on an internal web server and create some basic .net web pages that act as reports and shows the data. This would allow you to connect directly to either database and eliminate the need to install anything on the client machines.
Mark
December 12, 2013 at 8:29 am
OK, thanks to all.
I don't have SSRS on the SQL Server i am working on. I need to install it and start working on it.
Thanks for your help again.
December 12, 2013 at 8:29 am
You can import your reports into SSRS from Access, and as long as you're not using VBA functions in queries that your reports are based on, they should work. (Well, you may have to rewrite some of the queries, because T-SQL and Access SQL are slightly different.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply