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

Anton over 5 years ago

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 ?

Parents

Anton over 5 years ago

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

Reply

Anton over 5 years ago

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

Children

No Data