Thread: Chapter 13
View Single Post
  #1 (permalink)  
Old June 7th, 2007, 11:06 AM
bwoll bwoll is offline
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"