does anyone know how i can open a database on another server?<BR>how do i deal with spaces in names? is it %20?<BR><BR>thanks.
It is the DSN that matters.if u have created a DSN for the remote database, the code is the same for both.
what if i want to do it dsnless?
http://www.able-consulting.com/ADO_Conn.htm<BR><BR>u need to substitute the remote server name, inplace of local server.better also lookat msdn