C/ODBC problem

Magno · 2004-12-16

Hi,

I just installed C/ODBC without any errors, but when i try to connect via ASP to the database server i get an isam error.

When i make a connection in the ODBC datasource administrator, i choose a company, it works, but when i try to change the company or try saving the connection then i get an error:

The operating system cannot load the dll module nc_tcp.dll.

Does anyone know what i can do? I am really getting desperate...

Hope anyone can help me.

Arhontis · 2004-12-18

Why don't you post your ASP code, I will try to replicate it...

eromein · 2004-12-19

Make sure the ODBC version is exaclty the same as your Navision version. Different versions will not work!

Magno · 2004-12-20

<%
Set conn = Server.CreateObject("ADODB.Connection")
dsn = "DRIVER={C/ODBC 32 bit};"
dsn = dsn & "UID=user;"
dsn = dsn & "PWD=pwd;"	
dsn = dsn & "sName=NAVSRV;"
dsn = dsn & "NType=tcp;"
dsn = dsn & "CN=Test Company;"
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"
session("DSN") = dsn
%>

With this i create my connectionstring
I am sure the company name is correct(with the upper and lowercases)
to be sure i added the server to the hosts file, but that shouldn't be necesary because we have a DNS server.

I get the error when i do

<!--#include file="createConn.asp"-->
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open(session("dsn"))

%>

the createconn file is where i make the dsn string

C/ODBC problem

Comments

Categories