ODBC Connect Failure for SQL 2005

The ado connect string for SQL 2K is: strConnect = "driver={SQL
Server};server=" & ServerName & ";database= "yada yada yada".
What do I need to change to connect to SQL 2005 with the SQL Native Client?
Thanks in advance
Steve House
olorin@.tampabay.rr.comBTW, Currently, I am using VB6 to code, though I plan to use VB 2005 and
ASP.Net 2.0
"Steve House" <olorin@.tampabay.rr.com> wrote in message
news:Oze9v5UpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> The ado connect string for SQL 2K is: strConnect = "driver={SQL
> Server};server=" & ServerName & ";database= "yada yada yada".
> What do I need to change to connect to SQL 2005 with the SQL Native
> Client?
> Thanks in advance
> Steve House
> olorin@.tampabay.rr.com
>|||Hi
You should be using the OLEDB for ASP by now too.
sConn = "Provider='SQLOLEDB';Data Source='MySqlServer';Initial
Catalog='TempDB';Integrated Security='SSPI';"
{sqlserver} is the ODBC driver.
SQLOLEDB will work for SQL Server 2000 and 2005.
SQL CLI:
sConn = "Provider='SQLNCLI';Data Source='MySqlServer';Initial
Catalog='TempDB';Integrated Security='SSPI';"
SQL Server 2005 questions to
http://communities.microsoft.com/ne...lcid=us

Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve House" <olorin@.tampabay.rr.com> wrote in message
news:O86CaAVpFHA.1088@.TK2MSFTNGP14.phx.gbl...
> BTW, Currently, I am using VB6 to code, though I plan to use VB 2005 and
> ASP.Net 2.0
> "Steve House" <olorin@.tampabay.rr.com> wrote in message
> news:Oze9v5UpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||Hello,
For questions of SQL server 2005, please post at the following newsgroup:
Welcome to the Microsoft SQL Server 2005 Community Technology (CTP)
Newsgroups
<http://communities.microsoft.com/ne...sqlserver2005&s
lcid=us>
Thanks for cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

ODBC Connect Failure for SQL 2005

The ado connect string for SQL 2K is: strConnect = "driver={SQL
Server};server=" & ServerName & ";database= "yada yada yada".
What do I need to change to connect to SQL 2005 with the SQL Native Client?
Thanks in advance
Steve House
olorin@.tampabay.rr.com
BTW, Currently, I am using VB6 to code, though I plan to use VB 2005 and
ASP.Net 2.0
"Steve House" <olorin@.tampabay.rr.com> wrote in message
news:Oze9v5UpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> The ado connect string for SQL 2K is: strConnect = "driver={SQL
> Server};server=" & ServerName & ";database= "yada yada yada".
> What do I need to change to connect to SQL 2005 with the SQL Native
> Client?
> Thanks in advance
> Steve House
> olorin@.tampabay.rr.com
>
|||Hi
You should be using the OLEDB for ASP by now too.
sConn = "Provider='SQLOLEDB';Data Source='MySqlServer';Initial
Catalog='TempDB';Integrated Security='SSPI';"
{sqlserver} is the ODBC driver.
SQLOLEDB will work for SQL Server 2000 and 2005.
SQL CLI:
sConn = "Provider='SQLNCLI';Data Source='MySqlServer';Initial
Catalog='TempDB';Integrated Security='SSPI';"
SQL Server 2005 questions to
http://communities.microsoft.com/new...r2005&slcid=us
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve House" <olorin@.tampabay.rr.com> wrote in message
news:O86CaAVpFHA.1088@.TK2MSFTNGP14.phx.gbl...
> BTW, Currently, I am using VB6 to code, though I plan to use VB 2005 and
> ASP.Net 2.0
> "Steve House" <olorin@.tampabay.rr.com> wrote in message
> news:Oze9v5UpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||Hello,
For questions of SQL server 2005, please post at the following newsgroup:
Welcome to the Microsoft SQL Server 2005 Community Technology (CTP)
Newsgroups
<http://communities.microsoft.com/new...qlserver2005&s
lcid=us>
Thanks for cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.