Creating database user and connecting with it

I want to create two users for my MY SQL database.

One will be for the general public, which will allow whomever to perform SELECT queries only i.e. view the data.

The other user will be for admin purposes and will allow for SELECT UPDATE INSERT etc.

I am confused though as having created users for the public within the database area called users itself, I have had no joy.

The same goes for when I 'create a login'. Which of these should I be using for connection to using my connection string as follows?

DB.Open "Provider=MSDASQL;" & _
"Driver={SQL Server};" & _
"Server=GREEN_DRAGON;" & _
"Database=archantInsight;" & _
"Uid=jobPublic;" & _
"Pwd=password"

I can perform queries on the database with query analyser, so i know the server is running correctly. The error I get is as follows:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'jobPublic'.
/ArchantInsight/ssi/open_con.asp, line 9


Line 9 being the line above beginning "DB.Open".

Any help much appreciated!

P

This might help...

Your connection string looks correct. Anyway, seems like the user doesn't have access to your database. Go to your database, and right-click on "Users". Then on the right-hand pane, right-click and select "New User". Associate jobPublic with that database.

Hope this helps.