burkhard, steffen, matt, thanks for your help. it turns out i was close on a previous attempt, but did not quite get the driver name right. i hope this post will help other sapdb newbies.
darrell -----Original Message----- From: Diesing, Burkhard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 10:58 AM To: 'Hawley, Darrell'; '[EMAIL PROTECTED]' Subject: RE: DSN Less Connections > -----Original Message----- > From: Hawley, Darrell [mailto:[EMAIL PROTECTED]] > we are an ASP shop looking into open source options, starting > with SAP DB. > one habit that we have gotten into (for better or worse) is > writing dsn less > connection strings. i have seen references to people doing > this, but i can't > seem to find the syntax. does anyone know the proper syntax > for doing this > within ASP? Hi Darrell, for using the ODBC interface under UNIX you can follow chapter 4 of the SAPDB ODBC Usermanual at http://sapdb.org/pdf/usmanodbc_73eng.pdf. (Set the DSN argument of the SQLConnect function to <host>[:<serverdb>]). For MS Windows you can connect DSN less by setting the 'DRIVER=<drivername>;SERVERDB=<serverdb>;SERVERNODE=<host>' into the InConnectionString argument of the SQLDriverConnect function. See MS ODBC Programmer's Reference Manual. Regards Burkhard _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
