>I just checked and yes I do have admin rights with the login I am using.
>
>Also I can't see any of the other databases, other than the ones I previously mentioned, like northwind, pubs and distribution. Not sure why I only get 4 databases come up? I'm quite new to SQL Server and so I get the feeling there are things I just don't realize occuring.

Can you access them with DSN-less connection?

lcDb = "pubs"
lcServer = "..."
lcConnStr = "DRIVER=SQL Server;" + ;
			"SERVER=" + lcServer + ";" + ;
			"Network=DBMSSOCN;" + ;
			"DATABASE=" + lcDb 

lnConn = SqlStringConnect(lcConnStr)
IF lnConn < 0
	* Use AERROR() here  to get ODBC errors
	RETURN .F.
ENDIF
lcSql = [SELECT * FROM Authors ]
lnRes = SQLEXEC(lnConn, lcSql, "crsTemp")
IF lnRes < 0
	* Use AERROR() here  to get ODBC errors
	RETURN .F.
ENDIF