Fun Error

gerfield

I'm using the c/odbc link in Navision 3.7
and I'm getting this error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Expected lexical element not found: <identifier>

/accounts.asp, line 13

Here is the code I'm using

<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("recordID") <> "") Then 
  Recordset1__MMColParam = Request.QueryString("recordID")
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_nav_STRING
Recordset1_cmd.CommandText = "SELECT No_, Name, Search_Name, Name_2, Address, Address_2, City, Contact, Phone_No_, Our_Account_No_ FROM null.Customer WHERE No_ = ?" 
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 255, Recordset1__MMColParam) ' adVarChar

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>

All I'm trying to do is when someone clicks a link on our site they get their user information from Navision. Very simple. Don't get why its not working. Any help would be amazing.

ara3n

are you on sql or Native?

Old ODBC drivers are not stable. If you are on sql use the sql native drivers.

gerfield

Thanks for answering. I'm on the Native database. Is there any hope?

thanks for your help

ara3n

I suggest to look at cfront.

gerfield

cfront is good for a web based asp script?

gerfield

ASP with a native database is not a fit. thanks for everyone's help