i have a question for all the DB gurus out there. I am trying to connect to a DB on my ISP's server. I recently created a DSN for a program that works fine on my personal web server. To avoid my ISP creating a virtual ditrectory and so on.... someone suggested that I can create a connection directly and skip all the DSN stuff. I need help on the code to do so. Heres what I have:
---------------------------
Dim SqlJunk


Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")
dbGlobalWeb.Open("Employees")

SqlJunk = "SELECT * FROM Employees"

--------------------------------

I appreciate all help, thanks!!!!!!!!!!!!!!!