Sharing SQL connection throughout application

Question

Hey all, I need to connect to my SQL server, and create some temporary tables. I need to be able to access these tables throughout the application, so where should I connect to the SQL server, and create these temp tables so that they are available throughout the application? I'm kind of a newbie here, so any examples would be awesome.