Access rights in SQL Server 2005 users
Hello,I'm using Ms SQL Server 2005. I'm connecting server via ADO.I have a question about access rights. Let me tell this with an example.Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3.I want to create a SQL user which will have all righst on TBL_1 and TBL_2....
View Answer
| May 11 2008 7:49 PM GMT
| asked by
DetayMan
SQL Server 2005, SQL Server security, ADO
Query error when using application role with ADO connection
I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...
View Answer
| May 7 2008 3:24 PM GMT
| asked by
SQL Server Ask the Experts
ERROR MESSAGE, Application development, ADO
What more do I need to do to get instant client working with IIS?
I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string:sqlplus myid/mypassword@//server:port/svcI have also been able to make a DSN file that connects, and have been able to connect with Visual Basic.I HAVE NOT been...
Answer Question
| Apr 10 2008 2:37 PM GMT
| asked by
OracleATE
Oracle 10g, IIS, SQL
Logon automation
I have several programs that where written in vb6 that are now required to be automated through a scheduler. It has been a while since I coded in vb6 and need to know a way to get access to the current logged on users credentials to pass on to a database loggon. the Oracle database is NOT set up to...
View Answer
| Jan 4 2008 2:31 PM GMT
| asked by
Blowerycolumbus
VB6, Programming Languages, Logon
