Viewing 12 posts - 1 through 12 (of 12 total)
am not really clear abt wat u saying , if u cud break it down for me or elaborate , anyway i created
a udl file like u said and...
February 20, 2009 at 1:04 am
ramesh:
Are you sure that the file "C:\Users\babygirl\accessdb\Ayawaso_East.mdb" can be accessed via windows file system?
Try creating & accessing the linked server using an windows system administrator's account.
rais:
am not sure even though...
February 19, 2009 at 8:19 am
am using sql server authentication
and the name is slim with password kassim so i changed sa' and kept the slim there as the login like u said
February 19, 2009 at 7:34 am
yup , i simply copied the script u suggested and made the changes so frankly
i dont know wat else to do
February 19, 2009 at 7:02 am
hi ramesh
thanx for the help but still the errors below keeps poping up, maybe is not the matter of syntax ba rather some configurations ..... am just sugesting try...
February 19, 2009 at 6:52 am
am not really sure wat to put in the someAccessServer part cus my acess db is on thesame pc as my sql server ... so plse elaborate .... anyway i...
February 19, 2009 at 3:16 am
THANKS SKAHT BUT STILL IT AINT WORKING THIS is wat i did exactly wat u suggested
EXEC sp_addlinkedserver
@server = 'GAME',...
February 18, 2009 at 7:08 am
sadly its still giving me that error
after i create my linked server i executed a simple select statement and i get this error
select * from rais ... Community
OLE DB...
February 18, 2009 at 3:09 am
sadly its still giving me that error
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "rais" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 5
Cannot initialize the data source object...
February 18, 2009 at 3:01 am
There is nothing like catalogs when i double click my linked server name
what i see is a window divided in to two parts, the first part is
General>
security>local login|impersonate|Remote User|Remote...
February 18, 2009 at 2:43 am
not quiet sure wat u mean but i guess am able to extend link servers on management studio
thus how i get to see the various providers..... can u help...
February 18, 2009 at 2:19 am
Viewing 12 posts - 1 through 12 (of 12 total)