Hewson, Jim
JHewson at nciinc.com
Fri Feb 20 15:23:05 CST 2009
Thanks, Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, February 20, 2009 3:17 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OLEDB Connection You're going to be using the ADODB library. Try searching on that. You'll use the connection string to create and open a connection object. Then you create a command object, which is where your SQL goes, and you work with the command object after you make the connection object its active connection. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim Sent: Friday, February 20, 2009 1:05 PM To: Access Developers discussion and problem solving Subject: [AccessD] OLEDB Connection How do you connect to SQL Server from Access using OLEDB? I've used ODBC using a DSN but I don't have any idea how to use OLEDB. I did some research on the issue, but all I found was the connection string but nothing that told me what to do with it. Where do I put it? Is it better than using a DSN? Are there any maintenance issues when deploying to multiple machines on a LAN? Many Thanks in advance. Jim ######################################################################## ######## If you have received this message in error, please contact the sender immediately and be aware that the use, copying, or dissemination of this information is prohibited. This email transmission contains information from NCI Information Systems, Inc. that may be considered privileged or confidential and is intended solely for the named recipient. ######################################################################## ######## -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ################################################################################ If you have received this message in error, please contact the sender immediately and be aware that the use, copying, or dissemination of this information is prohibited. This email transmission contains information from NCI Information Systems, Inc. that may be considered privileged or confidential and is intended solely for the named recipient. ################################################################################