C/ODBC and ADO usage

Business Central/NAV Developers Forum
1

I writed an *.asp page with ADO components. Here I have a following problem:

  • When I use dsn with space in it’s name and call ADODB. Connection to specify it’s connection string, cncodbc.ConnectionString="DSN=Sample C/ODBC 32 bit",error “Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified” occurs
  • if I use connection.execute (with SELECT statement) or ADODB.Recordset.Open(with SELECT statement and AdCmdText property or with table name and AdCmdTable property),rscodbc.Open "SELECT * FROM 'Buffer plateb'",cncodbc,,,AdCmdTextfollowing error will occurs: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Navision a/s][Navision Attain ODBC Driver]Table does not exists
2

Hi. Tables with several words or tokens must have the spaces replaced by “_”. In your case, the sentece would be: SELECT * FROM Buffer_plateb … This rule also applies to fieldnames. Regards