Shape error with ASP ??

Shape error with ASP ??

Post by Davi » Fri, 19 Jan 2001 04:22:59



I get the following error for the following code...any ideas?? (Thank you in
advance)
Microsoft OLE DB Provider for SQL Server error '80040e14'

Syntax error or access violation

/test/phonelist/matrix.asp, line 38

 Dim strConn
 strConn = "Provider=SQLOLEDB;User ID=dummy;Password=;Initial
Catalog=Emp;Data Source=CS"

 Set oConn = server.CreateObject("ADODB.Connection")

 oConn.Provider = "MSDataShape" 'define data shape provider
 oConn.Open strConn

 Dim sSQL1
 sSQL1 = sSQL1 & "  SHAPE {SELECT * FROM tbl_MatrixLevel1}  AS levelone
APPEND "
 sSQL1 = sSQL1 & "  ({SELECT * FROM tbl_MatrixLevel2}  AS leveltwo RELATE id
TO L1_ID) AS leveltwo1"

 Dim Rs
 Set Rs = Server.CreateObject("ADODB.Recordset")
 Rs.ActiveConnection = oConn
 Rs.Open sSQL1