topic PC SAS,SQL Server error in SAS Programming

PC SAS,SQL Server error

Cherry — Tue, 30 Aug 2011 11:12:28 GMT

when i trying to connect to sql server through PC SAS , getting the below error.

"ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

ERROR: Connection to the odbc DBMS does not exist.

This is the sample code for this error:

proc sql;

connect to odbc (dsn=rfdev user=Import pwd=***** );

create table industry.compid2sic_&asofdate

as select * from connection to odbc(

select distinct b.compid as borrower_id, b.wgt , c.[SIC CODE] as sic_code , c.[Industry Code Cross Reference] as Industry_c

FROM DBO.HBUS_SA_CUBE_&asofdate AS A

LEFT JOIN [REPORTING].DBO.NA_V_IndWgt_t() AS B ON A.Borrower_Id = B.[COMPID]

LEFT JOIN DBO.TEMP_SICIndMapForBoard AS C ON B.UNDY = C.[SIC CODE]

where a.report_mlob <> 'Retail'

);

disconnect from odbc;

quit;

manojinpec — Tue, 30 Aug 2011 11:16:46 GMT

Hi Cherry ,

There might be typo in connection string.

Cherry — Tue, 30 Aug 2011 11:33:43 GMT

What does it mean? can you please explain ?

andreas_lds — Tue, 30 Aug 2011 12:42:15 GMT

The error message means that no data source named "rfdev" exists.

Cherry wrote:

What does it mean? can you please explain ?

Ksharp — Wed, 31 Aug 2011 03:10:02 GMT

Did you set up a data source name (i.e. rfdev) in the control center before run this code?

Ksharp

Cherry — Wed, 31 Aug 2011 11:39:42 GMT

Hi,

I didn't created this DSN, i don't know how check this. Could please advise me what is control center, where can find this, and how to check?

art297 — Wed, 31 Aug 2011 12:50:47 GMT

I don't know if you are using ODBC or the SAS/Access product. If it is the latter, you might want to take a look at: http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_sql_7364.pdf

Ksharp — Thu, 01 Sep 2011 06:23:02 GMT

If your OS were WinXP.

Start -> Set up -> Control Panel -> Manager Tools ->Data Source(ODBC) ->Add-> Select SQL server

to set up a data source name of SQL ,then use this new dsn in the code.

Good Luck.

Ksharp