Re: A mindboggingly basic question
From: Graham Shaw (Graham_at_somewhere.com)
Date: 07/27/04
- Next message: Jay Patel: "XML Bulk Load"
- Previous message: Graham Shaw: "Re: For XML -> ADO Recordset"
- In reply to: Siobhan Perricone: "Re: A mindboggingly basic question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 20:11:10 GMT
Hi Siobhan
If you already have a connection object open then just do
set oCmd.ActiveConnection=YourConnectionObjectName
instead of the connection string
as for isql just go into BOL click on the search tab and type 'isql utility'
in the text box and hit "list topics", it should come up ranked about number
9 ;o)
Graham
"Siobhan Perricone" <siobhan.perricone@nostatespam.vt.us> wrote in message
news:asfcg0hebo7pjs29sdnd3n8u19bv541qde@4ax.com...
> On Mon, 26 Jul 2004 17:44:31 GMT, "Graham Shaw" <Graham@somewhere.com>
> wrote:
>
> >Yes the unknown type is the bit about referencing in VB goto
> >Project/References on the menu and scroll down to Microsoft XML, v4.0 (if
> >you only have v3.0 then select that but change the Set oDom = New
> >DOMDocument40 to Set oDom = New DOMDocument30. For the ADO follow the
same
> >procedure and select "Microsoft ActiveX Data Objects 2.X Library" where X
is
> >prefereably 6 or above although 5 will work with what I gave you.
>
> Ok, I have those things set, and it's giving me an error I wouldn't
> have expected. It says:
>
> Runtime error '-2147467259 (80004005)':
> [DBNETLIB] [ConnectionOpen(Connect()).] SQL Server does not exist or
> access denied.
>
> I would have thought that since I'm running this from a Db that has a
> connection to the server set up it'd run.
>
> I haven't looked for an explantion of the error yet (clicking help
> basically says "automation error" but nothing else). But I'm starting
> with looking at the ActiveConnection line. Just posting here in case
> you know off the top of your head what might cause this. :)
>
> >Another alternative would be to look in BOL for the command line version
of
> >the query analyser iql that can output its results to a file.
>
> I've tried looking for this, but I'm embarassed to say that I'm not
> certain how to use it. BOL is great about giving details on command
> syntax, but not great on methods of applying the commands. *sigh* I
> know, I need a class...
>
> >"Siobhan Perricone" <siobhan.perricone@nostatespam.vt.us> wrote in
message
> >news:f5cag05sstqbuam2cggtbermgu0urqq8gs@4ax.com...
> >> On Sun, 25 Jul 2004 19:26:39 GMT, "Graham Shaw" <Graham@somewhere.com>
> >> wrote:
> >>
> >> Hi Graham,
> >>
> >> Thanks so much for responding. :)
> >>
> >> >Not sure what you're VB is like but assuming you can read it then the
> >> >following would save the results of a stored procedure 'SQL_First' to
a
> >> >result file
> >>
> >> I'm not great. I came into Db programming from being a super user,
> >> rather than coming at it from actual training in languages. So I'm
> >> trying to work my way through what you've so kindly provided. I'm not
> >> sure I understand everything you've put in here, but I'm able to grok
> >> a fair amount from context.
> >>
> >> >Sub SaveXml()
> >> >Dim oCmd As Command
> >> >Dim oPrm As Parameter
> >> >Dim oDom As IXMLDOMDocument2
> >>
> >> When I compile this, it pops up an "User-defined type not defined"
> >> error at the last line of this block. I've never done a "user-defined
> >> type" before. :) Is this something I should set up somewhere?
> >>
> >> Or would this part of your post:
> >>
> >> >{The project would need to reference ADO and msxml4.dll )
> >>
> >> Be the explanation for that? If so, I'm not sure what to do with that
> >> information.
> >>
> >> One thing I'm wondering now, is there a command I can put at the end
> >> of my stored procedure in SQL that'll just run it and pop it out to a
> >> file? I have been trying to find such, but I suspect I'm not looking
> >> for the right syntax in books online.
> >>
> >> I don't think I really have to have this in an MS Access Db...
> >> *ponder*
> >>
> >> --
> >> Siobhan Perricone
> >> Systems Developer
> >> Vermont Agency of Natural Resources
> >> (my comments are my own, not my employer's)
> >
>
>
> --
> Siobhan Perricone
> Systems Developer
> Vermont Agency of Natural Resources
> (my comments are my own, not my employer's)
- Next message: Jay Patel: "XML Bulk Load"
- Previous message: Graham Shaw: "Re: For XML -> ADO Recordset"
- In reply to: Siobhan Perricone: "Re: A mindboggingly basic question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
