Joined: 26 Jul 2007
|Posted: Fri Jul 27, 2007 3:48 am Post subject: HELP PLS cant connect to SQL with ASP
|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:
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
my connectstring is this : ConnectString = "PROVIDER=SQLOLEDB;User ID=sa;Password=sa;Data Source=localhost;Initial Catalog=websma"