ConnectionStrings and Troubleshooting

I brushed up on the connectionstring, changed all the SQL to OleDB. I'm
not quite sure where the problems are from but i will find it out soon