ODBC DSN Headaches
ODBC DSN Headaches
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?
-
- Site Admin
- Posts: 5361
- Joined: Sun Aug 22, 2010 4:28 am
Re: ODBC DSN Headaches
Your topic has been moved to Technical support forum.
Please try this:
Regards
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
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
Re: ODBC DSN Headaches
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~
~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~
-
- Site Admin
- Posts: 5361
- Joined: Sun Aug 22, 2010 4:28 am
Re: ODBC DSN Headaches
Dear User,
Verify the the SERVER NAME you are using and add the DATABASE entry to your settings.
Regards
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
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
Re: ODBC DSN Headaches
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~
~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~
-
- Site Admin
- Posts: 5361
- Joined: Sun Aug 22, 2010 4:28 am
Re: ODBC DSN Headaches
Let me prepare a test environment and I will be back to you as soon as possible.
Regards
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
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
-
- Site Admin
- Posts: 5361
- Joined: Sun Aug 22, 2010 4:28 am
Re: ODBC DSN Headaches
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
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
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
Re: ODBC DSN Headaches
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.
-
- Site Admin
- Posts: 5361
- Joined: Sun Aug 22, 2010 4:28 am
Re: ODBC DSN Headaches
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
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
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
Who is online
Users browsing this forum: No registered users and 49 guests