Home
Topics
Microsoft SQL Server Administration
Microsoft SQL Server Installation
Code to connect SQL Server 7.0 to Visual Basic 6.0

Ask the Expert

Code to connect SQL Server 7.0 to Visual Basic 6.0

I would like to know how to connect SQL Server 7.0 to Visual Basic 6.0. Can you please give me the codes?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

This code can be used for the connection:

Public adoconn as ADODB.Connection

Sub main()
Set adoconn = New ADODB.Connection
adoconn.ConnectionString = "Driver={SQL
Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=m
yPassword;"
adoconn.Open
End Sub

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- SQL (Structured Query Language)
- SQL Server 2012

This was first published in December 2007

There are Comments. Add yours.

Sort by: Oldest Newest

Next

View All Comments

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Selecting the right SQL-on-Hadoop engine to access big data
  
  Rick van der Lans explains why it's important to evaluate the differences in the technologies that make it possible to access Hadoop data using SQL.
- Enterprises take a long view on big data programs and purchases
  
  Health system UPMC and financial services firm CIBC are taking big data projects from pilot mode to production in stages, buying tools as they go.
- Panel: Customer experience analytics points to process problems
  
  Analyzing feedback on customer experiences can help companies ensure they treat customers like royalty, said participants in a panel discussion.
Data Center
- A data center migration checklist to mitigate risk
  
  Alleviate the pain points for IT upgrades, consolidation or mergers with this 10-step data center migration checklist.
- How to choose a micro data center in rugged locations
  
  Rather than a big container setup, the micro data center fits a whole compute system onto 23U, with fire and climate protection built in.
- Three data center questions that administrators are afraid to ask
  
  Every administrator has a question about their data center or IT roadmap that they're afraid to ask. On April 1, we answer three such questions.
Data Management
- Chief information architect: A compass for information management
  
  In a Q&A;, author William McKnight discusses the importance of building a robust information architecture -- and having the right person in the lead.
- Creating an information management strategy for high ROI, low TCO
  
  In a book excerpt, consultant William McKnight frames a plan for building and managing an effective information architecture to benefit the business.
- Big data privacy discussed at MIT workshop
  
  Big data privacy was on tap in this Talking Data podcast. A recent MIT workshop, held at the behest of President Obama, looked at encryption and more.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle JD Edwards EnterpriseOne 9.1, World upgrade challenges and tips
  
  Quest President Patrick Kys talks about upgrading to Oracle JD Edwards EnterpriseOne 9.1 and World 9.3, and comments on application customizations.
- Oracle has a new security tool for Database 12c, data redaction
  
  Oracle Database 12c adds a new security tool, data redaction. Here are step-by-step processes for using data redaction for data masking.
- Oracle 12c's heat map tool and data optimization can improve storage
  
  The heat map tool and Automatic Data Optimization features in Oracle 12c should help Oracle database shops improve data storage and compression.
Content Management
- SharePoint 2013 records management offers new compliance options
  
  SharePoint 2013 offers new options for records storage and management that can help organizations stay compliant without inhibiting the way they work.
- SharePoint records management spans new forms of content
  
  Previous versions of SharePoint records management haven't been equipped to manage new forms of enterprise content. SharePoint 2013 may change this.
- Records management enlists data analytics tools
  
  Using data analytics tools can help records managers strike a balance between information governance and business needs.
Windows Server
- Microsoft Azure continues cloud pricing game of limbo with AWS, Google
  
  Microsoft will lower its Azure cloud prices to match price cuts made by AWS and Google, but is it enough to attract new customers?
- Complete these critical steps to migrate to Windows Server 2012
  
  Make sure your enterprise follows these tips and tricks to make your Windows Server 2012 migration easier.
- Is it time for a Windows Server 2012 migration in your enterprise?
  
  As you consider migrating to Windows Server 2012, know every aspect of how the migration will affect your organization.

All Rights Reserved,Copyright 2005 - 2014, TechTarget