I had recently been peeking into a SQL database via Microsoft Access. I got quite used to browsing all the tables and fields, seeing their data types, and visually seeing their relationships. I’ve just began a project that connects to a proprietary(aged) database that uses ODBC to connect to it. Access would not allow me to view this the same (At least I couldn’t figure it out).
After a quick search I found a freeware application called passportODBC(You can download from other locations/ sites). It does require some information from you to register it. Some basic info like your name, and email and a phone number.
It’s not as fast as access and SQL server 2005, but I’m suspecting a lot of that has to do that it is ODBC. It’s really quite simple to use. Choose your data source, enter some credentials and go. You can view tables, all the fields, and the field attributes.
Technorati Tags: ODBC, programming, database
Update 2/28/07 1:20PM
Embassy Software offers the download direct from their site.
Update 5/16/07
I found a more simple tool for viewing via ODBC. You can compose queries and the likes. It’s much more simple to use (for me anyways) ODBC View can be downloaded from sliksoftware.co.nz
