Trying to set up new project to connect to database
under my SQL Server 2005 instance (named MACHINENAME\SQL2005);
Ask for ODBC connection, get list of available ODBC Drivers, then choose
SQL Server - have unchecked 'Trusted Connection' and supply valid user/password
credentials.
At this point I would expect to see a list of my user databases, but what I see
is a System_tables treeview (containing INFORMATION_SCHEMA related tables) followed by the following
tables (these are system tables under my master database) :
MSreplication_options
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
So ASPRunner.NET is obviously connecting to my SQL Server 2005 database, but appears to be connecting to the 'master' database by default - please advise how can I get it to connect to my 'user' databases ....