SqlShare.com Logo
 
Skip Navigation Links
Login / Register
Subscribe RSS Feed 

Confio Ignite

Image of Andy Warren
Author:

Author Bio:
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
Using OpenDataSource to Access Remote Data

Using OpenDataSource to Access Remote Data

OpenDataSource is an adhoc alternative to accessing remote data, whether it's another SQL Server or an Excel file. It makes a lot of sense to use it when you want to define the datasource at runtime.

Video Information
Publish Date:
October 02, 2009
Length:
3:37
Skill Level:
100
Rating:
4.27 out of 5

Watch Video Now!  Watch it later!  

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Thomas Kelley on 10/5/2009
Can you post your script file for these how to videos? It would make it a little easier to run thru the scenarios on our local computers. Thanks.

Jim Flannery on 10/5/2009
Simple, yet may prove very useful.

karim on 10/5/2009
Great advanced features.

Mike Dumais on 10/5/2009
Tried this when trying to access excel file:as in your demo Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLED.4.0" has not been registered.

rajani on 10/5/2009
some knowledge user access

Ahmad Elayyan on 10/5/2009
not clear, and need more clarifications.

6B2CA9FB1E on 10/5/2009
I would have liked to see more on setting up the connection string, without integrated security, and particularly with Oracle.

DANIEL SKEFF on 10/5/2009
Good video for one great resource! Thanks!

Stephanie Brown on 10/5/2009
For some reason, this felt rushed where other videos haven't. I can't quite put my finger on why that was. Also, not being a DBA, I'm guessing I'd need to talk to the people who support our server before changing configurations. I didn't understand why the XML fields caused problems either; did I miss something?

mbourgon on 10/5/2009
One other nasty caveat: 64-bit doesn't include the Excel driver.

Mike Salo on 10/5/2009
Did know any of this Thanks.

D151BB6B9F on 10/5/2009
The screen values blew by too fast to absorb what was being shown. Slow down.

Jon on 10/6/2009
It would be nice to be able to save the demo code for future reference. Great demo!

Christian Bahnsen on 10/7/2009
Interesting. Thanks for the tip regarding Excel.

Steve Culshaw on 10/9/2009
Interesting feature that I can see benefits to One point w.r.t. the video, suggest use the Full Screen option in SSMS so you can see the text, rather than leave half the window showing the Object browser

Tom Stafford on 10/9/2009
Very good video, if you would have closed the object explorer pane on the left you would have been able to see all of the SQL code as it was being talked about.

sunil on 10/14/2009
Very Good

F6F46BB996 on 10/15/2009
excellent video

WChaster on 12/22/2009
I even followed along substituting my file name/ location and felt the gratification at the same time. I am going to try using this with a select into statement.

John on 1/18/2010
I had no idea. Now I do!

Ranjith on 1/22/2010
Good

Muito Bom



Must Be Logged In

References
Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions