New call-to-action
Results 1 to 20 of 20

Thread: Need help with (localDB)

  1. #1
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Need help with (localDB)

    Hi Everyone,

    I was looking forward to using the MS SQL localDB packaged with AlphaAnywhere 4.3.
    Unfortunately, after I got the connection string figured out, I was unable to connect to it.
    Does anyone know what needs to be done to fix this problem ?

    Thanks much,

    Gregg

    nojoy.PNG

  2. #2
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: Need help with (localDB)

    even though i don't have version 12, first change the name of the server from localdb to the name of the computer\servername, then try again.
    see if it works.

    eg: GANDHIG\SQLEXPRESS
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  3. #3
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    Open Microsoft SQL Server Management Studio... and the "Server name:" used to connect to your instance is the name you'll use in the AlphaDAO Connection "Server" field. Since you can name your instance anything you want, then you need to get that specific name.

    SQLServerName.PNG

  4. #4
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Re: Need help with (localDB)

    I appreciate the responses, but I think I'm missing something.

    The feature I'm trying to use is described here :https://www.alphasoftware.com/docume...%20LocalDB.xml

  5. #5
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    Sorry... missed that part. There may still exist an issue for Alpha/LocalDB

    Alpha_LocalDB.PNG

    The instance is installed... as I can use SSMS to connect to (localdb)\AlphaAnywhere.

    Now... I do have SQLServer2016 and SQLServer2014 installed... but they don't seem to affect anything to do with (localdb)\AlphaAnywhere... that I can see.

    Try this... instead of setting the Version to 2016, set it to 2014 or 2012. Setting the Version to 2016 resulted in a connection error for me.

    Setting the Version to 2014 succeeded. However, there isn't a SQL Northwinds database available in (localdb)\AlphaAnywhere... if that's what you wanted as well.

  6. #6
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Re: Need help with (localDB)

    That sucks, but at least I know now I'm not completely wacky.
    I was starting to think I was doing something wrong (I currently have no sql of any kind installed on this machine)
    and I received failures trying 2014 and 2012.

  7. #7
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    I would give this a try... install SqlLocalDB yourself. I've not done this because I usually install full versions... but... what the heck.

    Go here... https://www.microsoft.com/en-us/down....aspx?id=42299

    This is SQL Server 2014... so I think Version 12 of LocalDB. It's all pretty much nuts... but there you go.

    Click Download to select the LocalDB 32BIT\SqlLocalDB.msi install. Then maybe, just maybe, the (localdb)\AlphaAnywhere Server name will work under Version 2014.

    Remember, though, that SQL Server 2016 Developer is a full version and free. It's all a pain to install... but what else have you got to do.

  8. #8
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: Need help with (localDB)

    gregg,
    the article you posted has the naming convention for the server name, did you replace the localdb with that name and try?
    when i read your connection string in the image it says (localDB)\alphaanywhere, may be that is an example they gave. if you go down the page they tell you what to replace for the alpha anywhere
    try that first.


    Version Default Server Name
    SQLLocalDB v11.0 (localdb)\v11.0
    SQLLocalDB v12.0 (localdb)\MSSQLLocalDB
    SQLLocalDB v13.0 (localdb)\MSSQLLocalDB

    edit: also is that localDB running?
    if nothing works, just like david said install 2016 sql server express it is free and i did not find it difficult. mine is express may be that, not full version.
    Last edited by GGandhi; 03-14-2017 at 05:58 AM.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  9. #9
    Member
    Real Name
    John Smith
    Join Date
    Oct 2011
    Location
    Tulip Creek
    Posts
    110

    Default Re: Need help with (localDB)

    What OS are you using? LocalDB needs 64 bit OS

  10. #10
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Re: Need help with (localDB)

    windows 10 pro 64bit

  11. #11
    Alpha Software Employee Sarah Mitchell's Avatar
    Real Name
    Sarah Mitchell
    Join Date
    Jul 2015
    Posts
    462

    Default Re: Need help with (localDB)

    Quote Originally Posted by Davidk View Post
    Sorry... missed that part. There may still exist an issue for Alpha/LocalDB

    Alpha_LocalDB.PNG

    The instance is installed... as I can use SSMS to connect to (localdb)\AlphaAnywhere.

    Now... I do have SQLServer2016 and SQLServer2014 installed... but they don't seem to affect anything to do with (localdb)\AlphaAnywhere... that I can see.

    Try this... instead of setting the Version to 2016, set it to 2014 or 2012. Setting the Version to 2016 resulted in a connection error for me.

    Setting the Version to 2014 succeeded. However, there isn't a SQL Northwinds database available in (localdb)\AlphaAnywhere... if that's what you wanted as well.
    If you don't need the ODBC Version 13 driver, uninstall it and install ODBC Version 11. ODBC Version 11 works with all versions of SQLLocalDB (2012, 2014, and 2016.)

    We are keeping tabs on Microsoft for a fix.
    Sarah Mitchell
    Documentation | Alpha Software Corporation
    Get in the know! Join us for our Weekly Webinars: TransForm Tuesday and Wednesday's Alpha Anywhere Demo and Q&A
    Connect with us: Instagram | Twitter | Facebook | LinkedIn | YouTube


  12. #12
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    Thanks Sarah.

    x64 or x86 ? Or does it matter?

  13. #13
    Alpha Software Employee Sarah Mitchell's Avatar
    Real Name
    Sarah Mitchell
    Join Date
    Jul 2015
    Posts
    462

    Default Re: Need help with (localDB)

    Quote Originally Posted by Davidk View Post
    Thanks Sarah.

    x64 or x86 ? Or does it matter?
    You should install x64 unless you're running a 32-bit operating system.
    Sarah Mitchell
    Documentation | Alpha Software Corporation
    Get in the know! Join us for our Weekly Webinars: TransForm Tuesday and Wednesday's Alpha Anywhere Demo and Q&A
    Connect with us: Instagram | Twitter | Facebook | LinkedIn | YouTube


  14. #14
    Alpha Software Employee Sarah Mitchell's Avatar
    Real Name
    Sarah Mitchell
    Join Date
    Jul 2015
    Posts
    462

    Default Re: Need help with (localDB)

    Quote Originally Posted by Davidk View Post
    Thanks Sarah.

    x64 or x86 ? Or does it matter?
    FYI: If you try to install the x86 version on a 64-bit machine, the ODBC 11 installer will give you an error message:

    Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.
    Sarah Mitchell
    Documentation | Alpha Software Corporation
    Get in the know! Join us for our Weekly Webinars: TransForm Tuesday and Wednesday's Alpha Anywhere Demo and Q&A
    Connect with us: Instagram | Twitter | Facebook | LinkedIn | YouTube


  15. #15
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    So... SqlLocalDB is installed by Alpha automatically. But, the Microsoft V13 ODBC Driver has a bug that prevents it from connecting to SqlLocalDB. So... we'd need to get to Programs and Features, find Microsoft ODBC Driver 13 for SQL Server and uninstall it. Then install Microsoft ODBC Driver 11 for SQL Server.

    Is this right Sarah? Thanks.

  16. #16
    Alpha Software Employee Sarah Mitchell's Avatar
    Real Name
    Sarah Mitchell
    Join Date
    Jul 2015
    Posts
    462

    Default Re: Need help with (localDB)

    Quote Originally Posted by Davidk View Post
    So... SqlLocalDB is installed by Alpha automatically. But, the Microsoft V13 ODBC Driver has a bug that prevents it from connecting to SqlLocalDB. So... we'd need to get to Programs and Features, find Microsoft ODBC Driver 13 for SQL Server and uninstall it. Then install Microsoft ODBC Driver 11 for SQL Server.

    Is this right Sarah? Thanks.
    Yes. We are not alone in this problem with LocalDB. Microsoft's sqlcmd.exe tool also fails (which I cannot fathom.) I periodically check on the status of this issue but there hasn't been anything from MS yet.

    If you do not need SQL Server 2016 and all it's glory as supported with ODBC 13, then yes. Uninstall the ODBC 13 driver using the "Programs and Features" tool in Windows. When the driver has been uninstalled, install ODBC 11 - which for whatever reason can also connect to 2016 versions of LocalDB (despite it being a 2014 driver?)

    Microsoft's website will prompt you for the version to download. If you are running a 64-bit OS (which most people *should* be running these days), then download the x64 installer. If you are running a 32-bit OS, download the x86 installer. If you try to install the x86 version on a 64-bit OS, the installer will refuse to install the driver.

    I do not believe Alpha Anywhere installs any ODBC driver at this time.
    Last edited by Sarah Mitchell; 03-14-2017 at 10:37 PM.
    Sarah Mitchell
    Documentation | Alpha Software Corporation
    Get in the know! Join us for our Weekly Webinars: TransForm Tuesday and Wednesday's Alpha Anywhere Demo and Q&A
    Connect with us: Instagram | Twitter | Facebook | LinkedIn | YouTube


  17. #17
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Re: Need help with (localDB)

    ugh...leave it to Microsoft to BING it up so bad that it's unusable.
    Worst case scenario is I will uninstall all things ms sql related and stick with MySQL.

    However, I really do appreciate the time and effort from everyone.

  18. #18
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,907

    Default Re: Need help with (localDB)

    It's really not that big a deal... crap happens...always has... always will. The older ODBC driver is available or a full install of free SQL Server Developer 2016.

  19. #19
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,495

    Default Re: Need help with (localDB)

    True...but if I take it off my machine, I am less likely to waste my time trying to make it work.

  20. #20
    Alpha Software Employee Sarah Mitchell's Avatar
    Real Name
    Sarah Mitchell
    Join Date
    Jul 2015
    Posts
    462

    Default Re: Need help with (localDB)

    Quote Originally Posted by madtowng View Post
    ugh...leave it to Microsoft to BING it up so bad that it's unusable.
    Worst case scenario is I will uninstall all things ms sql related and stick with MySQL.

    However, I really do appreciate the time and effort from everyone.
    SQL Server works fine with ODBC 13. The issue with the ODBC 13 driver only applies to SQLLocalDB. If you plan on using SQL Server, I recommend building the SQL Server version of the Northwind database for use in our tutorials or for use as an experimental database: https://www.alphasoftware.com/docume...20sql%20server
    Sarah Mitchell
    Documentation | Alpha Software Corporation
    Get in the know! Join us for our Weekly Webinars: TransForm Tuesday and Wednesday's Alpha Anywhere Demo and Q&A
    Connect with us: Instagram | Twitter | Facebook | LinkedIn | YouTube


Similar Threads

  1. Microsoft LocalDB with AlphaDAO
    By SNusa in forum General Questions
    Replies: 4
    Last Post: 02-23-2012, 07:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •