Problem with creating ODBC tables in MSSQL database

Databases
1

I work with macOS 14.1.1, Windows 11 (latest version), XOJO 2023R3.1 .
Since MSSQLServerDatabase is deprecated, I use ODBCDatabase for database access to MSSQL Server.
On the Mac I have the ODBC driver for SQL Server and Sybase from ActualTech.

From macOS I can in Windows SQL Server

  • create the database
  • create the tables in the database
  • create the users
  • migrate the SQLite data to MSSQL

From Windows I can

  • create the database
  • create the users
    When creating the tables, I do not get an error message in Windows, but no table is created in the database there. I can’t figure out what the problem is.
    Is there anything special to consider for the “CREATE TABLE” via ODBCDatabase in Windows MSSQL-Server?
2

Only an idea: Did you install the ODBC driver from MS?

And if you do/did, do you get a connection to a database from Excel, for example?

3

I will try the driver. So far I have no problems connecting the database to my app. I can’t test it with Excel as I don’t use this Microsoft product.

4

Hi Thomas,
the ODBC drives provides not the solution. I’ve crated for this issue #75156