Viewing 15 posts - 1,306 through 1,320 (of 2,452 total)
are those errors you posted occurring in SSMS when you try to set up the linked server?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2014 at 7:58 am
sharonsql2013 (7/23/2014)
Yes , its for reporting
what are you expecting the results to be from your post?
what other tables do you have that store this data.....?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 3:35 pm
Luis Cazares (7/23/2014)
You have 2 options:- Normalize your table
- Use dynamic SQL
You decide.
I agree with Luis...normalise your data...
what are you expecting the results to be from your post?
what other tables...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 3:10 pm
just a thought...but appears to work, but maybe I am not entirely clear on the issue
IF OBJECT_ID('Tempdb..#Redondeo') IS NOT NULL
DROP TABLE #Redondeo
CREATE TABLE #Redondeo (
Orden INT Identity(1, 1)
, Valores MONEY
)
INSERT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 2:07 pm
Shaun2012 (7/23/2014)
please view the snapshots..
you are trying to set up the linked server in SQL (via SSMS) ??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 2:04 pm
Shaun2012 (7/23/2014)
can i send u the error message tommorrow.... im just leaving work ...
pity...have time to help now...but tomorrow will be fine...hopefully someone else will pick up as well
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 1:34 pm
what error message?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 1:21 pm
Shaun2012 (7/23/2014)
the command wont work because i have insert only rows which does not match and rows which matched to be updated by a value...
what command wont work?
were you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 1:01 pm
try this and see if it helps
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO
EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'<linked server...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 12:52 pm
just a thought...set up a linked server...that way you can push/pull Access
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 10:53 am
clue....
SELECT COMPANY, COUNT(*)
FROM [CPACONTACTS].[dbo].[CPACONTACTS2]
GROUP BY COMPANY
ORDER BY COUNT(*) DESC
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 23, 2014 at 2:52 am
have you tried this suggestion
http://visakhm.blogspot.co.uk/2013/12/how-to-solve-microsoftaceoledb120-error.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2014 at 3:40 pm
shot in the dark
SELECT * FROM
OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=E:\TestFiles\ExcelFile.xlsx';
Extended properties=Excel 12.0', [Sheet1$])
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2014 at 1:07 pm
ok...my thoughts,,,warts n' all 😀
first some sample data I've made up that I hope is somewhat similar to your situation
use [tempdb]
GO
SET NOCOUNT ON
/* build some example tables*/
IF OBJECT_ID('tempdb..Tally') IS NOT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2014 at 12:12 pm
halifaxdal (7/21/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 6:51 am
Viewing 15 posts - 1,306 through 1,320 (of 2,452 total)