p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning Access 2003 VBA (http://p2p.wrox.com/forumdisplay.php?f=150)
-   -   Chapter 13 (http://p2p.wrox.com/showthread.php?t=58832)

bwoll June 7th, 2007 11:06 AM

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"

bwoll June 7th, 2007 03:57 PM

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"

All times are GMT -4. The time now is 09:59 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.