Connect To sqlServer Database Problem

[SGaist]

Hi,

Might be a silly question but, are you sure you have the driver QODBC availalbe.

[M4RZB4Ni]

@SGaist
silly is someone who is Rude Not SomeOne dont Khow!

[Vicky Sharma]

@SGaist
what you error caught during execution?

[M4RZB4Ni]

@Vicky-Sharma
Just Show my Message in IF CONDITION that show "fail"!
and my ODBC Drivers Already Installed.

[SGaist]

Rather than fail you should print the content of QSqlDatabase::lastError.

[M4RZB4Ni]

@SGaist
@Vicky-Sharma
Thanks
this is my Error
http://8pic.ir/images/kab0zjxk7ytw9yao2rxe.png
What i must do Exactly ?

[SGaist]

As silly as it may sound, fix the problem described by the message. Either your server is not accessible e.g. doesn't run or you can't access it because of missing credentials.

[hskoglund]

Hi, also to add to @SGaist, don't use Named Pipes for the connection (they're kind of ancient) instead you could try something simple like:
QString dsn="DRIVER=SQL Server;Server=127.0.0.1; Database=Test;Trusted_Connection=Yes";

[M4RZB4Ni]

@hskoglund
Thanks
i Replaced that ip But Showed Me This Message
ERROR
Sql Server

[hskoglund]

Aha, ok, then instead try specify your name and password:
QString dsn="DRIVER=SQL Server;Server=LocalHost;Database=Test;uid=Doctor Corpartion;pwd=MyPassword";

note: also I changed from 127.0.0.1 to LocalHost (it's the same)

EDIT: forgot to say: also try with username/password for your SQL Server, usually the username is sa

[M4RZB4Ni]

@hskoglund
Thank You So much man
My Problem Solved!