DNS problems

[spg1]

Ok From the previous posting, I finally got it to work on my Personal web server!!!!!!!!!!
BUT
I can't get my remote server to see my DSN.....
when I upload it to the www directory...
If the DSN is specified in the local directory, does it change when it is uploaded? Or do I have to change the DSN on the remote server someway???

HELP!!!!!!!!!!!!!!!!!!!!!!!!!

[jdavison]

I would think the DSN needs to be set on the remote servers ODBC otherwise that machine doesnt know what the DSN is. If your using an access db there is away to go dirrectly to the DB file also.

[spg1]

What do you mean by going directly? How...
Remember I'm a rookie!

[jdavison]

you can set the connection to connect directly to the db file instead of going through ODBC

[spg1]

Any code for an example????
Does this eliminate the need for a dsn?

[jdavison]

its all just set in te connect string. don't have an example at the moment but I'll see what I can dig up for you.

[jdavison]

Here is an example for you

Set con = CreateObject("ADODB.Connection")
    con.Open "PROVIDER='MICROSOFT.JET.OLEDB.4.0';User ID=;Password=; Data Source=-path to DB-;"

'the sql command
mysql = "SELECT * FROM table"

'executes the sql
con.Execute (mysql)

Hope this helps

[spg1]

THANKS!!!!!!!!!!
if my database is in the root directory of my web page,
what path should I use?
If i use c:, the isp server tells me that ...
------------------------------

Microsoft JET Database Engine error '80004005'

Could not find file 'C:\WINNT\system32\employees.mdb'.
--------------------------
SG

[jdavison]

try "C:\employees.mdb"