You should be able to visit any state university library and access the databases while you are in the physical library. Access will be free, but you will have to pay for printing. Even if you are able to pay for borrowing privileges from a local private university, you will not be permitted to access any of the library's databases remotely-that privilege is reserved for current students and faculty of the university. Database license agreements do not permit access to these databases for those that are not faculty or students. Alums of a university are not included in the licensing model. Most large universities now have institutional repositories-online databases where faculty publications are maintained. If you are in the physical library, you will be able to access this.
You said that you were looking for science articles, but did not give the specific discipline. If you are researching the medical or related fields, you can access the databases from the National Library of Medicine (
www.nlm.gov) which not only had responsibility for PubMed and MedLine, but has some databases on chemistry, toxicology, etc.
Get in touch with your state library (not the local public library)-every state has one, located in the capital of your state. They may be able to provide with with specifics on what you are seeking. They probably will not have access to vendors like Science Direct, but they may be able to direct you (or obtain a copy of the article via interlibrary loan) at no or minimal cost.
Some professional associations will have conference proceedings and articles available through their websites. Many of these associations make all their content available to their members, but it is worth a try to check.
Yes, there are some things on Google Scholar-however, more it not on on Google Scholar than what is on Google Scholar.
Hope this helps!