Codbc ISAM Error

I'm trying to connect to a Navision DB through ADODB

I get the following error when connecting:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Navision a/s][Navision Attain ODBC Driver]ISAM error
/weblink/dataio.asp, line 5


at line 5: if conn.State = adStateClosed then conn.open(session("dsn"))


session("dsn"):
Set conn = Server.CreateObject("ADODB.Connection")
dsn = "DRIVER={C/ODBC 32 bit};"
dsn = dsn & "UID=user;"
dsn = dsn & "PWD=pwd;"
dsn = dsn & "sName=SrvrName;"
dsn = dsn & "NType=tcp;"
dsn = dsn & "CN=Company name;"
dsn = dsn & "CSF=Yes;"
dsn = dsn & "SERVER=N;"
dsn = dsn & "RD=No;"
dsn = dsn & "ML=2048;"
dsn = dsn & "CD=No;"
dsn = dsn & "BE=Yes;"
dsn = dsn & "CC=Yes;"
dsn = dsn & "RO=No;"
dsn = dsn & "QTYesNo=Yes;"
dsn = dsn & "IT=a-z,A-Z,0-9,_;"
dsn = dsn & "OPT=Text"


Anybody an idea how this could be solved?
LVL 4
Joachim CarreinSr. Software DeveloperAsked:
Who is Participating?
 
ee_ai_constructConnect With a Mentor Commented:
Question answered by asker or dialog valuable.
Closed, 110 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0
 
Joachim CarreinSr. Software DeveloperAuthor Commented:
I already found the solution myself, was really stupid actually:

My servername wasn't filled in in the hosts file...

Hope with this i can helpe someone else.
0
All Courses

From novice to tech pro — start learning today.