Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: cannot connect to my sql server

    am using mssql not mysql so plse help

  • RE: Link servers

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

  • RE: Link servers

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

  • RE: Link servers

    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

  • RE: Link servers

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

    i dont know wat else to do

  • RE: Link servers

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

  • RE: Link servers

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

  • RE: Link servers

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

    EXEC sp_addlinkedserver

    @server = 'GAME',...

  • RE: Link servers

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

  • RE: Link servers

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

  • RE: Link servers

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

  • RE: Link servers

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

Viewing 12 posts - 1 through 12 (of 12 total)