I am very confused of all the database connection types, or how to set them up, and which is good for what. As I understand, there is ODBC, OLE, ADO, and ADO.net I think thats all of them right? I also installed SQL Server 2008(express) and I am confused on how to configure it.
ADO, ADO.NET, OLEDB are providers that allow you to access a data source. What specifically are you trying to do? Can you provide more information?
well first I was trying to test drive phpbb on my computer running iis7-.net35sp1 but I only got as far as the database configuration, It only detects ms sql via ODBC. Im not even sure what it is so I left it there. But there was another way phpbb can be installed, one of the undetected listed was ms sql server 2000+ so im confused
Well, it appears phpBB supports several database engines: A SQL database system, one of: FireBird 2.0 or above MySQL 3.23 or above MS SQL Server 2000 or above (directly or via ODBC) Oracle PostgreSQL 7.x or above SQLite 2 I am not familiar with phpBB, but can try to help out. Quick install @ http://tinyurl.com/lkxt3y