dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Dec 8, 1999

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


DSN-Less with ADO

Question:
When I try to implement the code that is in MSDN, I receive Run-time error '446' Object doesn't support named arguments.
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset

Const ConnectString = "uid=myname;pwd=mypw;driver={SQL Server};" & _
 "server=myserver;database=pubs;dsn=''"

Private Sub Form_Load()
   With cn
      ' Establish DSN-less connection
      .ConnectString = ConnectString
      .ConnectionTimeout = 10
      .Open
   End With
 
It fails on the ConnectString. How can I correct this problem?

Answer:
You can't create the objects using the New keyword outside of a subroutine. Either move the variable declarations (cn and rs) within the Form_Load event handler, or use this code:

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date