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

Try setting the username and password via Start, Settings, Administrative
Tools, Data Sources (ODBC).
Another option is to connect with ADO and set the username and password in
the ADO connection string.
What is the data source?

RBS


"Fid" wrote in message
...
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

On Dec 1, 11:47 am, "RB Smissaert"
wrote:
Try setting the username and password via Start, Settings, Administrative
Tools, Data Sources (ODBC).
Another option is to connect with ADO and set the username and password in
the ADO connection string.
What is the data source?

RBS

"Fid" wrote in message

...

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

There is no option to define the username and password via the ODBC
data source administrator for the driver I am using. I am using a
driver called Relativity which connects me to a RM/Cobol database -
the datasource. I have called tech support for Relativity and they
told me that the issue was not with their program and that the
username and password had to be defined somewhere else.