I am running on Vista, 32 bit, SQL Server 2008 Express R2 with SQL Server Native Client 10.0 (4/3/2010). When I try to create a System DSN, I can not set the default database to my SQL database as it doesn't exist in the drop down. I can also not type it in. If I let the default remain master and test the connection everything works fine. Do I have to specify the Default Instance somewhere (MSSQLSERVER)? What about SQLExpress?
Thanks in advance.