Connecting NAVISON db to asp

atchu

Hello,
i am trying to connect NAVISION db to my asp page. i dont know how to do.. can anyone help me ??
thx
atchu

Luc_VanDyck

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.