Odbc error

Results 1 to 7 of 7
  1. #1
    Account Inactive brtwister is offline
    InactiveRank
    Jun 2009 Join Date
    5Posts

    sad Odbc error


    RaGEZONE Recommends

    RaGEZONE Recommends



    Hello guys, i get this error (attachment) ?
    What is going on ?
    I tried ODBC with windows auth, and user and pass..
    Don't work...

    It's 64x windows seven...

    And i tried to the 32-bits conf

    Please, help me..
    Attached Thumbnails Attached Thumbnails Sem título.jpg  
    Attached Files Attached Files
    Last edited by brtwister; 17-10-11 at 04:11 AM. Reason: more info


  2. #2
    Deny everything. Tsukasa is offline
    Indigo SubscriberRank
    Jun 2005 Join Date
    Net SlumLocation
    559Posts

    Re: Odbc error

    There's a few things you can try here.

    If you're sure you've set-up the DSN connections correctly using odbcad32, you might have the sa account disabled (correct me if I'm wrong, I think that's the standard on fresh installations of SQLsrv). Try to explicitly enable it using Management Studio and/or try to reset it's password.

    You can check whether the ODBC driver is set to Native Client and whether or not the ODBC wizard can connect to the database (during DSN setup).

    If that is indeed the case, I'd double-check the configuration of the INI files and maybe check whether or not the standard database has been set-up correctly for each DSN.

    Can't think of any other reason why it doesn't connect, otherwise.

  3. #3
    Account Inactive brtwister is offline
    InactiveRank
    Jun 2009 Join Date
    5Posts

    Re: Odbc error

    Thank you, I will try all this possibilitys.
    And i get a feedback.

    Thank you for the patient

  4. #4
    Account Inactive brtwister is offline
    InactiveRank
    Jun 2009 Join Date
    5Posts

    sad Re: Odbc error

    Tsukasa, i just tried what u said... and i took theses prints, so u can try to find out..

    The first image, as u can se, on trying to execute the 32bit, i get no server list. But i ignored and typed (local).

    The second i did as you guide shows.

    The thrith i just show that this worked.

    and the Fourth the 32bits odbc that i just started.


    I'm sure that the password is right...
    above, this is the log from ODBC:

    login 17/11/2011 22:53:43 107 1 [E_ODBC] ErrCode (IM002) ErrMsg ([Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified)
    Ur login 17/11/2011 22:53:43 107 1 [F_ODBC] CONNECT 2: Query (dbo.ProcGetServerList exec), IP (127.0.0.1), Account (sa), PW (linux321)
    101 11.17.2011 22:53:44 exec 2 ur login dbo.ProcGetServerList
    Ur login 17/11/2011 22:53:44 107 1 [E_ODBC] ErrCode (IM002) ErrMsg ([Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified)
    17/11/2011 22:53:44 101 2 ur login [E_NETUNIT] SOCKET CONNECT: (IP), Port (0)
    Ur login 17/11/2011 22:53:44 107 1 [E_ODBC] ErrCode (IM002) ErrMsg ([Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified)...


    I still with the same errors....

    I Have Windows 7 professional x64 with Sql Server 2008 x32
    And tried execute the ODBC 32bits : %WINDIR%\SysWOW64\odbcad32.exe

    Thank you for beeing partient.
    Attached Thumbnails Attached Thumbnails 01.jpg   02.png   03.png   04.png  

  5. #5
    DEV Twilight is offline
    True MemberRank
    Dec 2004 Join Date
    RussiaLocation
    720Posts
    Code:
    5765207374616E64206265747765656E207468652063616E646C6520616E642074686520737461722C206265747765656E20746865206461726B6E65737320616E6420746865206C696768742E20426162796C6F6E2035

  6. #6
    Ultimate Member a22345875 is offline
    MemberRank
    Aug 2009 Join Date
    London, UnitedLocation
    194Posts

    Re: Odbc error

    Looks like Pangya server cannot be used on a 64 bit system

    I tested

    Will prompt ODBC error!

  7. #7
    Account Inactive chupeta152 is offline
    InactiveRank
    May 2009 Join Date
    9Posts

    Re: Odbc error

    Check the settings on your server, and try again! make odbc connections




Advertisement