May 30, 2006 at 8:17 am
Does the northwind db come preconfigured by default? I can't get mine to work. Is there a link or resource I can follow to set this up? I'm trying to pull data back from code using an appropriate connection string
"Provider=sqloledb;DataSource=(local);Initial Catalog=Xtreme sample database 2005;user id=sa;password=;"
but I get errors: Data provider could not be initialized. I've gone in to ODBC datasources in control panel and configured a northwind system dsn to point to the sample mdb file on my drive. This is XP Pro so I can't test the connection.
May 31, 2006 at 2:58 pm
Access comes with a sample file called NorthwindCS.adp. To use open the file then click on file, connection and then point to the location of the Northwind database on your SQL Server.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply