MS SQL Server ODBC - SQL Server does not exist or access denied

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server does not exist or access denied

pmohans

2006-12-12, 7:12 pm

Hi,

I am doing bulk copy through Stored procedure from one server to another
server Database. These servers are linked server.

If i am copying 100 records then 85 records copied successfully, 15 records
got the following error

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."

I want to know why i am getting this error?, if connection fails then how 85
records copied.

And what is the solution for this?

Pls help me ASAP.

Thanks & Rgds,
pmohans

Sponsored Links