Newbie How-to: Import database from MS SQL Server to virtual tables

[josipradnik]

If it is a must to stay with MSSQL Server (maybe to share data with other apps running), then virtual tables are solutions.
As I understand, virtual tables are Lianja Servers stuff. And Lianja app can communicate only to Lianja database.
Virtual table is sort of cursor adapter to other data sources (Oracle,MSSQL,MySQL...) via ODBC.
I am concern about performance because ODBC is older technology then OLEDB providers.

Anyway, if have to, it can be done by a beginner:

Step #1 (prerequisite: Make ODBC for MSSQL Server)
780

Step #2 (Import database from MSSQL)
781

Step #3 (optional: checking MSSQL is realy used in VT)
782

While I am learning Lianja, I hope this "picture book" will help other newbies to make first steps in Lianja.
ODBC data source administrator for Win XP is odbcad32.exe, for Win7/8 has different name.

Josip Radnik

[barrymavin]

Hi Josip,

oledb is deprecated and ODBC is recommended by Microsoft now.

Apart from that oledb is windows specific whereby ODBC is cross platform.

[alanbourke]

.

[HankFay]

While I am learning Lianja, I hope this "picture book" will help other newbies to make first steps in Lianja.
ODBC data source administrator for Win XP is odbcad32.exe, for Win7/8 has different name.

Actually, Jospip, the name is the same right through 8.1 (and presumably 10 when it comes out in January).

The difference is where it is found on x64 systems (which is also true for older Windows versions also). Because Lianja on Windows is 32-bit, the version in %windir%\syswow64 must be used, rather than the one in system32. Both exe's are named the same (part of Microsoft's attempt to provide job security for IT professionals through obfuscation of simple operations), but only the one in syswow64 in x64 systems (there is no syswow64 directory on win32 systems) will create a 32-bit DSN.

hth,

Hank