How to make an Excel data connection without a DSN?

Question

We have a tool from a vendor that comes with instructions for us geeks to build a DSN for it to work.

Unfortunately (1) it isn't a geek that would use it; (2) we don't want to keep having to "fix it" every time they get on a different computer; and (3) we don't want all the DSNs left on the previous computers, since they contain DB passwords in plain text.

I have often in the past used a connection string without a DSN to do this sort of thing. But THIS time, Excel complains that it can't find a DSN in the connection string.

ConnectionStrings might help. It's difficult to say why your current effort isn't working when you don't show us your current effort at all. — Ken White
– Ken White, Commented Jul 3, 2013 at 20:16

WGroleau · Accepted Answer · 2013-07-16 13:48:17Z

1

The biggest difference between all the conection strings that didn't work is that they tried to use OLE. ODBC worked.

answered Jul 16, 2013 at 13:48

WGroleau

4551 gold badge9 silver badges29 bronze badges

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

Comments

Papa Burgundy · Accepted Answer · 2013-07-03 20:46:05Z

0

Can you use an OleDB connection with either the Jet or Ace provider? See here:

Excel Connection Strings (OleDb)

answered Jul 3, 2013 at 20:46

Papa Burgundy

6,4876 gold badges44 silver badges48 bronze badges

1 Comment

WGroleau Over a year ago

Turns out that OLE was the problem. It worked when I changed to ODBC.

Collectives™ on Stack Overflow

How to make an Excel data connection without a DSN?

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related