tpl connection string help

shougom

I have an odbc connection id like to change to sql server. The connection string is like below:

$dbh = new Win32:DBC('DSN=teamsite_stage;uid=eservices;pwd=password)'

Would like to use a sql server dsn not odbc.

Thanks.

ISCBorisB

I have an odbc connection id like to change to sql server. The connection string is like below: $dbh = new Win32:DBC('DSN=teamsite_stage;uid=eservices;pwd=password)' Would like to use a sql server dsn not odbc. Thanks.

Named Data Sources are Windows entities to abstract out certain aspects of DB Connectivity.
Data Sources can be used in ODBC or JDBC SQL Server Drivers to access Data. Drivers have certain API methods
that refer Data Source by the DSN - Data Source Name. There are also DS-less connection mechanisms.

So, you can use ODBC-DSN Connection or you can use JDBC-DSN Connection or you can use JDBC DS-less connection
or you can use some other DB Driver. What you can not do is use just "SQL Server DSN". Data Source is not a Driver on its own.

new2_report.rptdesign