F
Fid
I am using Excel 2007 with WinXP.
I have an ODBC data source set up called "ESC" in System Data Sources
as defined in the ODBC Data Source Administrator.
Next in Excel I click on Data, From Other Sources, and From Microsoft
Query.
The I choose "ESC" from the Choose Data Source Dialog of Microsoft
Query that pops up.
I am immediately prompted for a username and password. At the login
prompt I simply click "OK" without entering a username or password
(both are blank) and I am connected via ESC DSN and can edit the
query and get it to return the correct information.
Every time I refresh this connection I get the same login prompt and
have to click "OK".
I need this to refresh without user intervention so I tried to resolve
the problem by telling the connection to remember the password with
the following method: Click Data, Connections, Query From ESC (the
name that Microsoft Query gave to the connection I just built),
Properties. Select the Definition Tab and check the "Save Password"
box under Connection String. When I do this it puts PWD= in the
connection string. I click OK to save the settings.
Now when I refresh the query I still get the same login prompt.
I even tried changing The Excel Services Authentication Settings in
the connection definition from Windows Authentication to "None"
without any luck. Then with the "None" checked for Excel Services
Authentication Settings I added PWD=; UID=; to the connection string
and that did nothing.
I also found no help having to do with this and Excel on Microsoft's
knowledgebase.
Can anyone help me before I am forced to call Microsoft.
Thanks,
Brent
I have an ODBC data source set up called "ESC" in System Data Sources
as defined in the ODBC Data Source Administrator.
Next in Excel I click on Data, From Other Sources, and From Microsoft
Query.
The I choose "ESC" from the Choose Data Source Dialog of Microsoft
Query that pops up.
I am immediately prompted for a username and password. At the login
prompt I simply click "OK" without entering a username or password
(both are blank) and I am connected via ESC DSN and can edit the
query and get it to return the correct information.
Every time I refresh this connection I get the same login prompt and
have to click "OK".
I need this to refresh without user intervention so I tried to resolve
the problem by telling the connection to remember the password with
the following method: Click Data, Connections, Query From ESC (the
name that Microsoft Query gave to the connection I just built),
Properties. Select the Definition Tab and check the "Save Password"
box under Connection String. When I do this it puts PWD= in the
connection string. I click OK to save the settings.
Now when I refresh the query I still get the same login prompt.
I even tried changing The Excel Services Authentication Settings in
the connection definition from Windows Authentication to "None"
without any luck. Then with the "None" checked for Excel Services
Authentication Settings I added PWD=; UID=; to the connection string
and that did nothing.
I also found no help having to do with this and Excel on Microsoft's
knowledgebase.
Can anyone help me before I am forced to call Microsoft.
Thanks,
Brent