ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ADODB.Connection not displaying when defining a variable (https://www.excelbanter.com/excel-programming/394237-adodb-connection-not-displaying-when-defining-variable.html)

ToniS

ADODB.Connection not displaying when defining a variable
 
I am trying to use VBA to connect to SQL Server, I am currently running
Office 2003 when I type in Dim Conn as the list of objects appear, but I do
not see the ADODB with in the list

Any suggestions would be greatly appreciated
Tonis

Tim Williams

ADODB.Connection not displaying when defining a variable
 
Have you set a reference to ADO in the VBE ?

Tim

"ToniS" wrote in message
...
I am trying to use VBA to connect to SQL Server, I am currently running
Office 2003 when I type in Dim Conn as the list of objects appear, but I
do
not see the ADODB with in the list

Any suggestions would be greatly appreciated
Tonis





All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com