maverick1714
New Member
- Joined
- Jun 4, 2010
- Messages
- 5
Hi
I have a problem with a excel document that gets external data from a MS SQL database.
The problem happened when we moved the database to another server. Excel gets the data via FileDSN which I updated but still I get the
“ 1004 run error” General ODBC error “ and VB editor points at the row:
Selection.QueryTable.Refresh BackgroundQuery:=False
I tracked the problem to one table i ny SQL database and the problem is that somehow excel adds a prefix to the query where it is supposed to get data.
It looks liike this:
user_logon.dbo.table1 dbo.table 2 dbo.table3....
why does it add the user_logon?
I have tried to change this without success. It does this only to the first table in the query list. All other tables are fine
I would appreciate any help I can get
I have a problem with a excel document that gets external data from a MS SQL database.
The problem happened when we moved the database to another server. Excel gets the data via FileDSN which I updated but still I get the
“ 1004 run error” General ODBC error “ and VB editor points at the row:
Selection.QueryTable.Refresh BackgroundQuery:=False
I tracked the problem to one table i ny SQL database and the problem is that somehow excel adds a prefix to the query where it is supposed to get data.
It looks liike this:
user_logon.dbo.table1 dbo.table 2 dbo.table3....
why does it add the user_logon?
I have tried to change this without success. It does this only to the first table in the query list. All other tables are fine
I would appreciate any help I can get
