Printable View
I have created a program which has to connect with a database through a DSN. I want to be able when I package the project to create automatically and the appropriate DSN in order to connect to the database. It could help me to give the setup program to peolpe who have no idea of how to create a DSN!
thanx!
Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece
You can solve this problem, changing the setup program of VB:
<VB Directory>\Wizards\PDWizard\Setup1\Setup1.vbp
adding at last of code a procedure that will call the OBDC Register Window, you can use the frmODBCLogon.frm (VB Template) as an example. Make an EXE file in:
<VB Directory>\Wizards\PDWizard
and use PDW to generate the CABs.
Vanclei Matheus
[email protected]
Techno Dreamer
why do you want to create a DSN when you can have DSNless connections? (conection.open "Driver={SQL Server};Server=yourserver;UID...")
What do you need the DSN for?
You can create the DSN at program start using the RegisterDatabase-DAO-Method or by using the DSNTool ActivexComponent that comes with APE (Application Performance Explorer).