March 17, 2012 at 10:38 pm
My application uses ADO connection component to connect to sql server (x64). Its a default instance (which means it uses computer name as the instance name). When I try and connect from another machine (windows 7 x32) I get 'provider not installed' error. I tought ADO was already a part of Windows 7 system so how comes the error ? The machine I am trying to connect from has no Office installed. Must I install Microsoft Access Database Engine 2010 Redistributable or what ?
March 18, 2012 at 11:31 am
Perhaps you could post the connection string in use (minus usernames and passwords), as well as details on anything else in use (such as ODBC DSN's, if you're using them)?
March 19, 2012 at 8:05 am
Provider=SQLNCLI11.1;Integrated Security="";Persist Security Info=False;User ID=sa;Initial Catalog=MYDATABASE;Data Source=MY-PC;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MY-PC;Initial File Name="";Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False;Application Intent=READWRITE;
March 19, 2012 at 8:28 am
Do you have the SQL Native Client 11.1 installed, which is the provider specified?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply