Database

veon cheng wrote:

I wanted to display the main category of the Juice which is beverage. No matter how hard i tried, i can't display the Main category in access.

r_mohd wrote:

if i remove the "User Instance=True" from the above connection string it gives me following error:

Microsoft SQL Server 2005 Express Edition (SQL Server Express) supports a new feature, the user instance, which is only available when using the .NET Framework Data Provider for SQL Server (SqlClient). A user instance is a separate instance of the SQL Server Express Database Engine that is generated by a parent instance. User instances allow users who are not administrators on their local computers to attach and connect to SQL Server Express databases. Each instance runs under the security context of the individual user, on a one-instance-per-user basis.

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

r_mohd wrote:

I am trying to connect db file from a pen drive.

r_mohd wrote:

i have deleted mssqlexpress folder form the location:

r_mohd wrote:

Connection string: " Data Source='" & (SqlServerName) & "';AttachDbFilename=" & driveName & "dbfolder\dbname2.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

r_mohd wrote:

and data file and log file lying on pen drive.

leone wrote:

I use it at home but i wonder if i can use it from anywhere by reaching the db over internet.

leone wrote:

i can replace my db with sql server.

KUNWAR999 wrote:

Can someone help me in this please.. ??

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

xp_startsmtp is a system procedure that starts a mail session for a specified email address by connecting to an SMTP server. This connection can time out. Therefore, it is recommended that you call xp_startsmtp just before executing xp_sendmail.

If you specify smtp_auth_username and smtp_auth_password, and the server does not support the SMTP authentication capability, error code 104 is returned.

Virus scanners can affect xp_startsmtp, causing it to return error code 100. For McAfee VirusScan version 8.0.0 and later, settings for preventing mass mailing of email worms also prevent xp_sendmail from executing properly. If your virus scanning software allows you to specify processes that can bypass the mass mailing protections, specify dbeng12.exe and dbsrv12.exe. For example, with McAfee VirusScan you can prevent mass mailing by adding these two processes to the list of Excluded Processes in the Properties area.

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

WITH Dates
(
    EntryDate,
    EmployeeNumber,
    Status,
    Days,
    EmployeeCode,
    EmployeeName,
    DeptName,
    JobName,
    HOD,
    Supervisor
)
AS
(
    SELECT
        a.[DATE],
        a.EmployeeID,
        a.Status,
        1,a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
    FROM
        tblEmployeeAttendance1 a

    WHERE
        a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O') AND datepart(dw,a.[Date]) NOT IN (1,7)
    -- RECURSIVE
    UNION ALL

    SELECT
        a.[DATE],
        a.EmployeeID,
        a.Status,
        CASE WHEN (a.Status = Parent.Status) THEN Parent.Days + 1 ELSE 1 END,
        a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
    FROM
        tblEmployeeAttendance1 a
    INNER JOIN
        Dates parent
    ON
        datediff(day, a.[DATE], DateAdd(day, 1, parent.EntryDate)) = 0
    AND
        a.EmployeeID = parent.EmployeeNumber  where a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O') AND datepart(dw,a.[Date]) NOT IN (1,7)
)
SELECT * FROM Dates where days>=2 order by EmployeeNumber, EntryDate