https://communities.sas.com/t5/SAS-Programming/Is-the-server-name-with-space-valid/m-p/887494#M350634 <P>&nbsp;</P> <P>For some reason this odbc connection code failed. I'm not sure this problem. Is server name with space valid?&nbsp; Thank you.</P> <P>libname try odbc noprompt=<BR />"DRIVER=ODBC Driver 17 for SQL Server;DATABASE=DBCMIPRPT01;SERVER=jcdevi4-jcdevcodat01.Central Office;<BR />Trusted_Connection=Yes" schema=dbo;</P> Wed, 02 Aug 2023 14:23:44 GMT nnl3256 2023-08-02T14:23:44Z https://communities.sas.com/t5/SAS-Programming/Is-the-server-name-with-space-valid/m-p/887494#M350634 <P>&nbsp;</P> <P>For some reason this odbc connection code failed. I'm not sure this problem. Is server name with space valid?&nbsp; Thank you.</P> <P>libname try odbc noprompt=<BR />"DRIVER=ODBC Driver 17 for SQL Server;DATABASE=DBCMIPRPT01;SERVER=jcdevi4-jcdevcodat01.Central Office;<BR />Trusted_Connection=Yes" schema=dbo;</P> Wed, 02 Aug 2023 14:23:44 GMT https://communities.sas.com/t5/SAS-Programming/Is-the-server-name-with-space-valid/m-p/887494#M350634 nnl3256 2023-08-02T14:23:44Z https://communities.sas.com/t5/SAS-Programming/Is-the-server-name-with-space-valid/m-p/887596#M350660 <P>Please post your error message. SQL Server connection strings tend to be very picky regarding formatting.&nbsp;</P> Wed, 02 Aug 2023 23:27:32 GMT https://communities.sas.com/t5/SAS-Programming/Is-the-server-name-with-space-valid/m-p/887596#M350660 SASKiwi 2023-08-02T23:27:32Z