ODBC New DSN not working

Got a problem you cannot solve? Try here.
jlouden
Posts: 4
Joined: Wed Dec 21, 2011 9:39 am

ODBC New DSN not working

Postby jlouden » Mon Mar 06, 2017 8:34 am

I am using Installaware 18. I am trying to add an ODBC DSN in my installation. I use the NEW dialog and use an existing DSN to create the entry Then I create the install file. I delete the DSN on the system and then do the install. No DSN gets created. The log file shows that is doing the ODBC creation but nothing gets added. I also get no errors during the installation or in the Event Viewer. I tried the same things with the trail version of X6 but got the same results.

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: ODBC New DSN not working

Postby FrancescoT » Mon Mar 06, 2017 10:36 am

Dear Jlouden,

please have a look at the "ODBC sample" from the following link.
https://www.installaware.com/forums/viewtopic.php?f=2&t=6772

Hope this helps you.

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE

jlouden
Posts: 4
Joined: Wed Dec 21, 2011 9:39 am

Re: ODBC New DSN not working

Postby jlouden » Mon Mar 06, 2017 1:07 pm

When I try your example I get an error because I do not have the resource installed.

I have 4 DSNs trying to be created in my test. Here is the log file and the project.

I do not get an errors when I run it.
Attachments
My Setup.zip
(5.48 MiB) Downloaded 212 times
debug.txt
(3.61 KiB) Downloaded 235 times

jlouden
Posts: 4
Joined: Wed Dec 21, 2011 9:39 am

Re: ODBC New DSN not working

Postby jlouden » Tue Mar 07, 2017 8:16 am

I removed the two DSN entries from the sample file and installed my own. Now I get an error 6.

I have also attached the DSN creation screen. I used the Microsoft ODBC to create the DSN, referenced it in the installer. Created my installation file. Removed the ODBC reference in Windows and then ran the installation file and received the error.

John
Attachments
DSN creation.jpg
DSN creation.jpg (54.39 KiB) Viewed 3224 times
odbc error.jpg
odbc error.jpg (39.9 KiB) Viewed 3224 times

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: ODBC New DSN not working

Postby FrancescoT » Tue Mar 07, 2017 10:05 am

Dear John,

I have just updated the "ODBC sample" and this now creates an Access ODBC DSN. It works perfectly on my test machine.

Please note that as recommended with the original project, to run the sample successfully, please verify the presence of the following requirements with the target system;

- Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-US/download/details.aspx?id=13255

Hope this helps you.

Regards
Attachments
ODBCTest.rar
(2.77 MiB) Downloaded 236 times
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE


Return to “Technical Support”

Who is online

Users browsing this forum: Baidu [Spider] and 35 guests