Hi
I am install MSDE 2000 using SQL authentication in windows XP. After that install SQL server client tools then Database will automatically open in that client tools without providing user name/ password.
How can I stop it?
thanks in advance
maii
Hi there,
I am using VC++ front-end and SQL 2000 Backend. Sometime I faced the following
Error while executes SQL statement.
“Communication Link Failure.”
How can I solved the problem
Thanks
maii
Hi there,
following code had some problem while using Double data type
if i use currency data type it OK
Private Sub Command1_Click()
Dim a As Double
Dim b As Double
a = 4911399.08
a = a + 446192.58
a = a + 73490.23
b = 5431081.89
If a <> b Then
MsgBox...
Hi there,
I am facing following runtime error while delete some rows from Table ABC
Run-time error ‘-2147467259(80004005)’:
[Microsoft][ODBC SQL Server Driver][SQL Server] I/O error (bad page ID) detected during read at offset 0x0000000077a000 in file ‘C:\Program Files\Microsoft SQL...
Hi there,
I have developed a module for print continues sheet
Printer.CurrentX = 100
Printer.CurrentY = 200
Printer.Print “Text1”
Printer.CurrentX = 200
Printer.CurrentY = 300
Printer.Print “Text2”
Printer.EndDoc
But after print the doc all paper eject by printer. Is there way to stop it? I...
Hi,
I am creating a login Dialog using ASP.NET and VB.NET.
when login user for second time user name and password display in history list.
How can I remove User Name and password history from a Login dialog?
Thanks in Advance
maii
Hi there,
I need a VB function like as below
If user entered A-001 then next number will be generate like below
A-002
A-003
A-004
A-005
If user entered 0001 then next number will be generate like below
0002
0003
0004
0005
If user entered X05P then next number will be generate like below...
I have following sample table
Item Qty Date Running Qty
A 1 01-01-2005 1
A 2 01-02-2005 2
A -1 01-02-2005 2
A 3 01-03-2005 5
Need a trigger which update running Qty using sum of Qty based on Date and Item
I have build SQL query using OR operator
Such as
SELECT COMPNAYNAME FROM CUSTOMERS WHERE (CUSTOMERID =
‘AAAAA’)
OR (CUSTOMERID = ‘BBBBB’).............
It has been fail when I add more then 180 OR operators.
Are there any limitation and alternate solutions?
Thanks in advance
maii
Hi,
Is there any way to formatnumber in VB likes 12,34,56,789.00, I have changed regional settings but its format like 123,456,789.00.
Thanks in Adv
maii
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.