Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 28th, 2008, 10:07 AM
Friend of Wrox
 
Join Date: Oct 2005
Posts: 124
Thanks: 0
Thanked 1 Time in 1 Post
Default Error msg: Invalid connection string attribute

I am working with VS 2005/ASPnet 2.0; but still need to work on some
old VS 2002/3 codes. The following connection coding which I tried to modify received the subject error msg.

Exactly what's wrong with the connection string?

TIA,
jeffrey

Dim conClsf As OleDbConnection
        Dim cmdMbrs As OleDbCommand
        Dim rdrMbrs As OleDbDataReader

        conClsf = New OleDbConnection( _
                 "Provider=SqlOleDb;" & "Data Source=myWebServer;" & "Initial Catalog=Northwind;" & "User Id=ME;" & "Passwrod=pwdpwdpwd;" & ";")
        conClsf.Open()
        cmdMbrs = New OleDbCommand( _
                  "select * from Employees", _
                  conClsf)
__________________
C. Jeffrey Wang
 
Old April 28th, 2008, 10:23 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

"Passwrod=pwdpwdpwd;" may be the problem..

Try "Password" ;)

Rob
http://robzyc.spaces.live.com
 
Old April 28th, 2008, 10:57 AM
Friend of Wrox
 
Join Date: Oct 2005
Posts: 124
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thank you very very much. It worked.
 
Old April 28th, 2008, 11:40 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

HTH, I know how valuable a second pair of fresh eyes can be when you have been trying to spot something like this!

Rob
http://robzyc.spaces.live.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
connection string to Oracle, Invalid Argument,err sparsh2010 Access VBA 1 February 14th, 2008 08:31 AM
Connection String error in ASP picky Classic ASP Databases 1 October 19th, 2007 07:37 AM
The BeerHouse 'Connection String Error' nesrine C# 1 March 21st, 2007 01:28 AM
Invalid Connection String Attribute rstelma Classic ASP Databases 8 July 6th, 2005 06:31 PM
Invalid ProgID attribute kimmy VB Components 1 August 4th, 2004 10:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.