Hi group, I need to access Navi data from a custom Visual Basic 6 application but I just can’t make it work. It returns any error from 3146 to 3669. I need to retrieve all 4200 records from a table through the ODBC driver, but the call is cancelled after some 90 seconds. I have tried to disable timeout in the ODBC driver, but it didn’t do nothing for me. Below I post a piece of the code I use to connect and retrieve the data. If anyone should have an idea of how to make it work, please feel free to respond a.s.a.p. 
My code: Best regards, Casper Helenius, DANBIT, Denmark
Wahuu… Just forgot to post the code… Here it is: Private Sub Form_Load() Dim wrkODBC As Workspace Dim conNAVI As Connection Dim rsSource As Recordset Dim rdDest As Recordset Set wrkODBC = CreateWorkspace(“MyWorkspace”, “admin”, “”, dbUseODBC) Set conNAVI = wrkODBC.OpenConnection(“NAVISQL”, dbDriverCompleteRequest, True, “ODBC;DATABASE=danbit;DSN=NAVISQL;UID=;PWD=;”) Dim SQLStr As String SQLStr = “SELECT * FROM Vare WHERE Nummer LIKE ‘a%’” Set rsSource = conNAVI.OpenRecordset(SQLStr, dbOpenForwardOnly) conNAVI.Close wrkODBC.Close End Sub Edited by - Novaree on 2/8/01 10:47:07 AM
Have you solve this problem? I am having same problem? Cann’t connect to Navision database using codbc
You might want to try a SELECT statement with specified fields. Leave the flowfields out. PS: On what OS are you using ODBC. ODBC to Navision 3.56 does not work on >= Windows 2000. At least I can’t get it up and running.
how can i use INSERT into statement in VB to wrirte data to navision
yes, but it can be dangerous since some triggers won’t be fired.