I have a powerbuilder app that currently uses odbc to connect to sql server 2008 r2 and sql server 2000 databases. I would like to do away with the requirement for odbc and use something like SQL Native Client to connect or whatever the best connection method is. With VB.Net apps I import the system.data.sqlclient namespace and then I can just pass a connection string. I haven't figured out exactly how to do this yet with powerbuilder. Can someone give me some direction please? Here's what I've tried passing through the config file:
DBMS = "SNC SQL Native Client(OLE DB)"
ServerName = "usoscs407"
AutoCommit = False
DBParm = "Provider='SQLNCLI10',Database='db_qc00',TrustedConnection=1"