powershellodbcdsn
PowerShell script to enable TCP/IP protocol in ODBC
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.
Solution
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}")
- tee with utf-8 encoding
- PowerShell says "execution of scripts is disabled on this system."
- Calling a PowerShell script from within a VBScript and the use of quotes in the variable passed (JSON format variable)
- Install winget by the command line (powershell)
- How does threading in powershell work?
- System.IO.FileInfo and Relative Paths
- Iterating Json attributes and PSCustom Objects
- MS Graph API - How to query additional pages
- Certificate Rebind in IIS 10 using powershell
- How to make PowerShell tab completion work like Bash
- Powershell function to check input and return datatype is not returning correct values
- Convert string to DateTime in Powershell from CSV
- PowerShell Call SSIS package, Pass Two (or More) Parameters
- Print Local Group Members in PowerShell 5.0
- Get current computer's distinguished name in powershell without using the ActiveDirectory module
- Best PowerShell method to get the current Active Directory Site name of the local computer
- NetBIOS domain of computer in PowerShell
- How do find out short name of domain I'm in?
- Powershell : How to include the root directory while creating a zip using a function
- PSCustomObject to Hashtable
- How to create a Run As Administrator shortcut using PowerShell
- Az-GetRoleAssigments Not returning Data for DisplayName, SignInName & Object Type - Azure Powershell Runbook
- How to accept inline inputs in a noninteractive powershell script
- remove event subscriptions from system topics
- powershell parse Json file with \ and wildcard in the key name
- Is there a string concatenation shortcut in PowerShell?
- import files to databricks workspace
- How is child_process.exec('powershell "$userInput = Read-Host;"') handled in node.js?
- Can't use sed when using ssh with ms powershell to linux host
- Append information to the output of an existing command