Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ MUSHclient
➜ General
➜ Path to db keeps changing within Mushclient
Path to db keeps changing within Mushclient
|
It is now over 60 days since the last post. This thread is closed.
Refresh page
Posted by
| Scotty
Australia (13 posts) Bio
|
Date
| Tue 02 Aug 2005 07:31 AM (UTC) |
Message
| I'm not sure if this is a scripting issue or a general one.
I've got an access db - located in 'D:\Program Files\MUSHclient\worlds\'
In several alias' I open that db using vbscript embedded in the send window:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=Stores1.mdb"
And everything works fine.
BUT - from time to time I get the error:
'D:\Program Files\MUSHclient\Stores1.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Nothing has actually changed from my perspective - but to access the db I then have to change my data source:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=worlds\\Stores1.mdb"
and then those alias' will work again.
Then down the track they stop working with much the same error and I have to put the path back to the original.
I've found the Global Preferences|Worlds|Default world file directory setting - but as far as I can determine that doesn't seem to be changing.
What I'm trying to figure out is what is providing the [i]'D:\Program Files\MUSHclient\worlds\'[/i] in the first place, and what could be causing it to change? | Top |
|
Posted by
| Nick Gammon
Australia (23,133 posts) Bio
Forum Administrator |
Date
| Reply #1 on Tue 02 Aug 2005 07:41 AM (UTC) |
Message
| It's in the registry, but I would suggest to avoid the problem put the full pathname in the "data source" rather than a relative path. |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | Top |
|
Posted by
| Scotty
Australia (13 posts) Bio
|
Date
| Reply #2 on Tue 02 Aug 2005 08:57 AM (UTC) |
Message
| Heh - I'd done that in the beginning and it hadn't worked. That was before I'd remembered to \\. Now it's sweet - thanks mate.
That being the last hurdle, I've completed the system I was writing. Which means I've just registered.
Now to compile a list of outrageous demands for the next version <g> | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
10,956 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
top