Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2006
    Posts
    4

    Unanswered: URGENT: Windows x64, SQL 2005, ODBC - Setting default provider for a System DSN

    In Windows Server 2003 SP1 (x86) with Sql Server 2000 I could use the following connectionstring no problem
    DSN=Hello;

    Now I am using Windows Server 2003 x64 and SQL 2005 and I get this error:
    Provider is not specified and there is no designated default provider.

    If i try Provider=MSDASQL;DSN=Hello; i get
    Provider cannot be found. It may not be properly installed.

    for DSNless this works fine:
    Provider=sqloledb;driver={sql server};server=(local);database=Hello;uid=sa;pwd=p wd;

    but i am forced to use DSN as it is in a closed source application which uses set DSNs (the idea there being that you can change the connections how you like in ODBC)

    This means that i need the ODBC provider name that will work in here: Provider=...;DSN=Hello;

    and then to use whatever works in there as the "default provider" but i cannot find any information anywhere on how to do this!

    please reply ASAP!
    Last edited by ghell; 01-06-06 at 16:44.

  2. #2
    Join Date
    Jan 2006
    Posts
    4
    U have ODBC provider?

  3. #3
    Join Date
    Jan 2006
    Posts
    4
    i have no idea, not if there isnt one installed by default on sql server 2005 and windows server 2003 standard x64 edition

    i also wouldnt know where to get one, i dont really want to use a weird little one that nobody has ever heard of etc

  4. #4
    Join Date
    Jan 2006
    Posts
    4
    kk il try find out

  5. #5
    Join Date
    Jan 2006
    Posts
    4
    http://www.microsoft.com/downloads/d...DisplayLang=en

    this myb it

    http://www.datadirect.com/download/index.ssp

    or u can buy it at ^ side just go a lil back

    http://dev.mysql.com/get/Downloads/M...rror.anlx.net/ <<<link to dl it

    found quiet a few dno if that what ur lookin for
    Last edited by Trig; 01-06-06 at 16:58.

  6. #6
    Join Date
    Jan 2006
    Posts
    4
    not using mysql

    tried datadirect 6 months ago, first time i tried to migrate to x64 and it was useless expensive crap

    .net bolt on thing says works with microsoft sql odbc (which is what i need) .. also needs to be x64 version (not x86 or ia64)

  7. #7
    Join Date
    Jan 2006
    Posts
    4
    whops hugh corrected me it is sql not jet searchin sec=.=
    Last edited by Trig; 01-06-06 at 17:51.

  8. #8
    Join Date
    Jan 2006
    Posts
    4
    the actual application i am running has a windows 2000 compatibility mode apparently and that seems to work, but i dont know how anything else can use system dsn still..
    Last edited by ghell; 01-11-06 at 09:21.

Posting Permissions

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