Re: Connection String to Connect a VB 6 Application to SQL Server 2005
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 26 Sep 2006 06:54:52 -0400
behmag@xxxxxxxxx wrote:
Hello everyone,Please describe symptoms without using generic phrases like "not working" or
thank you for reading.
I have a VB 6 application that uses a connection string to connect to
a
SQL Server 2000 Database. something like this
cst = "Provider=SQLOLEDB.1;" & _
"Data Source=192.168.1.100;" & _
"Initial Catalog=databasename;" & _
"User Id=UserLoginName;" & _
"Password=UserPassword"
I use ADO, I have the lates MDAC installed. also the Microsoft SQL
Server 2005 Native Client.
My question here is : What's the equivalent Connection string to
connect my application to a SQL Server 2005 Database.
I tried :
"Provider=SQLNCLI;Server=ServerName;Database=pubs;UID=myUsername;PWD=myPassword;"
without success.
"without success".
Given the lack of symptom description, all we can do is guess. So, my first
guess is that you have not enabled the TCP/IP network library on your SQL
Server. See http://msdn2.microsoft.com/en-us/library/ms189083.aspx
You can still use the SQLOLEDB provider: you just won't see any of the new
functionality provided by 2005: MARS, etc. If you don't need the new
functionality, you can consider using SQLOLEDB.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Follow-Ups:
- References:
- Prev by Date: Connection String to Connect a VB 6 Application to SQL Server 2005
- Next by Date: Re: Updating column property on table gives error
- Previous by thread: Connection String to Connect a VB 6 Application to SQL Server 2005
- Next by thread: Re: Connection String to Connect a VB 6 Application to SQL Server 2005
- Index(es):
Relevant Pages
|
|
