Performing actions from within a database

[RobL]

Hello all,

I am currently attempting to implement a database sanitiser. I will be
performing hashing functions on every record within selected columns.

I'm currently wondering if there is any way to programmatically 'upload'
code into an Access database (to be viewed in the 'Modules' section of the
main window of an mdb in the Access application), so that I'm not having to
pull and push large volumes of data across potentially slow networks.

To summarise: I want to perform VB-style operations from 'within' the
database.
i.e. I could say from the client-side:

1.Upload some piece of code
2.Run this code against the such-and-such a column

Is this possible?

Thanks,

Rob Levy

 

[Ron Weiner]

Rob

While it may be possible to import a module into the remote (server side?)
database, any attempt to run that code from the client-side (local computer)
would have the code running on the client-side. So in the end, all of the
rows you need to examine would have to be brought back to the local computer
anyway. You are probably better off just developing your app on the
client-side in a special purpose database that you (re)point to remote
databases as required.

UNLESS

If all / any of the remote computers can be accessed via remote control
software like Terminal Services, Citrix, PC Anywhere, Etc then, you would be
able to import and run your routines right on the computer that is hosting
the database.

Ron W
www.WorksRite.com

 

[RobL]

Thanks for your good and full answer Ron.

Here's a slight twist on the original as a follow-up

Can you 'upload' a stored procedure to a SQL-Server database using ADO (or
any other VB-based method)?

Cheers,

Rob
--
Software Support Engineer
i2 Ltd.

Rob

While it may be possible to import a module into the remote (server side?)
database, any attempt to run that code from the client-side (local computer)
would have the code running on the client-side. So in the end, all of the
rows you need to examine would have to be brought back to the local computer
anyway. You are probably better off just developing your app on the
client-side in a special purpose database that you (re)point to remote
databases as required.

UNLESS

If all / any of the remote computers can be accessed via remote control
software like Terminal Services, Citrix, PC Anywhere, Etc then, you would be
able to import and run your routines right on the computer that is hosting
the database.

Ron W
www.WorksRite.com

 

[Ron Weiner]

While I have never done this I would imaging that it would not be all that
hard to do. My guess is that you would use the Execute method of the ADODB
Connection or Command objects to create the Sproc. Obviously you will need
to connect to the database with enough rights to create a Stored proc, View,
or other object.

The way I have always done this in the past was to create a Sql Script and
email it to the DB Admin, and have her/him execute it using the Sql Query
Analyzer. Seemed like a lot less work for me and I guess I am just plain
lazy. ;-)

--
Ron W
www.WorksRite.com

Thanks for your good and full answer Ron.

Here's a slight twist on the original as a follow-up

Can you 'upload' a stored procedure to a SQL-Server database using ADO (or
any other VB-based method)?

Cheers,

Rob