[Cicode] Connection string in SQLCreate(sConnect) for OBDC

The function SQLCreate(sConnect) need to string sConnect

What is a format thhe string?

I want to use ODBC connection to SQLite database.

What I need to write in sConnect ?

  • sConnect= "DSN=ALM_LOG_OSTROVEC"

    You can also find the format of other connection strings from

    Note also that your DSN must be defined in the 32bit version of ODBCad32, not the 64bit version.  32bit version is stored under c:\windows\syswow64\ODBCad32.exe

  • Unknown said:

    sConnect= "DSN=ALM_LOG_OSTROVEC"

    You can also find the format of other connection strings from

    https://www.connectionstrings.com/

    www.connectionstrings.com

    Note also that your DSN must be defined in the 32bit version of ODBCad32, not the 64bit version.  32bit version is stored under c:\windows\syswow64\ODBCad32.exe

    I see Citect help :

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------

    ODBC provider

    "Driver={SQL Server};Server=(local);Trusted_Connection=Yes; Database=MyDatabase;"
    "Driver={Microsoft ODBC for Oracle};Server=ORACLE8i7;Persist Security Info=False;Trusted_Connection=Yes"
    "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\doc\MyDatabase.mdb"
    "Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\doc\MySheet.xls"
    "SCADA Data Provider=Odbc;Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:\doc"
    "DSN=MyDSNname"
    -----------------------------------------------------------------------------------------------------------------------------------------------------------------

    and can't understand what is my case ...... not SQL server ..... not ODBC for Oracle .... no Access ... not Excel