[AccessD] OLEDB Connection

Hewson, Jim JHewson at nciinc.com
Fri Feb 20 16:07:58 CST 2009


Neither, but I'll have one of them before the weekend is over.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, February 20, 2009 4:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OLEDB Connection

Jim,

Do you have "Microsoft Access Developer's Guide to SQL Server" or
"Access
2002 Enterprise Developer's Handbook"?

Both of these go into all the detail you need.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Friday, February 20, 2009 3: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.
################################################################################




More information about the AccessD mailing list