C
CharlieG
In my Data Project I'd like to pass the Application Name to SQLSvr. I can do
this with the default ADP Connection (File->Connection->All - Application
Name), but my app requires a disconnected startup and a manual connection
string.
Here's the connection string:
"Provider=SQLOLEDB;Application Name=MyApp;Network Library=DBMSSOCN;Data
Source=MySqlSvr;Initial Catalog=MyDB;user id=myUid;password=myPwd
Everything connects fine, but SQL Profiler shows 'Microsoft Office 2003' as
the Application Name on the connection, not 'MyApp'.
Does anyone see what I'm doing wrong, or is this not possible with Access?
Thanks
this with the default ADP Connection (File->Connection->All - Application
Name), but my app requires a disconnected startup and a manual connection
string.
Here's the connection string:
"Provider=SQLOLEDB;Application Name=MyApp;Network Library=DBMSSOCN;Data
Source=MySqlSvr;Initial Catalog=MyDB;user id=myUid;password=myPwd
Everything connects fine, but SQL Profiler shows 'Microsoft Office 2003' as
the Application Name on the connection, not 'MyApp'.
Does anyone see what I'm doing wrong, or is this not possible with Access?
Thanks