PowerShell script to enable TCP/IP protocol in ODBC

Question

I am working on a PowerShell script to add User DSN in ODBC. At this stage, I am able to add the Name, Platform, DSN type etc. But, I am stuck at enabling TCP/IP protocol under the Network tab and passing values to it.

My current script is,

Add-OdbcDsn -Name SQL -Platform "32-bit" -DriverName "Microsoft Access Driver (*.mdb)" -DsnType "User" -SetPropertyValue @("Servername=SQLServer", "UserID=SQLUser")

Could someone please guide me?

Thank you.

enter image description here

Vipeen Sekharan · Accepted Answer · 2022-11-21 02:48:27Z

1

Solved it by using parameter "CommLinks".

So, the update script is

Add-OdbcDsn -Name SQL -Platform "32-bit" -DriverName "Microsoft Access Driver (*.mdb)" -DsnType "User" -SetPropertyValue @("Servername=SQLServer", "UserID=SQLUser", "CommLinks=SharedMemory,TCPIP{dobroadcast=no}")

answered Nov 21, 2022 at 2:48

Vipeen Sekharan

1051 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

PowerShell script to enable TCP/IP protocol in ODBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related