ODBC DSN Headaches

Got a problem you cannot solve? Try here.
mfishman
Posts: 11
Joined: Fri May 04, 2012 11:56 am

ODBC DSN Headaches

Postby mfishman » Fri May 04, 2012 4:20 pm

I'm installing a system DSN for SQL Server and though I finally stopped getting keyword-value pair errors (in case anyone else has been suffering through this, it seems you can no longer specify UID, PWD, or LastUser parameters), InstallAware 2012 is not creating my DSN. Any suggestions?

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

Re: ODBC DSN Headaches

Postby FrancescoT » Mon May 07, 2012 12:50 pm

Your topic has been moved to Technical support forum.

Please try this:

Code: Select all

~InstallAware Clipboard Data~
~Set Variable~
~{D0EAECBB-0FF4-409A-8A5B-A42EDEA5B136}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~FALSE~
~Create ODBC DSN~
~{76D079DB-5F9F-4DBB-8AEE-E9E84CD31E7C}~
~MyDns Test~
~SQL Server Native Client 10.0~
~TRUE~
~Server=.\SQLEXPRESS$NEWLINE$Database=master$NEWLINE$Trusted_Connection=Yes~
~Set Variable~
~{30CBBB4D-D54D-4B0D-B228-EA9D5F926885}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~TRUE~


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

mfishman
Posts: 11
Joined: Fri May 04, 2012 11:56 am

Re: ODBC DSN Headaches

Postby mfishman » Tue Jul 31, 2012 10:04 am

Yes, that works but this doesn't.
~InstallAware Clipboard Data~
~Set Variable~
~{3F9D32E2-6A24-42A9-B7FC-67CBFC9797ED}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~FALSE~
~Create ODBC DSN~
~{B4501FEA-5845-4928-BD76-263AD2FDA8C3}~
~NASPlant2~
~SQL Server Native Client 10.0~
~TRUE~
~Server=[DSNSQL]$NEWLINE$QuotedId=No$NEWLINE$AnsiNPW=No$NEWLINE$LastUser=[SQLUSER]$NEWLINE$AutoTranslate=No$NEWLINE$~
~Set Variable~
~{F82C598B-2ADC-4275-876A-303E1B23F514}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~TRUE~

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

Re: ODBC DSN Headaches

Postby FrancescoT » Tue Jul 31, 2012 10:47 am

Dear User,

Verify the the SERVER NAME you are using and add the DATABASE entry to your settings.

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

mfishman
Posts: 11
Joined: Fri May 04, 2012 11:56 am

Re: ODBC DSN Headaches

Postby mfishman » Tue Jul 31, 2012 11:26 am

Server verified, database added - still no joy - see below:
~InstallAware Clipboard Data~
~Set Variable~
~{3F9D32E2-6A24-42A9-B7FC-67CBFC9797ED}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~FALSE~
~Create ODBC DSN~
~{B4501FEA-5845-4928-BD76-263AD2FDA8C3}~
~NASPlant2~
~SQL Server Native Client 10.0~
~TRUE~
~Server=[DSNSQL]$NEWLINE$Database =master$NEWLINE$QuotedId=No$NEWLINE$AnsiNPW=No$NEWLINE$LastUser=[SQLUSER]$NEWLINE$AutoTranslate=No$NEWLINE$~
~Set Variable~
~{F82C598B-2ADC-4275-876A-303E1B23F514}~
~NATIVE_ENGINE$MYAH$MYAH$FALSE~
~TRUE~

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

Re: ODBC DSN Headaches

Postby FrancescoT » Tue Jul 31, 2012 11:54 am

Let me prepare a test environment and I will be back to you as soon as possible.

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

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

Re: ODBC DSN Headaches

Postby FrancescoT » Wed Aug 01, 2012 9:07 am

Dear Mfishman,

the problem seems caused by LastUser Parameter.
I'm still checking it but I do not know actually when I'll be able to tell you more.

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

ohoover
Posts: 3
Joined: Tue Jun 12, 2012 7:40 am

Re: ODBC DSN Headaches

Postby ohoover » Wed Aug 01, 2012 2:18 pm

Hi Francesco. I also had the same problem yesterday. I had to remove the "LastUser" parameter as well in order for it to work. From what I read, having "LastUser" can be a security issue so that could be why it is not valid.

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

Re: ODBC DSN Headaches

Postby FrancescoT » Thu Aug 02, 2012 3:09 am

Many thanks!

I found the same.
Seems that the use of "LastUser" parameter is not allowed anymore.

Let me see if I am able to find more detailed info about.

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


Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 46 guests