Solved

Create DSN to access a Paradox database

Posted on 2001-07-20
2
475 Views
Last Modified: 2010-05-18
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)?
0
Comment
Question by:pyeloy
  • 2
2 Comments
 
LVL 8

Expert Comment

by:Dave_Greene
Comment Utility
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
 
LVL 8

Accepted Solution

by:
Dave_Greene earned 50 total points
Comment Utility
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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem to the message 13 63
Excel object stays open 19 65
Sending a email via excel using vba 6 55
Excel - Save a copy of work book 13 79
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now