Ars Technica

SQL Server to Access via an ODBC connection, help?

I know nothing about databases. I am not a database guy. Databases are as foreign to me as wins are for the Colorado Rockies. That being said, here we go...<BR><BR>We have a computer running Microsoft ...
Houston Chronicle

How to Establish an ODBC Connection to the SQL Database

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to the ...
Redmond Magazine

Write .NET Code in SQL Server

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...
Computerworld

How to create SQL Server connection strings in Visual Studio

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...
Computerworld

How to fetch a file from FTP and import into SQL Server automatically

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...
Ars Technica

VBA: Connection string results in "External table is not in the expected format"

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the most ...