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
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
You can link with a file DSN stored on the server or use DSN-less connections, like:
http://www.accessmvp.com/djsteele/DSNLessLinks.html
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
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.
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