Read the Client Registry with SQL?

[imtheodore]

Can I read the registry of a client PC with SQL?

In other words, when a client runs a procedure it uses a value found in its own registry.

 

[wazz]

yes. look up getallsettings in vba help. other links are there too.

edit: just noticed you are asking about SQL... maybe this won't help.

 

[imtheodore]

yes. look up getallsettings in vba help. other links are there too.

edit: just noticed you are asking about SQL... maybe this won't help.

Yes I need SQL to read it for my .asp page. I know asp.net can do it...can .asp?

 

[SQL_Hell]

Why do you want to do this? sounds like a massive security hole to me.

Server server queries run on the server, so the server would have access to all clients machines registries.

A safer way would be to get the application to read the registry then parse the values to SQL SERVER. But is still very bad in terms of security, is there something else you can do rather than allow access to registries?

 

[imtheodore]

I need to link an application that will be running to a .asp page. The application that will be running lists a CurentCustomerID in the registry. I see no other way to pass that value to the SQL server,other than to read it and run a procedure pulling up all of the information.

Basically, there is an application running that cannot handle billing.
So I came up with a .asp page that will accept all of the billing tasks/materials. I cannot have the user possibly enter the wrong CustomerID, so I would like to pass it from the registry, rather than bill the wrong customer.