Configure Auto DSN

[code83z]

Hey!
i want to configure AUTO DSN with the help of regedit or by using som line of code in my program or by using any 3rd Party Application.
am workin with VB6 and Access.

i dont want to configure the DSN mannualy while depolying. i want that my application do this job for me itself.
lemme know if somone give me basic to advance idea. abt "how can i do this."

ThanxXx! in Advance!
Best Regards
Bilal Ahmed

[willakawill]

The code you are looking for is most likely here

[code83z]

The code you are looking for is most likely here

ThanxXx! but i hv found the way Xactly i want to create Auto DSN
by using below Registry Entries in installation wizard.
or
we can use this by saving it as Registry File Format.
-------------------------------------------------------------------------------------------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC]
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"DBQ"="C:\\XYZ.mdb"
"DriverId"=dword:00000019
"FIL"="MS Access;"
"SafeTransactions"=dword:00000000
"UID"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC\Engi nes]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC\Engi nes\Jet]
"ImplicitCommitSync"=""
"MaxBufferSize"=dword:00000800
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"ABC"="Microsoft Access Driver (*.mdb)"
-------------------------------------------------------------------------------------------------------------


Regards
BilazZz Bajwa

[hariharanmca]

ThanxXx! but i hv found the way Xactly i want to create Auto DSN
by using below Registry Entries in installation wizard.
or
we can use this by saving it as Registry File Format.
-------------------------------------------------------------------------------------------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC]
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"DBQ"="C:\\XYZ.mdb"
"DriverId"=dword:00000019
"FIL"="MS Access;"
"SafeTransactions"=dword:00000000
"UID"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC\Engi nes]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABC\Engi nes\Jet]
"ImplicitCommitSync"=""
"MaxBufferSize"=dword:00000800
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"ABC"="Microsoft Access Driver (*.mdb)"
-------------------------------------------------------------------------------------------------------------


Regards
BilazZz Bajwa

If u use RDO control

then

Public Sub AutoDSN()
    Dim en As RDO.rdoEnvironment
    Dim cnTest As RDO.rdoConnection
    Dim strAttribs As String
    strAttribs = "defaultdir=" & App.Path & " " _
    & Chr$(13) & " OemToAnsi=No " & Chr$(13) & " DBQ= " & App.Path & "\" & DatabaseName & ".mdb"
    RDO.rdoEngine.rdoRegisterDataSource "<DSN Name>", _
    "Microsoft Access Driver (*.mdb)", True, strAttribs
End Sub

this will make your way simple...