• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

Need help with making an OLEDB connection to SQL Server`

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
snyperj
Asked:
snyperj
  • 3
  • 2
2 Solutions
 
peter57rCommented:
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
 
peter57rCommented:
I think you need to establish what the issue is here that results in this request from your IT people.
0
 
snyperjAuthor Commented:
They have stated oledb connections are faster than odbc, and thus all data connections must be oledb.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
peter57rCommented:
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
 
Armen Stein - Microsoft Access MVP since 2006PresidentCommented:
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
 
snyperjAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now