Create DSN to access a Paradox database

Using VB, I would like to create a DSN for a paradox database. Then, I will use it to access the paradox data (creating an ADO database connection).
Does anyone have a script to create the DSN (full registry entry)?
pyeloyAsked:
Who is Participating?
 
Dave_GreeneCommented:
Then when you deploy you application, just add your .reg file into the setup and your users DSN will be created by the setup program  :)

Cheers
0
 
Dave_GreeneCommented:
Why don't you just use a .reg file

Copy this to a file called "para.reg"  then double click it..  and your DSN has been created.  Modify as needed

<FILE START>

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ParaDox]
"Driver"="C:\\WINNT\\System32\\odbcjt32.dll"
"Description"="New DSN"
"DriverId"=dword:0000021a
"FIL"="Paradox 5.X;"
"SafeTransactions"=dword:00000000
"UID"="C01395"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ParaDox\Engines]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ParaDox\Engines\Paradox]
"CollatingSequence"="ASCII"
"ImplicitCommitSync"=""
"PageTimeout"=dword:00000258
"ParadoxNetPath"="C:\\WINNT\\System32"
"ParadoxNetStyle"="4.x"
"ParadoxUserName"="C01395"
"Threads"=dword:00000003
"UserCommitSync"="Yes"

<FILE END>

Here is a DSN-Less Connection too...
oConn.Open "Driver={Microsoft Paradox Driver (*.db)};" & _
                   "DriverID=538;" & _
                   "Fil=Paradox 5.X;" & _
                   "DefaultDir=c:\dbpath\;" & _
                   "Dbq=c:\dbpath\;" & _
                   "CollatingSequence=ASCII;"

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.