Passing Application Name to SQLSvr via connection object in ADP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top