Connecting to SQL Server

[Andrew Ofthesong]

Hi.. perhaps here should i ask:

I have a set of .asp pages that uses owc(10) 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

 

[Dan Ricker]

User:
provider=SQLOLEDB
Instead of:
provider=msolap

MSOLAP is the OLEDB provider for Analysis Server which
does ship with SQL but is not SQL.

SQLOLEDB is the OLEDB provider for SQL.

 

[Dip]

Have you downloaded the Office XP web Component Toolpack so far? They
have all the tutorials, ready to use code on how to connect SQL Server,
Analysis Server etc.



http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-
4586-A13C-50E56F101720&displaylang=en



Dip

 

[Andrew Ofthesong]

Good toolpack!

actually, -don't ask me why-, it worked if instead of using "Initial
Catalog" I used "Database" on the connection string....