myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

DSN connection by default Options · View
sfactor
Posted: Thursday, September 06, 2007 6:11:01 AM
Rank: Newbie
Groups: Member

Joined: 9/6/2007
Posts: 3
Points: 0
Location: Novosibirsk, Russia
Is it possible to configure myLittleAdmin Full edition for MSSQL2000 so that it allows only DSN connections at the logon screen? (so that DSN-less connection option is completely hidden)
elian
Posted: Thursday, September 06, 2007 7:28:44 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Hi There
It requires to modify 3 files.

1. Edit file scripts/inc/_tree.asp
and delete line 12
Code:
oTree.addFolder("M1_1", "M1", "<% = myTObj.getTerm(3) %>", "server.gif", "../conn/dsnless.asp", "Content");


2. Edit file scripts/inc/_tree_con.asp
and delete line 20
Code:
oTree.addFolder("M1_1", "M1", "<% = myTObj.getTerm(3) %>", "server.gif", "../conn/dsnless.asp", "Content");


3. Edit file scripts/conn/default.asp
and delete line 15
Code:
<LI><A CLASS="contentLink" HREF="../conn/dsnless.asp"><% = myTObj.getTerm(3) %></A></LI>


4. (Optional) You can delete the file scripts/conn/dsnless.asp

sfactor
Posted: Thursday, September 06, 2007 8:05:07 AM
Rank: Newbie
Groups: Member

Joined: 9/6/2007
Posts: 3
Points: 0
Location: Novosibirsk, Russia
Worked for me, thanks a lot!

However, I can't establish connection with my database: I need to provide correct values of mla_cfg_networklibrary and mla_cfg_provider. Where can I set default values for these parameters?
elian
Posted: Thursday, September 06, 2007 8:31:15 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Hummm... i'm not sure to understand.

Network protocol and provider values can only be defined when using DSN-less connection. If you choose to use DSN, then you need to specify these both values while creating the DSN in your Windows DSN console.

Feel free to contact me by email (support@mylittletools.net) or by MSN (support@mylittletools.net) if you need more info

Thanks
sfactor
Posted: Thursday, September 06, 2007 9:28:24 AM
Rank: Newbie
Groups: Member

Joined: 9/6/2007
Posts: 3
Points: 0
Location: Novosibirsk, Russia
Sorry, I didn't make clear for myself what DSN actually is, everything is okay now.

Thanks for your help!
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.