Hi, i´m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver.
Since there aren´t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(Connect())
Connection failed:
SQLState: '08001'
SQL Server Error: 17
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Specified SQL
server not found.
Has anyone been able to connect to a MSSQL server remotely using odbc under wine??
Please Help me
Shanku
MS-SQL Connection Problem
Re: MS-SQL Connection Problem
Use UnixODBC and freeTDS.shanku wrote:Hi, i´m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver.
-
Daniel Kasak
MS-SQL Connection Problem
On Tue, 2008-11-25 at 22:29 -0600, shanku wrote:
long time back ) I had MyODBC ( 3.51.11 ) and SQL Server drivers
working. For SQL Server, you have to use password authentication ( not
'trusted connection' ).
Your error sounds like the driver can't convert the server name into an
IP address. Are you able to resolve it? Have you tried with an IP
address instead ( or adding the server name to /etc/hosts )?
Dan
I've had *limited* success with wine and ODBC drivers. At one point ( aHi, im trying to access a MSSQL server (in a windows machine in the
network) from a Visual Basic Application running under wine, using an
ODBC driver. Since there arent any MSSQL drivers for linux i decided
to use de native ones, so i installed mdac_typ.exe . Then i configured
the DSN using odbcad32.exe but when i tested the connection
(configured using tcp/ip) an error message appeared
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(Connect())
Connection failed:
SQLState: '08001'
SQL Server Error: 17
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Specified SQL
server not found.
Has anyone been able to connect to a MSSQL server remotely using odbc under wine??
long time back ) I had MyODBC ( 3.51.11 ) and SQL Server drivers
working. For SQL Server, you have to use password authentication ( not
'trusted connection' ).
Your error sounds like the driver can't convert the server name into an
IP address. Are you able to resolve it? Have you tried with an IP
address instead ( or adding the server name to /etc/hosts )?
Dan
