am using mssql not mysql so plse help

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...

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...

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

yup , i simply copied the script u suggested and made the changes so frankly

i dont know wat else to do

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...

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...

THANKS SKAHT BUT STILL IT AINT WORKING THIS is wat i did exactly wat u suggested

EXEC sp_addlinkedserver

@server = 'GAME',

...

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...

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...

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...

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...