Windows 7, SQL 2008, Macola ES 9.5.300

[jbelk11]

Good evening....

Has anyone tried to run the latest ES 9.5.300 on a Windows 7 box against a local installation of SQL 2008 Standard? (This is my own laptop we are talking about)

Everything seems to be okay....with one exception. I have flexibility code on multiple screens that queries the database for additional info. My code is breaking on the following line....

cn.Open (macForm.ConnInfpenADOConn)

The error message I receive is that the login failed for my username (without the domain info).

My domain login is listed as the actual db_owner in SQL Server....I have given myself sysadmin privileges...etc.

When running profiler, the error occurs on a set approle statement. The username listed is Domain\Username.

Is this the dreaded "not actually running as an admin" problem or something along those lines? This is my first stab at using Windows 7 or Windows Vista on any client machines.

The other option I can think of is to actual hard code a username/password when opening the ADO connection...instead of using ConnInfo. I'll have to give that a try later tonight.

Thanks

Jen

 

[stravis]

Another option would be to just generate your own connection using ADO directly and use a trusted connection. This will circumvent the use of the set app role and potentially your problem.

Scott Travis
Enterprise Expressions LLC