Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Urgent need help

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2002-01-02 : 09:54:03
We updated the client's database and restore it back on their
server from our side using pc anywhere.The program was working before updating.
The same database we used it on our office and it's working fine.
We are getting this error on client's computer when he is trying to connect to sql server 2000 using VB 6 Program.

Run-time error 2147211505(8004270f)
Microsoft OLE DB Provider for sql server
Connection Open (Create File()) User : Load Method

I updated the user also with sp_Change_Users_Login 'update_one','admin',admin

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-01-02 : 11:43:59
Add an alias for the server using the Client Network utility. I'm not saying this will solve the problem, but it has worked for some of my situations when I could not figure out what else would be the problem.

*************************
Just trying to get things done
Go to Top of Page
   

- Advertisement -