September 2, 2014 at 2:47 am
Hi,
In Excel when going to Data - Get External Data - From Other Sources - From Microsoft Query.
I choose a datasource which is published via the Citrix Server that we are launching Excel from. Someone selects the source and it goes and finds the tables. You then add a table and try and select a field from it and they get the following error -
Could not find server 'Datacube_Prog10' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Statement(s) could not be prepared.
So the SQL server I'm trying to connect to is -
MHSVI-DATAWAREHOUSE
The Instance is - MHSVI-DATAWAREHOUSE\DATAWAREHOUSE
The database is - Datacube_Prog10
The odbc on the citrix server connects fine - so I'm at a total loss as to why this is all of a sudden happening.
Please help.
September 2, 2014 at 4:41 am
The error suggests that the connection string is defining Datacube_Prog10 as a server name.
The first thing I would do would be to go through the connection string and ensure the information is correct.
September 2, 2014 at 4:57 am
Where would I view the connection string from Microsoft Query?
September 2, 2014 at 5:02 am
Appears to have started working all of a sudden - no SQL changes at all?
Sorry to waste your time - no idea why it's working all of a sudden
September 2, 2014 at 5:13 am
Instead of [Microsoft Query], can you use [From SQL Server] as the data source?
September 2, 2014 at 5:15 am
From SQL Server worked which was really bizarre.
September 2, 2014 at 5:35 am
Worked it out - it was table specific. I was wrongly informed it was affected all tables.
The table had a "." in it which Query Analyser didn't like.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply