[thelist] SQL Server default db with ancient ASP

Max Schwanekamp lists at neptunewebworks.com
Thu Dec 28 17:09:58 CST 2006

Peter Brunone (EasyListBox.com) wrote:
>    Just grasping at straws here, but what if you (a) remove the spaces after the semicolons, and (b) change "Data Source" to " 
> 		ServerName"?

Thanks, but no dice.  Changing the Data Source bit to ServerName results 
in an "Invalid connection string attribute" error.  But the connection 
is made, and queries *can* run, it's just that the default database 
("Initial Catalog") attribute of the connection seems to get ignored.  I 
even tried doing it after the connection is opened:
strConn = "Provider=sqloledb;Data Source=sql.example.com,1433;User 
Id=dbuser;Password=dbpass;Initial Catalog=mydatabase;"
conn.DefaultDatabase = 'mydatabase'

'' error "Invalid Object mytable":
Set rs = conn.Execute("SELECT * FROM mytable")

'' works OK:
Set rb = conn.Execute("SELECT * FROM mydatabase.mytable")

Since my post, I also tried explictly creating then opening the recordset:

Set rs = CreateObject("ADODB.RecordSet")
'' also gives error "Invalid Object mytable"
rs.Open "SELECT * FROM mytable", conn, adOpenStatic, adLockReadOnly

I'm guessing this is a security setting I've not encountered before. 
For now I'm just putting in the database name in the queries for each 
script on an as-needed basis (ugh), but any suggestions/hints/guesses 
would be appreciated.

Max Schwanekamp

More information about the thelist mailing list