MORE DSN :}

[spg1]

I am a rookie remember!!!!!!!!! A COM file????
How? Is there anywaty to do this without the help of my ISP? Or do they have to create a virt. dir. for me. It's their server.

[hitcgar]

Ok, don't panic. You should be able to create directories for your site when you log in to your ISP account.

But you have to be sure that the ISP is using NT. If not you can't just upload a DB (say an Access .mdb file) and expect it to work because if the server is not running NT
then it is probably running some form of UNIX. So the file system is completely different and an .mbd file will just be binary nonesense to it and you won't be able to read it.

So, first confirm that the server is NT (or 2000). If it is you can call the DB without a DSN directly as in the code sample you posted.

If not and in all cases I suggest you install IIS on your system and set up your own server to your DB, create your DSN and use it as planned.

Considering your experience, I'd try to find some tutorials and docs on the subject before going ahead just so you can get familiar with the technology.

There's loads of docs and examples on the microsoft MSDN site.

Unfortunately, this stuff is still more complicated than it sounds when you're dealing with an ISP. They may or may not support (though they should) microsoft-based stuff.

Start by finding that out, perhaps they will even help you through the process.

But installing IIS (or maybe personal web server - lots simpler) and doing it yourself and learning is the best way to go in my opinion.

COM means Component Object Model and is a MS technology that allows you to build distributed applications.

[spg1]

Yes it is a NT server. But when I use the code above it says it cannot do because the object is closed.

when I add => con.Open

It gives me an error of =>
-----------------
Microsoft JET Database Engine error '80004005'

Could not find installable ISAM.

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

Now I'm lost!

[hitcgar]

Yikes. Well I suspect the server doesn't have the Jet engine installed or something. Try using the Open command
without specifying the provider section.

Like :

con.Open "User ID=;Password=; Data Source=employees.mdb;"


When accessing files on a web server never use an absolute path such as "c:\dir\filename". Always use relative paths such as "/dir/filename.ext"

Using "c:\employees.mbd" will not work because the DB is not actually stored on the ISP's servers C drive. It is placed in your personal directory on the server somewhere and we don't care where. The ISP creates a virtual dir for it's users.

If you have an image file you want to use on your Page create a dir. called images and store all you site images there.

Then, when you want to use an img tag to reference the image you use <img src="images/image.jpg" border=0 >

Same thing goes for DB use.

I think that you should contact your ISP to discuss your problem with them. Perhaps they will give you more precise instructions for setting up the DB part of your site.

If I was you though I'd get things working locally first using Personal Web server. Then use the Publish Wizard to deploy the site to your ISP account.

Hope this helps more ;)

You'll succeed, just keep on sluggin'.