[Wine] WINE & FREETDS

[gapete]

WINE & Freetds & MSSQL
hi to all,

im really stuck.

I cant do an app to work with ODBC.

UBUNTU 11.10

I installed freeTDS an unixODBC, tsql and isql both connect and i can do a select........

so i exec an app in wine but i cant connect to mssql.

this errors with WINEDEBUG=odbc wine cmd

then exec my app



> trace: odbc:llMain Initializing or Finalizing proxy ODBC: 0x3d700000,1,(nil)
> trace: odbc allMain Loading ODBC...
> trace: odbc:ODBC_LoadDriverManager
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLAllocHandleStd: /usr/lib/libtdsodbc.so: undefined symbol: SQLAllocHandleStd
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLBrowseConnect: /usr/lib/libtdsodbc.so: undefined symbol: SQLBrowseConnect
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLBrowseConnectW: /usr/lib/libtdsodbc.so: undefined symbol: SQLBrowseConnectW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLBulkOperations: /usr/lib/libtdsodbc.so: undefined symbol: SQLBulkOperations
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLColAttributeW: /usr/lib/libtdsodbc.so: undefined symbol: SQLColAttributeW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLColAttributesW: /usr/lib/libtdsodbc.so: undefined symbol: SQLColAttributesW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLColumnPrivilegesW: /usr/lib/libtdsodbc.so: undefined symbol: SQLColumnPrivilegesW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLColumnsW: /usr/lib/libtdsodbc.so: undefined symbol: SQLColumnsW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLConnectW: /usr/lib/libtdsodbc.so: undefined symbol: SQLConnectW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDataSources: /usr/lib/libtdsodbc.so: undefined symbol: SQLDataSources
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDataSourcesW: /usr/lib/libtdsodbc.so: undefined symbol: SQLDataSourcesW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDescribeColW: /usr/lib/libtdsodbc.so: undefined symbol: SQLDescribeColW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDescribeParam: /usr/lib/libtdsodbc.so: undefined symbol: SQLDescribeParam
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDriverConnectW: /usr/lib/libtdsodbc.so: undefined symbol: SQLDriverConnectW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDrivers: /usr/lib/libtdsodbc.so: undefined symbol: SQLDrivers
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLDriversW: /usr/lib/libtdsodbc.so: undefined symbol: SQLDriversW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLErrorW: /usr/lib/libtdsodbc.so: undefined symbol: SQLErrorW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLExecDirectW: /usr/lib/libtdsodbc.so: undefined symbol: SQLExecDirectW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLForeignKeysW: /usr/lib/libtdsodbc.so: undefined symbol: SQLForeignKeysW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetConnectAttrW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetConnectAttrW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetConnectOptionW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetConnectOptionW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetCursorNameW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetCursorNameW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetDescFieldW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetDescFieldW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetDescRecW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetDescRecW
> vODBC_LoadDMFunctions Failed to load SQLGetDiagFieldW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetDiagFieldW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetDiagRecW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetDiagRecW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetInfoW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetInfoW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetStmtAttrW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetStmtAttrW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLGetTypeInfoW: /usr/lib/libtdsodbc.so: undefined symbol: SQLGetTypeInfoW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLNativeSqlW: /usr/lib/libtdsodbc.so: undefined symbol: SQLNativeSqlW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLPrepareW: /usr/lib/libtdsodbc.so: undefined symbol: SQLPrepareW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLPrimaryKeysW: /usr/lib/libtdsodbc.so: undefined symbol: SQLPrimaryKeysW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLProcedureColumnsW: /usr/lib/libtdsodbc.so: undefined symbol: SQLProcedureColumnsW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLProceduresW: /usr/lib/libtdsodbc.so: undefined symbol: SQLProceduresW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSetConnectAttrW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSetConnectAttrW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSetConnectOptionW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSetConnectOptionW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSetCursorNameW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSetCursorNameW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSetDescFieldW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSetDescFieldW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSetStmtAttrW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSetStmtAttrW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLSpecialColumnsW: /usr/lib/libtdsodbc.so: undefined symbol: SQLSpecialColumnsW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLStatisticsW: /usr/lib/libtdsodbc.so: undefined symbol: SQLStatisticsW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLTablePrivilegesW: /usr/lib/libtdsodbc.so: undefined symbol: SQLTablePrivilegesW
> warn: odbc:ODBC_LoadDMFunctions Failed to load SQLTablesW: /usr/lib/libtdsodbc.so: undefined symbol: SQLTablesW
> trace: odbc:SQLAllocEnv
> trace: odbc:SQLAllocEnv Returns ret=0, Env=7c804938
> trace: odbc:ODBC_ReplicateODBCInstToRegistry Driver settings are not currently replicated to the registry
> trace: odbc:SQLDrivers
> trace: odbc:ODBC_ReplicateODBCInstToRegistry Error -1 enumerating drivers
> warn: odbc:ODBC_ReplicateODBCInstToRegistry May not have replicated all ODBC drivers to the registry
> trace: odbc:SQLDataSources EnvironmentHandle = 0x7c804938
> trace: odbc:ODBC_ReplicateODBCToRegistry Error -1 enumerating system datasources
> warn: odbc:ODBC_ReplicateODBCToRegistry May not have replicated all system ODBC DSNs to the registry
> trace: odbc:SQLDataSources EnvironmentHandle = 0x7c804938
> trace: odbcODBC_ReplicateODBCToRegistry Error -1 enumerating user datasources
> warn: odbc:ODBC_ReplicateODBCToRegistry May not have replicated all user ODBC DSNs to the registry



my freetds.conf. odbc.ini, odbcinst.ini

freetds.conf


> [global]
> # TDS protocol version
> tds version = 7.1
> text size = 64512
> [TDS]
> host = 192.168.0.5
> port = 1433
> tds version = 7.1


odbc.ini


> [prueba]
> Driver = MSSQLServer
> Servername = TDS
> Database = nueva2
> UID = unbian
> PWD = unbian



/etc/odbcinst.ini


> 
> [MSSQLServer]
> Driver =/usr/lib/libtdsodbc.so
> Setup =/usr/lib/libtdsS.so
> 

i dont know what more i can do to solve the problem.

thx in advance.