Hi, i have a set of .asp pages that uses owc to connect to Access databases.

Now, i have to change them to read from Sql Server, but i cant.

i do:

<OBJECT CLASSID="clsid:0002E552-0000-0000-C000-000000000046" id="Pivot"
VIEWASTEXT></OBJECT>
<SCRIPT Language = 'VBScript'>
Pivot.ConnectionString = "provider=msolap; Initial Catalog=TestDB; Data
Source = Server1; User ID=Web; Password=Web"
Pivot.DataMember= "qQuery1"

And i get a "Database 'TestDB' does not exist"

he's connecting ok to "Server1" (because if i change server name i get
another error)

I created a "web" user, and allow him public and readdata permissions on
that databases.

I set IIS to allow SqlServer to proccess anonymous connections...

What more can i do??

Thanks a lot

ok, it worked if instead of "Initial Catalog=" y used "database="

"Andrew Ofthesong" <Andrew (AT) NoSpam (DOT) net> escribió en el mensaje
news:%23W$EfpYeDHA.2212 (AT) TK2MSFTNGP12 (DOT) phx.gbl...