Download Sas Odbc Driver 9.3

Active5 years, 10 months ago

1. Sas Odbc Driver Configuration
2. Ms Access Odbc Driver Download

I am trying to link to an online SQL Server (2008) using SAS 9.3 on Windows7.

I've got an example:

Free driver odbc 64 bit sas 9.3 download software at UpdateStar.

Thus I imitated and wrote:

When I run the example, it works well. But when I run my code, I've got following error:

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

Sas Odbc Driver Configuration

ERROR: Error in the LIBNAME statement.

I've checked my ODBC settings, and DB1 and DB2 all appear in the System DSN tab. The only difference is that the Driver of the database that the example link to is SQL Server Native Client 10.0, while the database my code link to is SQL Server Native Client 11.0.

May I know how to make my code work? Any clue will be appreciated.

Ms Access Odbc Driver Download

ChangeMyName

ChangeMyNameChangeMyName

1,62499 gold badges3636 silver badges7171 bronze badges

1 Answer

No problem anymore. I found that the name of the ODBC and the database are not consistent. In fact, one has to address ODBC name in SAS rather than database name.

Suppose the database is DB1, and the ODBC is database1, then the code should be:

ChangeMyNameChangeMyName

1,62499 gold badges3636 silver badges7171 bronze badges

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged sql-serverodbcsas or ask your own question.