View previous topic :: View next topic |
Author |
Message |
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Thu Jul 26, 2007 2:06 am Post subject: CANT CONNECT TO SQL |
|
|
i am currently using SQL 2000 for database and i have already install classic asp with abys into my laptop that is using XP HOME and fine it can run asp pages well BUT now i cant seem to find any clue why everytime i access my page and it come out error
like this : sql error- something mentioning the database not found or access denied
NOTE : i have already set the datasource:localhost, username and password too but it seems doest work
can anybody help me, i need it to finish my assignments :cry: _________________ Nu Bieeee |
|
Back to top |
|
|
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Thu Jul 26, 2007 4:34 am Post subject: |
|
|
the error message is :
Microsoft OLE DB Provider for SQL Server- Error'80004005'
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
PLS HELPPPPP ASAP _________________ Nu Bieeee |
|
Back to top |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Thu Jul 26, 2007 4:36 am Post subject: |
|
|
I don't have any experience with SQL Server, but to me it looks like you either are connecting to a non-existent server (is it running?) or your account with the SQL server doesn't have the necessary permissions to edit the database. _________________ -Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados. |
|
Back to top |
|
|
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Thu Jul 26, 2007 4:45 am Post subject: |
|
|
rrinc wrote: | I don't have any experience with SQL Server, but to me it looks like you either are connecting to a non-existent server (is it running?) or your account with the SQL server doesn't have the necessary permissions to edit the database. |
i have already check my SQL and it is running well, any advice? seems like it cant fine the database _________________ Nu Bieeee |
|
Back to top |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Thu Jul 26, 2007 5:09 am Post subject: |
|
|
Well, are you specifying the correct database and login details? Maybe you misspelled something. _________________ -Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados. |
|
Back to top |
|
|
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Thu Jul 26, 2007 5:15 am Post subject: |
|
|
rrinc wrote: | Well, are you specifying the correct database and login details? Maybe you misspelled something. |
my connectstring is this : ConnectString = "PROVIDER=SQLOLEDB;User ID=sa;Password=sa;Data Source=localhost;Initial Catalog=websma"
and the error point to this line. any clue???? _________________ Nu Bieeee |
|
Back to top |
|
|
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Fri Jul 27, 2007 2:53 am Post subject: |
|
|
hello there is there anyone that can help me??????? :( _________________ Nu Bieeee |
|
Back to top |
|
|
superbogel -
Joined: 26 Jul 2007 Posts: 8 Location: Jakarta
|
Posted: Fri Jul 27, 2007 5:36 am Post subject: |
|
|
pls close this thread i have already got it right THX ANYWAY GUYS :) _________________ Nu Bieeee |
|
Back to top |
|
|
|