Creating a DSN

[hellferret]

Very soon we will roll out Windows 2000, and users will still want to use their Access 2 systems.

This is all very well, but when any of our Access 2 systems are run for the first time they write the relevant DSN details to the ODBC.ini. Our users will not be set up as Administrators of their own PC's - so they do not have write access to the ODBC.ini in c:\WINNT\System.

Is there a way of adding a DSN to a PC without Administrator rights?

 

[smbure]

We have the same situation here, and I would like to also know how you hid the sensitive information (username and password, etc) from the users when the dsn is created....a dll?

hope this helps!
smbure

 

[DougP]

No because they don't want just anybody doing it.
Most program that are installed on NT need administrative privileges.
I don’t like it either but that the way it is
Being a NT network administrator its one of the biggest pains I encounter.

Have you looked at making a DSN-less connection though.

I use this a lot on SQL server 7 on the WEB.


' ---------- DSN less ------------------
Dim Conn As ADODB.Connection
Dim Rs1 As ADODB.Recordset

Set Conn = New ADODB.Connection
Set Rs1 = New ADODB.Recordset

Conn.Open "driver=SQL Server;server=smallbserver;uid=sa;pwd=;database=Universal;"
Dim SQLCode As String
SQLCode = "Select Max(PURCH_ORDER) AS LastPO From PO"

Rs1.Open SQLCode, Conn, adOpenStatic, adLockOptimistic

'Do some stuff with the recordset

Rs1.Close
Conn.Close
Set Rs1 = Nothing
Set Conn = Nothing
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[hellferret]

Cheers Ears.

But unfortunately still stuck with crappy Access 2 to run these babies - so no ADO, gonna have to remember DAO again haven't I?

Marvellous.