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