DSN connection by default - Support Queries - myLittleTools Community Forum

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin for SQL Server 2000 » Support Queries » DSN connection by default

DSN connection by default

Options · View

Previous Topic · Next Topic

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:

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

myLittleTools Community Forum » myLittleAdmin for SQL Server 2000 » Support Queries » DSN connection by default

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.