SAS IOM connection strings
SAS IOM Data Provider
-
Local instance of the IOM server
Provider=sas.IOMProvider;Data Source=_LOCAL_;
-
Bridge protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359; -
Corba protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=1;SAS Port=1359; -
Com protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=0;SAS Port=1359; -
-
SAS Service Name instead of port number
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;
SAS Service Name=sasobjspawn; -
Login required by server
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
User ID=myUser;Password=myPassword; -
Tabular Data server type
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Server Type=1; -
OLAP server type
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Server Type=2; -
Establish communication with an existing workspace
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Workspace ID=myWorkspaceUniqueIdentifier;
↯ Problems connecting?
Get answer in the SAS IOM Q & A forum
Connect
Articlesread all »
- Formating Rules for Connection Strings
- Connection Strings Explained
- Store Connection String in Web.config
- Connection Pooling
- The Provider Keyword, ProgID, Versioning and COM CLSID Explained
- SQL Server Data Types Reference
- Network Protocol for SQL Server Connection
- All SQL Server SqlConnection Properties
- When to use the SQL Native Client
- Open a password-protected Excel workbook
Didn't find your connection string?
Start over from the connection string reference index - or try a search!
In the Q&A forums you can ask your own question and let somebody help you.
The knowledge articles contains solutions and guides.
The value of "_LOCAL_" is a keyword that indicates that a local instance of the IOM servers should be used.