Try this code:
</font><blockquote><font size="1" face="Verdana, Arial">code:</font><hr /><pre style="font-size:x-small; font-family: fixed;"><%
myDSN="DSN=Navision;uid="";pwd="""
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
mySQL="select * from Customer"
set rstemp=conntemp.execute(mySQL)
If rstemp.eof then
response.write "No data<br>"
else
do until rstemp.eof
response.write rstemp("Name") & "<br>"
rstemp.movenext
loop
end if
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%></pre><hr /></blockquote><font size="2" face="Verdana, Arial">This uses a ODBC-Datasource called Navision.
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
Comments
</font><blockquote><font size="1" face="Verdana, Arial">code:</font><hr /><pre style="font-size:x-small; font-family: fixed;"><%
myDSN="DSN=Navision;uid="";pwd="""
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
mySQL="select * from Customer"
set rstemp=conntemp.execute(mySQL)
If rstemp.eof then
response.write "No data<br>"
else
do until rstemp.eof
response.write rstemp("Name") & "<br>"
rstemp.movenext
loop
end if
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%></pre><hr /></blockquote><font size="2" face="Verdana, Arial">This uses a ODBC-Datasource called Navision.