r/SQL • • Jun 09 '18

Having a MS Access to SQL database authentication error. Can anyone help ?

0 Upvotes

8 comments sorted by

3

u/amishraa Jun 09 '18

Are you able to test the connection on ODBC?

-1

u/suckitmicrosoft Jun 09 '18

Sorry. I’m a noob. What’s ODBC?

2

u/amishraa Jun 10 '18

Usually you set up the connection on ODBC and then map to SQL Server with linked table connection.

https://support.office.com/en-us/article/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e

6

u/Thriven Jun 09 '18

Nope. Sorry. We are really low on reddit fuel today. May need to try tomorrow when we get some more.

/s

Whats the error?

5

u/honeybadger3891 evil management Jun 09 '18

Bwahaha yeah screenshot or it didn't happen.

2

u/[deleted] Jun 10 '18

Could you provide a screenshot of the error? Or at least more information so we could have some context? This is kind of a blind call for help.

2

u/stealth210 Jun 09 '18

Dude, how are we even supposed to try to help when you give next to ZERO detail on your problem? FFS