LMAO fixed it myself. When i created the odbc connection i forgot to select the invite database lol. So it was connecting to the SQL server just fine, but no database was chosen HA i'm a moron.
I'm sure i'll have a few more questions before this is over. I really do appreciate your guys input!!!
Void4ever