SQL Server Native Client

[bluegroper]

Hi forum

Newbie here, so please be gentle.

I have a windows application that needs to connect to a remote SQL Server using "Microsoft SQL Server Native Client".
I've tried installing using :

Code: Select all

msiexec /i sqlncli.msi 

But when I launch the application, it seems the "SQL Native Client" is NOT available.
Do I need to run a wine service, or tweak the wine registry to include a .dll to get this moving ?

TIA's for any tips or clues.

[penzoiders]

I managed to get my application working with a few minor issues:
- can't use SSL connection to MSSQL, nor from client, nor forced from server
- can't use the istance and db discovery in my login form: I have to specify all the connection parameters [IP,PORT] (not istance name) [user] [pass] and [database]

I created a clean prefix and installed this with winetricks (forcing 32 bit 'cause I use 64 on system):

Code: Select all

ARCH=win32 WINEPREFIX=~/.myappwineprefix winetricks mdac28 native_mdac

Code: Select all

ARCH=win32 WINEPREFIX=~/.myappwineprefix wine MyApp.exe 

if I try installing nativeclient or secur32 and crypt32 my app will stop working and will not connect again to the dbms: have to remove the prefix and reinstall only mdac28 and native_mdac

(i'm using wine-1.7.14 from ppa:ubuntu-wine/ppa)