Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql Native Client Error

Author  Topic 

MaxxSql
Starting Member

1 Post

Posted - 2007-09-05 : 08:46:20
I'm new in this forum and I 'm Italian, so my English won't be perfect!

If i want to connect to my SQL Server database in prompt i type:

"osql -U sa" and then i type the password.
So, I get an error that says:

"[Sql Native Client] Provider Via: Impossible to find the specified module.
[Sql Native Client] Access timeout expired
[Sql Native Client] An error occured during the attempt to estabilish a connection to the server. During the connection to SQL Server this error may be caused by pre-defined settings that don't ......"


How i can solve this problem?
Who can help me?
Thank you!!

Maxx

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-05 : 10:40:13
Which edition of SQL Server are you using? VIA is not supported in standard edition.



Future guru in the making.
Go to Top of Page

jhnegrao
Yak Posting Veteran

81 Posts

Posted - 2007-09-05 : 15:40:17
- you need to check the version of OSQL and SQL SErver. ]
- are there any firewall between SQL SErver and the machine you are trying to stablish a connection?
- Have you checked the Client sequence protocols? And which protocols are enabled?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-05 : 21:58:11
Use -s option to specify sql instance to connect to.
Go to Top of Page
   

- Advertisement -