Odbc error

[brtwister]

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

[MentaL]

[Tsukasa]

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.

[brtwister]

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

Thank you for the patient

[brtwister]

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.

[Twilight]

mb problem in permission?
ODBC Driver Manager – Data source name not found and no default driver specified | corey gilmore's blog

[a22345875]

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

I tested

Will prompt ODBC error!

[chupeta152]

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