question

michael.smith avatar image
0 Likes"
michael.smith asked Ben Wilson answered

SQL Server Connection over ODBC

I'm having an issue with connecting to an MS SQL Server DB via ODBC, the model currently happily works with 2 different MySQL servers connected via ODBC but the MS SQL Server gives this error

FlexSim 16.1.0
database ms sql server
capture.png (6.4 KiB)
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

With authentication issues you can try different settings for the DSN , plus you could try using the non-native client driver. Are you passing login credentials, or are you using Windows Authentication, and if so have you configured the users rights to access SQL Server?

0 Likes 0 ·

1 Answer

Ben Wilson avatar image
2 Likes"
Ben Wilson answered

Googling the ODBC error code 28000 suggests that this is a login issue (as indicated by the error message itself). That search leads to many articles that you could search for further hints as to what is happening and how to fix it.

Without having a MS SQL Server installation to test with, my best guess is that there are settings when you create a data source that need to be set to appropriately connect to your server, and the server itself will need to have credentials set that the data source can use.

------

There are also some other items to be aware of when configuring a FlexSim <> ODBC <> DB setup. This may not be affecting you, but I'll mention it in case others searching the community need it.

  • Make sure that your ODBC driver architecture (32- or 64-bit) matches your FlexSim installation.
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.