Code to connect SQL Server 7.0 to Visual Basic 6.0

Special Ops Security

Get the code to connect SQL Server version 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?

This code can be used for the connection:

Public adoconn as ADODB.Connection

Step 2 of 2:

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

This was first published in December 2007

Finding the right problem for SQL Server 2014's in-memory OLTP

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Pricing out the new Windows Azure SQL Database

Related Q&A; from Steven Andres

Creating a login in SQL Server 2000 Enterprise Manager

Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."continue reading

Creating a SQL Server user authentication schema

Learn how to create a SQL Server user authentication schema having password and tracked data changes requirements and how it involves Windows ...continue reading

Could a join of encrypted SQL Server data have a problem?

When encrypting SQL tables that have joins in SQL Server 2000, learn about possible problems that may arise with different data values in those ...continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

How to evaluate and select the right BI analytics tool

Expert Rick Sherman has advice for organizations trying to settle on BI analytics tools: Figure out which features are must-haves...

Nate Silver lays out data-driven business strategy

A lack of standards and best practices can hold back businesses from becoming more data-driven, says Nate Silver, founder and ...

HP Vertica users put limits on using Hadoop for analytics

Hadoop is one of the most popular big data technologies. But when it comes to predictive modeling and data visualization, its ...

SearchDataCenter

ITSM tools no silver bullet for data center service delivery

ITSM tools can simplify and streamline the service delivery process, but don't forget the critical steps that also must be taken ...

Shape mobility plans with the COBIT 5 framework

The COBIT 5 framework helps IT organizations bring online new enterprise platforms like mobility without compromising data ...

Network bottleneck looms when data center storage improves

The high-IOPS, low-latency potential of SSDs moves bottlenecks to the network. SDN offers provisioning adjustments to avoid any ...

SearchDataManagement

Alteryx software targets Amazon big data

The latest Alteryx analytics engine gets enterprises close to Amazon big data, with nods to spreadsheet aficionados and R ...

Evaluating SQL-on-Hadoop tools? Start with the use case

In a Q&A;, Clarity Solution Group CTO Tripp Smith says to base SQL-on-Hadoop software decisions on actual workloads. Some Hadoop ...

IBM pushes MPP engine to boost cloud database services line

IBM has added massively parallel processing and R language support to its dashDB software -- important steps for a data warehouse...

SearchAWS

Docker deployment can work wonders for test and dev

While it might not be a fit in every scenario, AWS support for popular Docker containers can save application developers some ...

Azure or AWS? A cloud database comparison

AWS offers a multitude of database services, but Microsoft Azure has several options worth considering for a savvy multi-cloud ...

Meet the family of AWS EC2 instance types

AWS EC2 instance types offer an array of options for compute power. Get to know the nine types of Elastic Compute Cloud instances...

SearchOracle

Data sovereignty inspires Oracle action in Canada

Oracle built a new data center in Canada to address data residency and data sovereignty concerns of the country's public sector ...

SolarWinds Database Performance Analyzer gets MySQL support

The latest version of SolarWinds Database Performance Analyzer works with MySQL, giving users of both Oracle and MySQL a common ...

How to make sense of Oracle licenses for VMware environments

Oracle licenses are a tricky subject and Oracle licensing for VMware environments doubly so. Find out about the important ...

SearchContentManagement

Location data adds context for Web personalization

Location technologies can provide another layer of context for serving up Web personalization, but it may require updating ...

Experts highlight potholes in the Office 365 roadmap

Office 365 provides new options for lightweight collaboration, but experts at SPTechCon Boston said some features aren't ready ...

SharePoint 2016 beta is solid, but don't expect fireworks

SharePoint 2016 beta makes some solid improvements for the user experience, but feels more like an update than a major new ...

SearchWindowsServer

Use a PowerShell script to force logoff an RDP session

When end users remain logged in to an RDP session, it consumes valuable resources. Use this PowerShell script to force users to ...

Office, IE bugs get sprayed with Patch Tuesday fixes

The bad news: Microsoft had to issue Patch Tuesday fixes for Office and IE. The good news: no patches for Windows 10 or Adobe ...

With Azure Key Vault, cloud security no longer up in air

Admins with an Azure subscription can use Azure Key Vault to protect and encrypt keys and data. Here's how to set it up with ...

Dig Deeper

E-Handbook

Related Q&A; from Steven Andres

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: