Hello Tinkerer,
I read on another post you're losing your hair. I presume you're preparing to get into modelling. Don't forget me when you become a star!
You're on Hosting Controller 6 as against 7 as I had assumed. Just to mention, I'm not working for eukhost, I'm just another user like you. Now it implies you have SQL 2000 on the server.
You can use Enterprise Manager to connect to their database as far as I know, there should not be any problem. Just enter your domain as the SQL server host/name and the DB username and password as mentioned in my earlier post.
HOWEVER, you are trying to access an ACCESS file (mdb) which the application is looking for in DATABASE folder of the web root. There is nothing concerned with SQL server here.
Change or Use this string for Jet Engine, assuming file is MS Access and not MS Access 2007 format:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Software.mdb;User Id=admin;Password=;
NOte: copy the software.mdb file to the wwwroot folder itself, just for testing, with the above example.
if your access database has a password, enter the password before the last semi-colon (Password=yourpassword; ).
This should get you working in the first go.
Regds
IJ
|