msdatashape og provider

Hej
Du kan vel ikke ha mere end en "provider=" , lige nu har du 2 !

lige et link og en del af forklaringen - den bør cvel se ud som følger:
http://support.microsoft.com/?kbid=247003

The ATLShape.exe sample allows the user to read from either the Access 97 Test.mdb database or from a local SQL Server 7.0 Northwind database. The hierarchical output is written to an Example.out text file. This is achieved by setting up an appropriate connection string for each:

For the Access 97 Database:connection.OpenFromInitializationString(L"Provider=MSDataShape.1;Persist Security Info=False;
Data Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\\Test.mdb")

For the SQL Server 7.0 Database:connection.OpenFromInitializationString(L"Provider=MSDataShape.1;Persist Security Info=False;
Data Provider=SQLOLEDB;Database=Northwind;Server=MySQLServer7;uid=sa;pwd=")

håber det hjælper dig

takk florint...vel..jeg visste det egentlig...men det var du som gjorde at jeg så det;)

en ting til;)

SQL = "SHAPE {SELECT id, tid, tema, navn, dato FROM Forum WHERE Under = '"& kn &"' AND Original_thread = TRUE ORDER BY Dato} "
SQL = SQL & " APPEND ({SELECT tid, tema, navn, dato, under_id, id FROM Forum WHERE Original_thread <> TRUE ORDER BY Dato} AS Forum2"
SQL = SQL & " RELATE id TO under_id)"
'Response.Write SQL
'Response.End
Set forum= Server.CreateObject("ADODB.Recordset")
forum.Open SQL, Connect' MM_conn_STRING

if forum.eof = true then
Response.Write "Can't find any threads in this Category"
forum.close
set forum = nothing
else
do until forum.eof

Antall_Poster = Antall_Poster + 1

Spesial_id = forum("Id")
'Under = forum("under")
'Under_id = forum("Under_Id")
'Original_thread = forum("Original_thread")
'Antall_svar = forum("Antall_svar")
'Epost = forum("Epost")
'Tekst = forum("Tekst")
'Varsling = forum("Varsling")
Navn = forum("Navn")
Tema = forum("Tema")
Dato = forum("Dato")
Tid = forum("Tid")

%>

<a href="forum.asp?w=read&id=<%=Spesial_id%>&k=<%=k%>&kn=<%=kn%>"><font color="black" size="1"><b><%=tema%></b></a>(<%=Navn%> - <%=Dato%> / <%=tid%>)<br>

<%'239
if Forum2.eof = TRUE then
response.write "Esj"
else
do until forum2.eof
Navn2 = forum2("Navn")
Tema2 = forum2("Tema")
Dato2 = forum2("Dato")
Tid2 = forum2("Tid")
Under_id2 = forum2("under_id")
Id2 = forum2("id")
Space1 = Space1 + "&nbsp;&nbsp;"
%>
<%=Space1%><a href="forum.asp?w=read&id=<%=id2%>&k=<%=k%>&kn=<%=kn%>&answerid=<%=under_id2%>"><font color="black" size="1"><b><%=tema2%></b></a>(<%=Navn2%> - <%=Dato2%> / <%=tid2%>)<br>

<p>
<%
forum2.movenext
loop
end if'if forum2 er eof
forum.movenext
loop
Response.Write "<center>Total " & Antall_Poster & " threads</center>"
forum.close
set forum = nothing
end if


her får jeg denne feilen:


Microsoft VBScript runtime error '800a01a8'

Object required: ''


denne peker på linjen med "if forum2.eof = TRUE....."

hvorfor er denne feil??

JAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA!!!!!!!!!!

fant det ut!!!!!!!!!!!!!!

TAKK!!!

the end