|
Home > Archive > MS SQL Server ODBC > August 2005 > ODBC Connect Failure for SQL 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ODBC Connect Failure for SQL 2005
|
|
| Steve House 2005-08-20, 3:23 am |
| 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
| |
| Steve House 2005-08-20, 3:23 am |
| 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
>
| |
| Mike Epprecht \(SQL MVP\) 2005-08-20, 7:23 am |
| Hi
You should be using the OLEDB for ASP by now too.
sConn = " Provider='SQLOLEDB';
Data Source='MySqlServer'
;Initial
Catalog='TempDB';Int
egrated Security='SSPI';"
{sqlserver} is the ODBC driver.
SQLOLEDB will work for SQL Server 2000 and 2005.
SQL CLI:
sConn = " Provider='SQLNCLI';D
ata Source='MySqlServer'
;Initial
Catalog='TempDB';Int
egrated Security='SSPI';"
SQL Server 2005 questions to
http://communities.microsoft.com/ne...er2005&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...
>
>
| |
| Sophie Guo [MSFT] 2005-08-22, 3:23 am |
| 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.
|
|
|
|
|