Access Query DSN-less connection string error

Question

I have a query that when created, used an ODBC to connect to an SQL Database.
I now need to change that because the Access file will be shared and used across our company, and I don't want to have to put ODBCs on all those computers separately if I can help it.

So, some quick google searching later I went into the query and found the property 'ODBC Connect Str' and updated it to (hopefully) connect independent of the ODBC.

The old connection string (which worked fine) was:

ODBC; DSN=Orderwise 2;Description=Orderwise Connection;UID=myusername;PWD=mypassword;DATABASE=LIVEDATA

The new connection string is currently:

ODBC;Driver={SQL Server};Server=Dc01/Orderwise;Database=LIVEDATA;Uid=myusername;Pwd=mypassword;

but whenever I try to save or run the query, it gives me the error that

ODBC -- connection to `{SQL Server}Dc01/Orderwise' failed.

I've tried it without the ODBC; section on the new string and it didn't work either. Subsequent google searches on the error aren't getting me any further.

Can anyone tell me what's going wrong please?

Assuming Orderwise is an instance name, use a backslash instead of forward slash to separate the server and instance name components: Server=Dc01/Orderwise to Server=Dc01\Orderwise. — Dan Guzman
– Dan Guzman, Commented Sep 17, 2020 at 10:19
@DanGuzman it works, Thank you so much!! would you like to convert that to an answer rather than a comment so I can accept it properly? — Spencer Barnes
– Spencer Barnes, Commented Sep 17, 2020 at 10:26

Jeremy Caney · Accepted Answer · 2022-05-17 18:37:12Z

1

This makes no sense, but it works for me.

Driver={SQL Server};ODBC;Driver={SQL Server};Server=Dc01/Orderwise;Database=LIVEDATA;Uid=myusername;Pwd=mypassword;

edited May 17, 2022 at 18:37

Jeremy Caney

7,808115 gold badges58 silver badges86 bronze badges

answered May 10, 2022 at 19:12

Stan Adelman

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Access Query DSN-less connection string error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related