please help!!odbc of access2000 with centura

[nedjma]

I have version 10.1.0 of centura builder, and i want to have link with access database using ODBC, but i have SQL errors (with open database, i have ODBC driver not supported this function), and running my program, in sql select statement, an error of odbc.
I use access 2000 with windows98 and access odbc version is 4.00.371108
thanks in advance

 

[TrojanRabbit]

Check your system ODBC settings and make sure that your centura driver shows up properly in User DSN. With it there, you can link to it from Access using the DSN name. If you're trying to link a table, it will take you to the DSN list. When connecting via SQL, as in a pass-through query, specify &quot;ODBC;DSN=<DSNname>;DB=<database>;SRVR=<server>;UID=<userID>;PWD=<password>&quot; in the properties.
Hope this answers your question.