Can anybody body pls. help me....here's the senario:
I developed a macro in computer 'X' that connect to a SQL server which installed in the same computer - computer 'X' . after i successfully developed the macro in computer 'X' i tried it to other computer - computer 'Y' but when i try to run the macro an error message appear - ""[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied" can any body pls. tell me what would be the problem and can anybody pls.tell me what to do. thanks in advance!!!