After i restored the database, i cant connect to the database.. wat is the problem?? my code is working, b4 i restore the database.. thanks for advance..

What is the programming language you're using? What is the error message you get?

im using VB6, the error msg is failed to establish connection to database.. i bet there is nothing wrong wit my coding.. it has something to do the MS SQL..

could it be u restored the database with different "TABLE" name or "DATABASE" name?

This post has been edited by ys_2k: Feb 1 2006, 07:51 PM

database name is same.. i think is the security login??

Austin123,

What is the error message you get? If you use other MS-SQL tools, are you able connect to your restored MS-SQL?

From you program, are you using any special login and how you restore the database (attach or regular restore)?


Happy SQL-ing

problem solved, juz careless..
thanks everyone..

This post has been edited by Austin123: Feb 3 2006, 07:18 PM