i'm using DSN.i get a host and they set up a DSN for me and sent it for me.the DSN name that they gave me is and ip addres.and my sql server in their server hase a name,user name and password.
yes i copied oConn from windows application.my server is not located in my local machine it is a remote server.you mean oConn is my connetion string?

No, oConn is probaly the connection object, but this depends on the rest of the code....

You need to assign the connection string (with the DSN) or use it in the Open command:

oConn.Open "dsn=mydsn"

or

oConn.ConnectionString = "dsn=mydsn"
oConn.Open

It looks like you're missing a few important basic concepts in working with ADO connection objects. I think you need to pick up a good book about this or do some Googling....

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

yes you are correct i'm really confused i think i should study more about ADO.thank you

i write this code i my connectin page but it gives me error againshould i add this codes to all pages serately?cant i use it in my connection page?
<%
Dim QCcon as New ADODB-connection

QCcon.open
Dim MM_QCcon_STRING as String
MM_QCcon_STRING="Driver={SQL Server};Server=sql.bekr.net;Database=host064;Uid=s a;Pwd=56ghj;"


%>

I don't think you should be copying code from a VB application without knowing what you're doing. This:

Dim QCcon as New ADODB-connection

is VB code where you can strongly declare a variable. In ASP you use late-binding, like this:

Dim QCcon
Set QCcon = Server.CreateObject("ADODB.Connection")

Also, instead of a - symbol, you need a dot between ADODB and Connection.

Whether you put this code in an include file or not is up to you. Both will work, and each will have their advantages.

But again, if you want to build a working application within the next month or so, I suggest you get a good book or web site. Any ASP or ADO book shows you how to connect to a database in a few pages. Struggling with code copied from a desktop app might take you ages, making things more expensive than the investment in a book.

Cheers,

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

i have a boock about ADO but my company force me to upload it as soon as possible and i don't have enough time to studi this boock completely.but i'm reading it noe to find some thing useful.please help me to upload it
thank you

excuse me.i upload new conection page right now bur this time it gives me this error(i think my data base doesn't know the user):
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

/login.asp, line 14

Of course it's entirely up to you, but IMO working on a solution without really understanding how to do it results in bad applications that are delivered too late anyway.... I can imagine you're in a hurry, but I still think you may need to rethink your strategy.

Anyway, did you use Google or this forum's search feature for the error message?? You'll find loads of results for that error indicating that the current web server user isn't allowed to use the database. This is usually fixed by adding the IUSR_MachineName to SQL server and giving it just enough permissions to read (and possibly write to) the data.

Cheers,

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

you're exactly right.i'm really in hurry because my boss force me to do it as soon as possible and reading all the book takes much time and i can't spned this time now.but i'm reading ADO book during this time.i search for the result of this error and the think that find is that the user is not defined.i connect to my host support and tell them my problem they are looking for the result.because i have 2 table frome each tables that has attached to server
but please if find any other causes that can make this problem tell me
thank you

No, AFAIK, the only reason for that error is that the IIS account doesn't have access to SQL Server. Your host should be able to fix that.....

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