Hi again,
Well Tinkerer, I apologize for those confusing instructions. I could not make out from your posts on what server you are and what kind of connection you're seeking.
You apparently have a DSN at home PC which is working. But when you shift the files here, the DSN, obviously is missing.
I have fortunately managed to get a few screenshots.
Step1: Upload the Database File to any folder on the server, ideally in the DB folder
Step 2: Create a DSN on the server for the above file.
a) Login to Hosting Controller, Goto Domains->Properties->ODBC DSN
b) Then Click on Add DSN
c) Then Enter DSN NAme: I have named dsnSoft in the shots
Enter DSN Description as anything you like, without spaces is better.
Select Microsoft Access Driver and hit Next
d) Enter option admin and password (This is not shown in the screenshots, but i have used admin as username and admin as password as well)
e) Hit Browse and locate the file where you have uploaded the MDB file ON THE SERVER.
f) Then it should show you're ready with the Database DSN (My screenshot is showing different names but yours will show the same as entered above)
Your database DSN is now ready on the server.
IN your applications, just use the DSN Name:
DSN=dnsSoft;Uid=admin;Pwd=admin;
Now it should be a bit easier and hopefully your hair will start growing again.
Keeping my fingers crossed.
Regds
IJ
|