Advertisement

02.23.2008 at 11:06PM PST, ID: 23188129
[x]
Attachment Details

Connection string for SQL server 2008

Asked by NigelKW in SQL Server 2008, SQL Query Syntax

Tags:

I have developed a system with a front of Access 2003 with visual basic code accessing data on SQL server 2000 (enterprise).
I am in the process of migrating to Access 2007 and SQL server 2008.
What changes do I have to make to the connection string? Start Free Trial 
1:
2:
3:
4:
5:
6:
7:

Set cnn = New ADODB.Connection
   cnn.Open "Provider=Microsoft.Access.OLEDB.10.0;" & _
         "Persist Security Info=False;" & _
         "Data Source=Phact-PC;" & _
         "Integrated Security=SSPI;" & _
         "Initial Catalog=IMEX_HQ;" & _
         "Data Provider=SQLOLEDB.1"
[+][-]02.24.2008 at 12:31AM PST, ID: 20969215

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 03:27AM PST, ID: 20969555

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 05:38AM PST, ID: 20969808

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 07:31AM PST, ID: 20970180

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 01:37PM PST, ID: 20971534

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 02:38PM PST, ID: 20971759

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.25.2008 at 04:01AM PST, ID: 20974488

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.25.2008 at 05:00AM PST, ID: 20974801

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2008, SQL Query Syntax
Tags: Visual Basic
Sign Up Now!
Solution Provided By: emoreau
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628