[3.0/LINQ] access DB questions
Hi all
I have two questions
1) when i try to connect to a database using
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;"
as my access string i keep getting the error
The 'Microsoft.ace.oledb.12.0' provider is not registered on the local machine.
I have been googleing but havent found an answer yet does anyone know what this means.
2) have the sql query that i developed in excel
"SELECT Games.Pubdate, Games.LeagueID, Leagues.League, Games.Home, Games.Visitor, Games.Start, Games.End
FROM `C:\Documents and Settings\rbarbrow\Desktop\edops db\EdOps_be`.Games Games, `C:\Documents and Settings\rbarbrow\Desktop\edops db\EdOps_be`.Leagues Leagues
WHERE Games.LeagueID = Leagues.LeagueID AND ((Games.Pubdate Is Not Null) AND (Games.End Is Not Null))"
but im not sure how to develop it that the paths are no there . would it just be from Games , Leagues?
thanks
Re: [3.0/LINQ] access DB questions
DOh
I got number 1)
I mistakenly was useing the 2007 connection string
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; is the correct string
Re: [3.0/LINQ] access DB questions
The FROM clause simply contains the tables you want to get the data from. Excel requires a modified syntax because it's not a real database. Access is and therefore just requires regular SQL syntax. Access also has a Jet SQL reference, so you should have consulted that first.
Also, that is old join syntax. You should perform a join explicitly:
SQL Code:
SELECT ChildTable.ChildColumn, ParentTable.ParentColumn
FROM ChildTable
INNER JOIN ParentTable
ON ChildTable.ParentID = ParentTable.ParentID