SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Active X ADO
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mfemenel
Professor Frink

USA
1421 Posts

Posted - 07/18/2001 :  16:03:07  Show Profile  Visit mfemenel's Homepage  Reply with Quote
Anyone have some sample of using ADO in an Active X script.

Mike F

mfemenel
Professor Frink

USA
1421 Posts

Posted - 07/18/2001 :  16:33:05  Show Profile  Visit mfemenel's Homepage  Reply with Quote
Never mind. I have the beginnings of it now. Couldn't get a handle on it at first see example below:


Function Main()
Dim commperiod
dim adors

ConnectString="uid=;pwd=;database=midsouth;Server=ipaddresshere;NETWORK=DBMSSOCN;Driver={SQL Server}"
set adoconn=CreateObject("adodb.connection")
adoconn.open(connectstring)
set adors=CreateObject("adodb.recordset")
adoRS.Open "select commperiod from configuration", ConnectString, 3
msgbox adors("CommPeriod")

Main = DTSTaskExecResult_Success



End Function


Mike F
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000