Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Access 2003 VBA
This is the forum to discuss the Wrox book Beginning Access 2003 VBA by Denise M. Gosnell; ISBN: 9780764556593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access 2003 VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 7th, 2007, 12:06 PM
Registered User
 
Join Date: Jun 2007
Location: Chicago, IL, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 13

I modified the strConnetion parameters for the ModDatabaseLogic module as follows. I know the connection to the SQL Server database is functioning because when I created the tables on the adp side the databse and tables appeared in the sql server. The File->Connection parameters show "server4" as the server name and "Mycustomerservicesql" as the database name. I also have verified the "Data Source" path parameter. Any ideas why it fails?

strConnection = "Provider=server4;Data Source=n:\it\data Integration Project\Access2003VBA\Chapter 13" & _
                    "Integrated Security=SSPI;Initial Catalog=MyCustomerServiceSQL"


This is what is given in the book on page 460 and in the sample code
    strConnection = "Provider=sqloledb;Data Source=goz_tablet1100\sqldev;" & _
                "Integrated Security=SSPI;Initial Catalog=CustomerServiceSQL"
Reply With Quote
  #2 (permalink)  
Old June 7th, 2007, 04:57 PM
Registered User
 
Join Date: Jun 2007
Location: Chicago, IL, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This works: setting Provider to sqloledb and Data Source to point to the server:
    strConnection = "Provider=sqloledb;Data Source=server4;" & _
                "Integrated Security=SSPI;Initial Catalog=CustomerServiceSQL"



Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
chapter 13 - MVC omarosa BOOK: Professional PHP 5 ISBN: 978-0-7645-7282-1 10 March 25th, 2009 01:00 AM
Problems with Chapter 13 hooligan BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 November 11th, 2008 08:26 PM
problem in chapter 13 derrida BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 3 July 28th, 2006 03:31 AM
Chapter 13 ElMorenito BOOK: Beginning ASP 3.0 0 January 14th, 2005 02:56 PM



All times are GMT -4. The time now is 10:52 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.