Page 1 of 1
ODBC DSN Headaches
Posted: Fri May 04, 2012 4:20 pm
by mfishman
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?
Re: ODBC DSN Headaches
Posted: Mon May 07, 2012 12:50 pm
by FrancescoT
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
Re: ODBC DSN Headaches
Posted: Tue Jul 31, 2012 10:04 am
by mfishman
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~
Re: ODBC DSN Headaches
Posted: Tue Jul 31, 2012 10:47 am
by FrancescoT
Dear User,
Verify the the SERVER NAME you are using and add the DATABASE entry to your settings.
Regards
Re: ODBC DSN Headaches
Posted: Tue Jul 31, 2012 11:26 am
by mfishman
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~
Re: ODBC DSN Headaches
Posted: Tue Jul 31, 2012 11:54 am
by FrancescoT
Let me prepare a test environment and I will be back to you as soon as possible.
Regards
Re: ODBC DSN Headaches
Posted: Wed Aug 01, 2012 9:07 am
by FrancescoT
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
Re: ODBC DSN Headaches
Posted: Wed Aug 01, 2012 2:18 pm
by ohoover
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.
Re: ODBC DSN Headaches
Posted: Thu Aug 02, 2012 3:09 am
by FrancescoT
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