SQLSERVER ODBC

[kurtsalvador]

Hi,

I've been trying to connect to an SQLSERVER database using the Microsoft ODBC Driver 17.
Also, I've download the ODBC Manager

odbc.ini file looks like this:

[mySQLServer]
Driver = Microsoft ODBC Driver 17 for SQL Server
Description = BasisSQL
Trace = No
Server = <address of server> * actual address is placed here

obdcinst.ini file looks like this:

[ODBC Driver 17 for SQL Server]
Description = Microsoft ODBC Driver 17 for SQL Server
Driver = /usr/local/lib/libmsodbcsql.17.dylib
UsageCount = 1

From Terminal I can connect to the database via sqlcmd
However when using it in OpenOffice Database, the application hangs upon entering the password. Have to force quit.

Are there any other options that need to be placed in ODBC Manager when creating the DSN ?

Can someone please help. Thanks!

[kurtsalvador]

This is the logfile:

Code: Select all

** iODBC Trace file
** Trace started on Wed Aug 29 17:11:58 2018
** Driver Manager: 03.52.0607.1008


[000000.000151]
soffice         7FFF8D0AB380 ENTER SQLAllocHandle
		SQLSMALLINT       1 (SQL_HANDLE_ENV)
		SQLHANDLE         0x0 (SQL_NULL_HANDLE)
		SQLHANDLE       * 0x7ffee5413248

[000000.000182]
soffice         7FFF8D0AB380 EXIT  SQLAllocHandle with return code 0 (SQL_SUCCESS)
		SQLSMALLINT       1 (SQL_HANDLE_ENV)
		SQLHANDLE         0x0 (SQL_NULL_HANDLE)
		SQLHANDLE       * 0x7ffee5413248 (0x604001485be0)

[000000.000213]
soffice         7FFF8D0AB380 ENTER SQLSetEnvAttr
		SQLHENV           0x604001485be0
		SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
		SQLPOINTER        0x3
		SQLINTEGER      * 4294967291 (SQL_IS_UINTEGER)

[000000.000248]
soffice         7FFF8D0AB380 EXIT  SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
		SQLHENV           0x604001485be0
		SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
		SQLPOINTER        0x3
		SQLINTEGER      * 4294967291 (SQL_IS_UINTEGER)

[000000.000332]
soffice         7FFF8D0AB380 ENTER SQLAllocHandle
		SQLSMALLINT       2 (SQL_HANDLE_DBC)
		SQLHANDLE         0x604001485be0
		SQLHANDLE       * 0x7fde2ccc2968

[000000.000364]
soffice         7FFF8D0AB380 EXIT  SQLAllocHandle with return code 0 (SQL_SUCCESS)
		SQLSMALLINT       2 (SQL_HANDLE_DBC)
		SQLHANDLE         0x604001485be0
		SQLHANDLE       * 0x7fde2ccc2968 (0x6040003f6b00)

[000000.000418]
soffice         7FFF8D0AB380 ENTER SQLDriverConnect
		SQLHDBC           0x6040003f6b00
		SQLPOINTER        0x0
		SQLCHAR         * 0x7ffee5411960
				  | DSN=Basis;UID=BasisMacUser;PWD=********* |
				  | ;                                        |
		SQLSMALLINT       41
		SQLCHAR         * 0x7ffee5412160
		SQLSMALLINT       4096
		SQLSMALLINT     * 0x7ffee541195e
		SQLUSMALLINT      0 (SQL_DRIVER_NOPROMPT)

[000000.034982]
soffice         7FFF8D0AB380 EXIT  SQLDriverConnect with return code -1 (SQL_ERROR)
		SQLHDBC           0x6040003f6b00
		SQLPOINTER        0x0
		SQLCHAR         * 0x7ffee5411960
		SQLSMALLINT       41
		SQLCHAR         * 0x7ffee5412160
		SQLSMALLINT       4096
		SQLSMALLINT     * 0x7ffee541195e
		SQLUSMALLINT      0 (SQL_DRIVER_NOPROMPT)

[000000.035121]
soffice         7FFF8D0AB380 ENTER SQLGetDiagRec
		SQLSMALLINT       2 (SQL_HANDLE_DBC)
		SQLHDBC           0x6040003f6b00
		SQLSMALLINT       1
		SQLCHAR         * 0x7ffee5412f5b
		SQLINTEGER      * 0x7ffee5412f54
		SQLCHAR         * 0x7ffee5412f60
		SQLSMALLINT       511
		SQLSMALLINT     * 0x7ffee5412f52