Send Application Info via MS Access 2003

[TomT]

I have an MS Access application linked to SQL Server 2000 database tables. I
was wondering if there was a way to include in an ODBC or ADO connection
string the application name which I would include in the connection string.
I've tried using ;application name = "myapp", but Enterprise Manager still
shows the application as being Microsoft Office 2003.

I've gotten this to work in SQL Reporting Services, by the method above, but
can't seem to get it to work with Access.

Thanks for any tips on this,

TomT

 

[Michael Cheng [MSFT]]

Hi Tom,

From your descriptions, I understood that you would like to find "myapp" in
Application name in SQL Server Enterprise Manager instead of "Microsoft
Office 2003". If I have misunderstood your concern, please feel free to
point it out.

First of all, I would like to comfirm my understandings with SQL Server
Enterprise Manager: You find the application name "Microsoft Office 2003"
in <Instance Name> -> Management -> Current Activity - <time> ->Process
Info. If this is not the place you find the application name. Please point
me to the right place.

Secondly, I used ODBC Connection string sample like below and it will



[ODBC]
DRIVER=SQL Server
UID=v-mingqc
Trusted_Connection=Yes
DATABASE=mingqing
WSID=<machine name>
APP=MyApp
SERVER=(local)
Description=<descriptions>

Based on my test, you should modify the DSN before you link the table.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Michael Cheng [MSFT]]

Hi Tom,

It's great to hear that my suggestion helps You may refer the article
below

Specifying DSN Parameters
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbref/html
/dvhowspecifyingdsnparameters.asp


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[TomT]

Thanks again Michael, I'll check that out.

 

[Michael Cheng [MSFT]]

Hi Tom,

You are welcome!



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.