wine users - Aug 2011 - Wine and MSSQL 2008: SSL Security Error

Hi everyone.

I'm trying to use a windows third part software, and it uses a MSSQL
database stored in a Windows 2008 Server. For this, I have Ubuntu 11, Wine 1.2
and WineTricks.

Following the instructions on "How to configure Wine", the chapter 3.6
tell me to install MDAC_TYP.EXE, and then run CLICONFG.EXE and ODBCAD32.EXE. I
did this.

I run ODBCAD32 to configure my System DNS, but I was unable to connect, with
ODBC returning an error about secur32 (don't remember). So, I go to
Winetricks and install secur32.

Again on ODBCAD32 to configure SystemDSN, but now the error is "SSL
Conection Error".

So, I go back to CLICONFIG.EXE, and tried some different settings, but I stuck
on this message. I can't connect.

Running ODBCAD32 from terminal (wine odbcad32), the only message returned is
"fixme:netbios:NetServerEnum Stub ((null) 100 0x32bad0 -1 0x32bac8 0x32bacc
4 (null) (nil))" when I select my server on the field "Wich SQL Server
you want to connect to?"

Another message I'm suspecting is when I select my server:
"fixme:ntdll:find_reg_tz_info Can't find matching timezone information
in the registry for bias 180". Maybe this error is affecting my SQL setup,
but I don't know well about this.

Any suggestion about this? Thanks in advice.

I copied a fresh new windows installation to wine virtual drive, and still
don't connecting...

Any suggestions?

Romulo Carlos wrote:
> Then, try to install FreeTDS and unixODBC, but I don't know why,
FreeTDS returns a lot of errors during install. The "tsql" command
don't work, a counter appears on the terminal counting until I stop with
CTRL+C.
Make sure you using the latest FreeTDS. And that you properly added your server
instance to /etc/freetds.conf.

Until you get tsql program working don't bother with anything else.

PS. Make sure your MSSQL server configured with TCP/IP access not just named
pipes. NPs won't work on anything but windows.