Hi,
Maybe u've seen this post in the Ultradev forum. Well I've mistakenly post my question there so pls forgive me. Here goes my question again: The database connection in my local machine is System DSN which work well. Now after uploading my site and the database to a hosting server, dynamic pages that retrieve data from the database are not displayed. I've figured that I need to change the connection from dsn to dsn less. So where actually should I do this?Is it in the conn.asp in my Connection folder? And, do I have to change the coding in every pages?

So in my page, do I need to change anything here?
---|

Dim rs_user
Dim rs_user_numRows

Set rs_user = Server.CreateObject("ADODB.Recordset"
rs_user.ActiveConnection = MM_conn_adigadget_STRING
rs_user.Source = "SELECT * FROM tbl_login WHERE uname = '" + Replace(rs_user__MMColParam, "'", "''" + "'"
rs_user.CursorType = 0
rs_user.CursorLocation = 2
rs_user.LockType = 1
rs_user.Open()


And the thing that puzzles me is, I can successfully login to my site, which means that the database is actually being recognised, right? So how come I can login but pages that connect to database are not displayed?Pls help me to do this correctly.

Thanks.

Read the following, it will give you a good base for creating your connection:
www.ultradevguru.com/tutorial/dsnless.htm