Recent content by JeffSabat

I'm really not sure... nway, i think i have to ask our system/network admin if he have done something in my PC... nway, tnx for the reply...

i'm using oledb....i just tried odbc and it works so i dont know what really happens with my crystal report designer why it wont connect anymore using oledb.

I'm trying to connect my report to an MSSQL server but i get an error, "Unable to connect to sql server jeffrey" (Jeffrey is the name of my computer where my sql server is running)... what could have been possibly wrong... pls help... i don't know what happen becoz i created this report in the...

in cross tab summary, group options, a row will be printed for each week, why is it that it only displays 5 days record and not 7 days? how can I make it 7 days.... pls help.....

I have an application that uses com+ architecture. The idea is, a user from a different place will connect to a MSSQL 2000 database using dial-up internet connection by setting the datasource to the ipconfig of the system where the database resides. However, it won't connect as nothing is...

anyone who knows how to pass a parameter value in the subreport... i launch the report in VB.net using reportdocument object. below is my code in lauching the report with name RptNAme with a parameter ParamName... my problem is in this report there is a subreport say SubRptName with a parameter...

tnx Dave.. a star 4 u...

this is what i want to do. I created a text wherein it will display when there are no records found so i created a formula in the suppress object button. my problem is what would be the formula. I've tried the formula 'recordnumber=0' yet the text still displays even if there are records found...

Imports System.Data.OleDb Imports System.Data Public Class clsDataAccess Inherits ServicedComponent Private Shared gstrConnectionString As String Private mobjConnAccess As OleDbConnection Public Function DARetrieve(ByVal SqlCmdTxt As String) As DataSet Dim...

tnx for the reply.. i just install vb6 and it now works...:) tnx..

i have a class that use mscomm control, however it creates an error "class is not license for use".. help,what shoud i do? Private MSCOMM1 As New MSCommLib.MSComm

Hi, ive tested my program instead of using @@identity, i use scope_identity but the problem is it returns a null value. I'm using vb.net in my development and in my program, I have a class for my database connection named clsDataAccess where it has a function insert defined as public function...

thanks for that great discussion...it really answered my question. Actually, we have the same reason with rdroske where since it is a stored procedure then no other processes can interrupt it.:P But thanks to SQL Sister... point is taken.:) i'm going to share this to my ofcmates, and i'm going...

we have just a little discussion in the ofc with @@identity vs @@ident_current... it's like this, i have a stored procedure define as.. CREATE PROCEDURE [uspInsertData] @FldName varchar(1000), @FldValue varchar(1000), @tablename varchar(100) AS declare @sql varchar(8000) set @sql = @sql +...

thank you for all your replies.:) Patrick, thanks for the solution...i haven't thought about it. probably because i'm looking for a solution that requires less code... and effort.:P thanks most to "cmmrfrds" .... it's just the answer that i wanted...:) i'm not sure though what errors...