Re: Access Query w/VBScript

Bob wrote:
> I have been usinging a Windows Remote Server to exercise the ASP
> scripts - was waiting for one of the universitie's departments to
> provide us web space on their IIS server. Well, we have got the
> space now. Of course, none of the scripts (including the one I have
> posted) now work.

Even with Access??

>
> More information: Some ASP pages will be accessing Access data and
> others MySql - both databases will reside on servers, but not the web
> server.

It is very difficult to connect to an Access database that does not reside
on the web server. See here for more information:
http://www.aspfaq.com/show.asp?id=2168

> I have experimented with the code for connecting to MySql,

Sorry, but I have zero experience with mysql. You may want to move this to
..inetserver.asp.db where it will be more on-topic. You should realize that a
mysql odbc driver is probably not installed by MDAC. Have you had the
server's admin install the appropriate software on the server?


Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: mySQL and ASP, ASP.NET and FP server extension
    ... If you're hosted on a Windows server, you can use MS Access, which is free, ... >>> Indeed, I was not thinking mySQL before, because Windows-based platform ... >>> usually comes with MS SQL and ASP and so on. ...
    (microsoft.public.frontpage.programming)
  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: Converting from FM 9 to MySQL and keep both
    ... Here it is the starting point: Clinical research DB in FM 9 adv and FM ... Build another DB in MySQL, ... if you want server to execute anything in the way of scripts, make sure EVERY script step is web compatible. ...
    (comp.databases.filemaker)
  • Re: KDE is now broken (Fwd: Heads-up: KDE4 hitting testing tonight (UTC) )
    ... don't want to run an akonadi server either, ... KDE 4.0 was available. ... kmail) and I do not have a mysql server installed. ...
    (Debian-User)
  • Re: Need Help Programing a Form w/Pearl
    ... I've tried pearl scripts with FrontPage on a couple of occasions and came to ... the conclusion that I'd try to use .asp or .php if I couldn't use .asp. ... > My web hosting company uses a Unix server that they say won't support FP ... the email and .csv file are always blank. ...
    (microsoft.public.frontpage.programming)