Macro or code to spread DSN into every computer

[jaryszek]

Hi Guys,

i am wondering how it is the best way to provide each computer within DSN and do it programatically.

Do you have maybe code or example how to do it?
I was thinking about VBA code to do it but i do not know...

Best,


Jacek

[pbaldy]

You can link with a file DSN stored on the server or use DSN-less connections, like:

http://www.accessmvp.com/djsteele/DSNLessLinks.html

[jaryszek]

Hi pbaldy.

thank you!

Regarding to this topic:

https://www.excelforum.com/excel-pro...ml#post4869827

It is better to use DSN connections.
I can use DSN less connections for postgresql but it depends on bits (32 or 64 bit).

How to use DSN stored on the server?
I have to create system dsn on server yes?

Best,
Jacek

[pbaldy]

I have no experience with postgresql. For SQL Server I used to create a file (not system) DSN on the server and use it when linking tables on my development computer. I didn't have to do anything on user computers.

[jaryszek]

Thank you pbaldy.

Understand.

But here i will be reading into Excel so i have to create DSN or i think better maybe hardcoded driver in VBA.

Hmm i do not know it yet...

Best,
Jacek