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

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 your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

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)

This was first published in December 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

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

Business Analytics
- Political data, statisticians are runaway winners in presidential election
  
  You've heard of Nate Silver, but what about the guy who correctly predicted the election in June? A conversation with Emory University's Drew Linzer.
- BI architecture guide helps businesses start small but think big
  
  Building a BI architecture is no easy task, but a reference guide can answer questions when crafting a road map.
- For unwary users, social media data analysis can be an unfriendly task
  
  Organizations must take into account various obstacles when implementing social media analytics plans to ensure that they provide business value.
Data Center
- IBM's CICS Transaction Server 5.1 gears for cloud deployment
  
  Open beta of CICS Transaction Server 5.1 introduces a bevy of features to reduce planned downtime and let CICS applications function in the cloud.
- Three questions on ASHRAE standards for data centers
  
  Evolving ASHRAE standards for temperature and humidity allow data center owners to save money on power and cooling demands.
- Online community aims to cut data center energy costs, save planet
  
  Want to cut data center energy costs while saving the environment? The Green Grid and its online community aim to help.
Data Management
- New Informatica Cloud update promotes business user self-service
  
  The winter release of Informatica Cloud aims to increase business user self-service capabilities while improving data quality.
- Effective 'big data' strategy helps advertising firm attract clients
  
  Online advertising company adMarketplace uses a mix of NoSQL and SQL databases in a "big data" environment that feeds its search syndication system.
- Successful data stewardship framework needs solid plan, firm focus
  
  Stewarding data can be a tough nut to crack: lots of effort for a reward that isn't always apparent. To succeed, strong project management is needed.
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
- How to survive an Oracle audit
  
  Surviving an Oracle audit comes down to understanding what's being asked for, good software license management and preparation.
- Accessing Hyperion financial information from mobile devices
  
  Pushing Oracle Hyperion financial information to mobile devices means considering what data to push there and what kind of devices your workers have.
- Oracle Day: A mix of Oracle career day, field trip and pep rally
  
  Is going to Oracle Day worth the trip? If you're going for Oracle career networking, yes. But is the information useful?
Content Management
- Users offer mixed reactions to SharePoint, Yammer integration plans
  
  Microsoft's plan to integrate Yammer with SharePoint 2013 struck a chord with users at the annual SharePoint conference in Las Vegas.
- Planning, prep work for ECM tool rollout puts an end to content chaos
  
  Consultants and analysts say that targeted planning before ECM deployments begin helps organizations realize enterprise content management success.
- Download 2 ECM e-guides for a limited time only
  
  Download 2 ECM e-guides for a limited time only
Windows Server
- Enabling multi-server management in Windows Server 2012
  
  By enabling remote management in Windows Server 2012, Microsoft opened the door for multi-server management remotely or locally.
- Windows Server 2012, Windows 8 receive first patches
  
  Two months after general availability, Windows Server 2012 received its first Patch Tuesday fixes.
- Windows Server Failover Clustering gets boost from PowerShell cmdlets
  
  In Windows Server 2012, there are 81 new and improved failover clustering PowerShell cmdlets. Here's how to make the most of their capabilities.

All Rights Reserved,Copyright 2005 - 2012, TechTarget