Hi,
I am using the following code to connect to SQL2005 database
ADODB::_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
m_pConnection->open(Server=aron1;Driver={SQL
Server};database=master;"","",NULL)
if(m_pConnection->GetState() != ADODB::adStateOpen)
done
else
error.
it works fine with SQL2005(32 bit) installed on 32 bit windows XP
machine.
but when I try to connect to SQL2005(either 32bit or 64 bit) installed
on a 64 bit XP machine.it gives me an error
Provider is not specified and there is no designated default provider.
how can I solve this issue ?
Thanks in advance.Can you connect to the said SQL2005 instance with a tool such as Query
Analyzer or osql?
Linchi
"kk.simhadri@.gmail.com" wrote:
> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>|||When you say that you are trying to connect to a 32 or 64 bit machine, you
don't say if you are trying to do this from this new machine or from the
first 32 bit machine; so it's hard to say if you have problem connecting to
a remote machine or if you have problem connecting to a 64 bit machine or
from a 64 bit environment. You don't even tell us if you are able to
connect with SSMS or SSMSE.
If you have problem connecting to a remote machine, make the usual check
about the firewall, the permissions on the remote machine and on the remote
SQL-Server and try using TCP instead of named pipes or the multi-protocol.
If you have problem connecting to a 64 bit machine, try using TCP instead of
named pipes or the multi-protocol.
If you have problem connecting from a 64 machine, first check if you are
running in the simulated 32 bit environment (WOW64) or in the 64 bit
environment. Many older protocols won't be able to run in the 64 bit
environment or to make calls to the 64 bit environment from WOW64. If it
cannot run from the 64 bit environment, use another protocol, if it cannot
make calls to the 64 bit environment, try using TCP instead of named pipes
or use another protocol such as the SQL Native Provider. More info and
troubleshooting:
http://www.connectionstrings.com/?carrier=sqlserver2005
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
http://www.datamasker.com/SSE2005_NetworkCfg.htm (connection strings for
sql providers)
For SSMSE:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<kk.simhadri@.gmail.com> wrote in message
news:1175009603.109380.73620@.y80g2000hsf.googlegroups.com...
> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>
|||Check http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx for troubleshooting connectivity issues with SQL Server 2005. Also, run SQL Server Surface Area Configuration. Click Surface Area Configuration for Services and Connections and check the Remote Connections option. Make sure you have Local and remote connections option selected