C/ODBC connection via asp page. please advise

DieN0w

Hi all

im tryng to make a simple asp page to connect to a navision database.
ive tried to search for info on te net on this but nothing
i would like to make a dns less connection but also have tried to make a DSN to te navision db and no luck
it gives a error saying that it cannot begin session.

not im not using the server its a local connection
here is the example of the code:

strConnectionString=
DRIVER={Microsoft Navision Driver};Server=No;Local=Yes; Database=D:\NAVISION\SAR\v4BD\sar4.fdb;IT=All;UID=hmt;PWD=1233;Company=SAR;


set dbCon= Server.CreateObject("ADODB.connection")
dbCon.open strConnectionString

its gives here the error. by this or vene if i just use the dsn=XPTO;uid=hmt;pwd=1234.

note i have seen a simple program on the web that manages to connect to my db using this dsn . its slow but works. via asp page it doesnt.

also anyone can recomend a faster way to acess the navision db.

thanks alll