LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (May 2001, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 23 May 2001 14:46:50 +0200
Reply-To:     Ricke Godehard <Godehard.Ricke@ITELLIUM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ricke Godehard <Godehard.Ricke@ITELLIUM.COM>
Subject:      SQL ODBC online fine but batch doesn't functions
Content-Type: text/plain; charset="iso-8859-1"

Hello,

this source:

PROC SQL; CONNECT TO ODBC AS &ConnectAlias. (DSN="&SLA_KS2000_ODBC_DSN."); . . .

works online. But if I submitted it in batch job it doesn't work and I got the message:

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

I testet the macro variables - they are correct. Must I set options and which?

Regards Godo


Back to: Top of message | Previous page | Main SAS-L page