they call me right now and told me to send them my backup from my database.can it be cause this problem???

Not sure what you mean? Why would sending them a back up cause a problem??

If they restore the back up on the server, they have to add the IUSR account again to your database. However, I assume it's something your host should know and understand.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

thank you.the host told me they will upload my data base again.i think it will be solved tomorrow.i don't know what will they do with backup.

i revice same error again:(i checked the users in the interprise manager it has just one user that is host064 and its my database name.shouldn't i make another user for internet users?and if i should do this what is its name?i don't know what to do:(

my host told me that the problem is for my connection coddings.i searched and i found many connection strings in diffrenet types but it still gives me error
i wrote it like this:
<%
Set QCcon = Server.CreateObject("ADODB.Connection")
QCcon.open "DSN=sql.bekr.net;UID=myuser;PWD=mypass;DATABASE=h ost064"
%>
but it gives me this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/Connections/QCcon.asp, line 4
and line 4 is my QCcon open line

Did your host create a DSN for you? If so, what name did they give it?

It seems that you're using your server's full name in the DSN which doesn't work. In a DSN:

DSN=SomeThing

SomeThing is not the name of the server or database; it's the name of a DSN that must be present on the server.
If you don't have a DSN, you should try to use a DSN-les connection, as shown on the site I pointed you to earlier.

But this is really something you should work out with your host, as I can only guess what the right settings are. I take it that if they offer SQL Server and can upload databases for you, they sure know how to connect to it, or at least have some documentation /FAQs on their site explaining this? Did you check out their site?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

If I were you, I wouldn't be posting security related information like server names, user names and password on a public forum like this. I think you should review your messages in this thread and remove sensitive information before Google picks it up....

Anyway, I told you before: I'd like to help, but I can't. This is something you and your host must work out. They know their system, they know their databases and username etc so they can correctly set it up for you and tell you how to connect to it.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I can't believe i made such a big mistake:O i copied the code and i forgot to replace my user pass and database name.:O i think everything that could be happend has happend untill now it would be better to change my user,...