Locking a database from a non paying client

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Locking a database from a non paying client

Post by HansV »

The SQL Server database should not be on a computer owned or controlled by the client - the client's front end would contact it over the internet.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

By what means would the Client's FE contact it over the internet?

Mark L
3StarLounger
Posts: 331
Joined: 11 Feb 2010, 03:55
Location: Land O Lakes, FL

Re: Locking a database from a non paying client

Post by Mark L »

It would be my SQL Server or a MySQL server, sitting anywhere. Could be on a website. Ideally you'd have a Stored Procedure which returned the information, which you'd call via a PassThrough query (including the ClientID as a parameter).
Mark Liquorman
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

Thanks Mark, but i have never written a Stored Procedure.
Can a stored procedure access the web?
Where can i read up on Stored Procedures?
Would the pass through query in the Clients FE access the SQL Server stored procedure. I still am trying to understand this approach never having used Pass Through queries. Would the client's FE have a link to a SQL Server table on a server somewhere?
As you can see i have no idea about this.

Mark L
3StarLounger
Posts: 331
Joined: 11 Feb 2010, 03:55
Location: Land O Lakes, FL

Re: Locking a database from a non paying client

Post by Mark L »

Stored Procedures are in the SQL Server database. You don't actually need to use it, you can just put the SQL in the passthrough query. A passthrough query has to have the connection parameters to the SQL Server (servername, databasename, user, & password).
Mark Liquorman
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

Would you provide an example of a passthrough query with those fields please.

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Locking a database from a non paying client

Post by HansV »

I'm not sure this is going to work, but here is a description from Microsoft:
How to create an SQL pass-through query in Access
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

Thanks I will try that, i need a ODBC database on the web somewhere to test it thoug

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

Mark L wrote:A passthrough query has to have the connection parameters to the SQL Server (servername, databasename, user, & password).
Would you give me an example of a connection string that specifies Servername, Databasename etc.
I presume the servername is a unc type address?

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Locking a database from a non paying client

Post by HansV »

Here is more information about connection strings than you'll ever need: ConnectionStrings.com.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

Thanks Hans i will look at that after breakfast.
I have had a look at that and you are right, there is way more information that i need to the point it's confusing. It doesn't mention all the keywords like "Server" or "Databasename", but at least i can work on from there.
I wonder if there is a link to all the keywords that are used in connection strings.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

I have found an interesting link via google:
http://www.connectionstrings.com/Articl ... g-keywords

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Locking a database from a non paying client

Post by HansV »

That's on the same website that I mentioned.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Locking a database from a non paying client

Post by Pat »

So it is, i didn't notice that. I just went googling.

Thanks for your time Hans and enjoy the new decade.