Groups | Blog | Home
all groups > sql server connect > july 2003 >

sql server connect : Connect using OLEDB


Craig Hudson-Bennett
7/14/2003 10:17:10 AM
I would like to connect to SQL Server from Access using OLEDB. So,
setting up a ODBC data source. Does anyone have any code for that ?

Thanks, Craig

*** Sent via Developersdex http://www.developersdex.com ***
Craig Hudson-Bennett
7/15/2003 3:31:03 AM
Let me explain that better...How would I use that to create a linked
table in access that is linked to the remote SQL Server WITHOUT (my typo
earlier) setting up an ODBC data --- all the linking wizards prompt you
to use a an ODBC data source. I want to end up with a linked table (that
I can append data into) that I linked using OLEDB.

Thanks, Craig

*** Sent via Developersdex http://www.developersdex.com ***
<nntp>
7/15/2003 7:09:14 AM
use an access data project

[quoted text, click to view]

AddThis Social Bookmark Button