Solved

Need help with making an OLEDB connection to SQL Server`

Posted on 2011-09-12
6
279 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

743 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

10 Experts available now in Live!

Get 1:1 Help Now