ODBC DSN Headaches

[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?

[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

[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~

[FrancescoT]

Dear User,

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

Regards

[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~

[FrancescoT]

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

Regards

[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

[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.

[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