Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 MS SQL, cant connect to database

views
     
TSAustin123
post Feb 1 2006, 05:04 PM, updated 20y ago

Regular
******
Senior Member
1,336 posts

Joined: Jan 2003


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.. smile.gif
snow
post Feb 1 2006, 05:06 PM

Enthusiast
*****
Senior Member
785 posts

Joined: Jan 2003



What is the programming language you're using? What is the error message you get?
TSAustin123
post Feb 1 2006, 05:08 PM

Regular
******
Senior Member
1,336 posts

Joined: Jan 2003


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.. smile.gif
ys_2k
post Feb 1 2006, 07:51 PM

Casual
***
Junior Member
369 posts

Joined: Jan 2003
From: Shah Alam


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
TSAustin123
post Feb 2 2006, 12:15 AM

Regular
******
Senior Member
1,336 posts

Joined: Jan 2003


database name is same.. i think is the security login?? unsure.gif
SincerePrayer
post Feb 2 2006, 04:32 PM

love to pray
Group Icon
Elite
1,120 posts

Joined: Jun 2005
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 smile.gif
TSAustin123
post Feb 3 2006, 07:17 PM

Regular
******
Senior Member
1,336 posts

Joined: Jan 2003


problem solved, juz careless.. tongue.gif
thanks everyone.. smile.gif

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

 

Change to:
| Lo-Fi Version
0.0140sec    1.39    5 queries    GZIP Disabled
Time is now: 23rd December 2025 - 08:41 PM