01-08-2015 07:41 AM
When running the below proc I get an error saying "ERROR: Invalid option name =."
The library is of sqloledb, and with it I can register and browse a table successfully. The error only occurs when I update the table metadata, whether I do it by SAS Base code or by the GUI in Data Integration Studio/Management Console.
Does anyone have an idea of what causes this?
01-08-2015 09:35 AM
Looks like the OLEDB connection string is the issue.
One connection string works for updating the table metadata, another format on the connection string means i can browse the table.
I cant seem to specify a oledb string that handle both cases... I noticed in DI studio 4.9 that quotes are added around the data source when creating a new server object. This is not the case in DI Studio 4.8.
Need further help from the community? Please ask a new question.