Solved

Need help with making an OLEDB connection to SQL Server`

Posted on 2011-09-12
6
288 Views
Last Modified: 2012-05-12
I have a front end that is currently using an ODBC file DSN to connect to SQL server for table linking and pass through queries.   Our IT department has asked that a OLEDB connection be used to SQL Server.

I followed the instructions at the link below and created a udl file, but I am unsure of how to use it to connect to data.  
http://wiki.answers.com/Q/How_to_set_up_an_OLE_DB_connection

How do I link my tables and pass through queries using this?

0
Comment
Question by:snyperj
  • 3
  • 2
6 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
ID: 36522796
As far as I know, you don't have such choices.

Access to SQL Server linked tables is ODBC - that's it. There is no OLEDB for linked tables.

Wait for others to confirm/contradict.

(You may be able create the linked tables using code that uses an OLEDB connection but as far as I know the link will still require/operate as an ODBC link)
0
 
LVL 77

Expert Comment

by:peter57r
ID: 36522831
I think you need to establish what the issue is here that results in this request from your IT people.
0
 

Author Comment

by:snyperj
ID: 36522899
They have stated oledb connections are faster than odbc, and thus all data connections must be oledb.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 77

Expert Comment

by:peter57r
ID: 36523098
Well you can only implement what is technically possible.

I know that have expressed my previous response in manner than suggest doubt - but in reality I'm not that doubtful.  You just never know what some clever fellow might have come up with.
0
 
LVL 9

Accepted Solution

by:
Armen Stein - Microsoft Access MVP since 2006 earned 250 total points
ID: 36530141
In any case, ODBC is going to be supported instead of OLEDB:

http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/29/microsoft-aligning-with-odbc.aspx

Also, the main thing is that the Access app is optimized for SQL Server.  I've written a PowerPoint presentation about it.  It's called "Best of Both Worlds" at our free J Street Downloads Page:
http://www.JStreetTech.com/downloads

Cheers,
Armen
0
 

Author Closing Comment

by:snyperj
ID: 36532315
Thanks for the help and also for the interesting ppt.  I was happy to discover that I HAVE been using most of the optimizing techniques mentioned in one manner or another.,
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now