Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    114

    Re: Server Connection

    Hi Datamiser

    can you help me with code what it should be

    Thanks
  2. Replies
    4
    Views
    114

    [RESOLVED] Server Connection

    hi

    I have written the below code in MDI form . If network is dowm then sytem hangs for 15 seconds when the below code is trying to check connection to server . Is it possible that system should...
  3. Replies
    1
    Views
    147

    [RESOLVED] 2 connections

    Hi

    I have created 2 connections . One is for localhost & second is for server . I am using Sql server .

    What will be the state of server connection is system gets disconnected from network....
  4. Replies
    2
    Views
    116

    [RESOLVED] Connection Test

    Hi

    Below is my test connection . I want if it is successful it should return .T. else
    .F.

    Public Sub ConnectionTest()
    Set cnn2 = New ADODB.Connection
    On Error GoTo errhandler
    ...
  5. Replies
    2
    Views
    96

    Re: Connection to Server

    Hi szlamany

    It is taking more time if connection is failed , if it is connected then it is fast . How i can improve connection speed . It is taking more than 1 minute to give connection error...
  6. Thread: Localhost

    by Jagjit
    Replies
    0
    Views
    59

    Localhost

    Hi

    I want if connection to server fails then cnn2 should become localhost

    cnn2 is to connect to server

    If cnn2.State Then cnn2.Close
    cnn2.Open "Driver=SQL Server;Server=" & SvrName &...
  7. Replies
    2
    Views
    96

    Connection to Server

    Hi

    To connect to server below is the code . If due to some reasons server is down it takes a long time to give error message . I am using Sql Server 2008R2

    cnn2 is to connect to server

    If...
  8. Replies
    1
    Views
    65

    Connection To Server

    Hi

    To connect to server below is the code . If due to some reasons server is down it takes a long time to give error message

    cnn2 is to connect to server

    If cnn2.State Then cnn2.Close...
  9. Thread: StatusBar

    by Jagjit
    Replies
    2
    Views
    65

    StatusBar

    Hi

    I am looping through records , i want at run-time in 2 panels of StatusBar it should show Total No Of Records in one Panel & in Second Panel the record no of record which is being processed...
  10. Replies
    6
    Views
    175

    Connection with server

    Hi

    I want if connection with server is o.k then it should do some task i.e Insert statement else it should give message.

    If cnn2.State Then cnn2.Close
    ...
  11. Replies
    8
    Views
    209

    Re: Stored Procedure

    Dear szlamany

    O.k don't waste your time . i will send you the code

    Thanks
  12. Replies
    8
    Views
    209

    Re: Stored Procedure

    Hi

    I am using Sql Server 2008

    Thanks
  13. Replies
    8
    Views
    209

    Stored Procedure

    Hi

    I have stored procedure for insert . I want if record is successfully inserted or not it should display message in form.

    Thanks
  14. Replies
    10
    Views
    307

    Re: Server Time

    Hi

    Thanks dilettante
  15. Replies
    10
    Views
    307

    Re: Server Time

    Hi

    This is also not working , it gives error Type Mismatch
    I tried Servertime as date & string variable.

    ServerTime = cnn1.Execute("SELECT CONVERT(VARCHAR,getdate(),108)")

    Thanks
  16. Replies
    10
    Views
    307

    Re: Server Time

    Hi DataMiser

    But this is not working

    ServerDate = cnn1.Execute("Select GETDATE()")(0)
    ServerTime = Format(ServerDate, "h:mm:ss tt")

    Thanks
  17. Replies
    10
    Views
    307

    Re: Server Time

    Hi

    It may be date but i want time only

    Thanks
  18. Replies
    10
    Views
    307

    [RESOLVED] Server Time

    Hi

    i want to get only server time through stored procedure in visual basic 6

    Thanks
  19. Thread: Time Part

    by Jagjit
    Replies
    1
    Views
    81

    Time Part

    Hi

    What is wrong in the below code , i have written in module .Problem is in second line

    ServerDate = cnn1.Execute("Select GETDATE()")(0)
    ServerTime = Format(ServerDate, "h:mm:ss...
  20. Thread: DateTime field

    by Jagjit
    Replies
    0
    Views
    134

    DateTime field

    Hi

    I created 1 field Datetime in sql server 2008 R2 . I display in crystal reports to display Time it shows O.K . When i change datetime field to Time(0) in sql then time is not shown in Crystal...
  21. Replies
    1
    Views
    126

    [RESOLVED] Time Field

    Hi

    I have one field Time(0) in sql 2008 R2 . If time is 7:29 (IST) in ms-access it shows same 7:29:35 PM but in sql it stores as 19:29 . Why is it so . Secondly this does not show AM/PM in...
  22. Thread: DateTime Field

    by Jagjit
    Replies
    1
    Views
    79

    DateTime Field

    Hi

    System Time is 7:05 PM when i store in MS-Access it shows like 7:05:35 PM , but in SQL it saves as 19:05:13.0000000 . Why is it so . I want in sql also it shows like MS-Access

    Regional...
  23. Thread: DateTime field

    by Jagjit
    Replies
    2
    Views
    151

    DateTime field

    Hi

    I have datetime field in sql . I am using SQL server 2008 R2 . I have 1 dtpicker field , format is 2-dtptime . In Sql Database it does not store AM/PM .

    In VB textbox it displays AM/PM...
  24. Replies
    2
    Views
    100

    error - string is required

    Hi

    This is the string

    str = "select transactionno,tdate,tarewt,taredt,taretime,grosswt,grossdt,grosstime,netwt,grossshiftdate,tareshiftdate,grossusercode,tareshiftcode,grossshiftcode from...
  25. Thread: No Of records

    by Jagjit
    Replies
    3
    Views
    160

    Re: No Of records

    hi Arnoutdv

    you are right

    thanks
  26. Thread: Date Format

    by Jagjit
    Replies
    2
    Views
    142

    Date Format

    Hi

    I am using Sql Server 2008 R2 . Regional Setting of server is MM/dd/yyyy.
    str = "select count(*) from temp where adate='" & (sdate) & "'"
    rs.Open str, con1, adOpenDynamic,...
  27. Thread: No Of records

    by Jagjit
    Replies
    3
    Views
    160

    No Of records

    hi

    I am using Sql Database . I count no of days for a particular date to generate Series

    str = "select count(*) from temp where adate='" & CDate(tmpdate) & "'"

    If for a particular day i...
  28. Replies
    3
    Views
    125

    Re: Stored Procedure

    Hi Techgnome

    Yes , but how i will receive this value in Vb

    Thanks
  29. Replies
    3
    Views
    125

    Stored Procedure

    Hi

    How we can get SQL Server Date using Getdate() through Stored Procedure in Visual Basic 6

    Thanks
  30. Thread: Date

    by Jagjit
    Replies
    4
    Views
    147

    Re: Date

    Hi

    This function is SQl , how it will work in VB6 .

    Thanks
  31. Thread: Email

    by Jagjit
    Replies
    4
    Views
    142

    Email

    Hi

    Is it possible to send email with attachment

    Thanks
  32. Thread: Date

    by Jagjit
    Replies
    4
    Views
    147

    Date

    Hi

    I am using SQL Database stored on the server . I want when user runs program on client machine it should show the Date according to server , not Client system's Date . How this can be done....
  33. Replies
    1
    Views
    183

    [RESOLVED] SQL Database Backup

    Hi

    I have written the below code to take Backup but it is not working . Secondly i want to return a value if it is successfully executed.

    Create PROCEDURE [dbo].[Sp_Backup]
    -- Add the...
  34. Thread: Date field

    by Jagjit
    Replies
    2
    Views
    122

    Date field

    Hi

    I have datetime field in database . I am using SQL . I want to display only time part hh/mm/ss & AM/PM.

    Thanks
  35. Replies
    1
    Views
    122

    Connection String

    Hi

    I have written the below string for connection with sql
    cnn1.Open "Driver=SQL Server;Server=" & ServerName & ";Database=" & "WEIGHBRIDGE" & ";uid=" & uid & ";pwd=" & pwd & ";"

    uid =...
  36. Replies
    2
    Views
    161

    Stored Procedure should return value

    Hi

    I want that if stored procedure is executed successful it should return a value

    Vb Code is this

    confind.Open "Driver=SQL Server;Server=" & ServerName & ";Database=" &...
  37. Replies
    3
    Views
    174

    Regional Date Format

    Hi

    I want when my program should run it should check that Regional Date settings are in MM/dd/yyyy format. Is it possible

    Thanks
  38. Replies
    3
    Views
    200

    [RESOLVED] Cdate function

    Hi

    In Insert statement if i write Cdate(dtpicker1.value) or dtpicker1.value will there be difference or not. I am using Sql Server 2008 R2

    Thanks
  39. Replies
    2
    Views
    149

    Database Connection

    Hi

    I have written the below Sql connection for SQL

    cnn1.Open "Driver=SQL Server;Server=" & ServerName & ";Database=" & "TEMP" & ";uid=" & uid & ";pwd=" & pwd & ";"

    I want...
  40. Thread: Sql Backup

    by Jagjit
    Replies
    1
    Views
    96

    Sql Backup

    Hi

    How i can create Sql Backup using Visual Basic 6 without stopping Sql Services.

    Thanks
Results 1 to 40 of 344
Page 1 of 9 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.