473,467 Members | 1,436 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

From Vb6 Date Inserting Problem In Sql Server7 Database

1 New Member
dear all friends......PLEASE HELP!!!!!!!!!

I AM NEW DEVELOPPER ON VB6 AND SQL SERVER 7, WHEN I AM GOING TO INSERT DATE TO SQL TABLE FROM VB THE DATE INSERTING
"01/01/1900" IF IM GIVING SQL WITHOUT '

IF I AM GIVING ' THEN GETTING ERROR DATE CONVERSION CHAR TO DATE TIME

IT IS URGENT PLEASE HELP!!!!!
Nov 23 '06 #1
1 1638
willakawill
1,646 Top Contributor
dear all friends......PLEASE HELP!!!!!!!!!

I AM NEW DEVELOPPER ON VB6 AND SQL SERVER 7, WHEN I AM GOING TO INSERT DATE TO SQL TABLE FROM VB THE DATE INSERTING
"01/01/1900" IF IM GIVING SQL WITHOUT '

IF I AM GIVING ' THEN GETTING ERROR DATE CONVERSION CHAR TO DATE TIME

IT IS URGENT PLEASE HELP!!!!!
Hi. 'this is for text', #this is for dates#
:)
Nov 23 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: perplexed | last post by:
How do you convert a user inputted date to a unix timestamp before insterting it into your database? I have a form, with a textfield for a date that the user inputs in the format mm-dd-yyyy and...
2
by: Robin | last post by:
I know that you would use cInt(n) to convert a string to an integer. How do you convert an integer to a string? I have a varChar field in a database that I am inserting a date field (needs to be a...
2
by: Helena | last post by:
Hello Does anyone one know the max size of a database that I can create on MS-SQL server 7. Have had any problems using databases near the max size (slow performance, etc) Thanks Helena
15
by: Khurram | last post by:
I have a problem while inserting time value in the datetime Field. I want to Insert only time value in this format (08:15:39) into the SQL Date time Field. I tried to many ways, I can extract...
6
by: ransoma22 | last post by:
I developing an application that receive SMS from a connected GSM handphone, e.g Siemens M55, Nokia 6230,etc through the data cable. The application(VB.NET) will receive the SMS automatically,...
0
by: V1RuZ | last post by:
Hi all, I'm having some trouble getting my php code to work properly. I'm submitting three different variables from a vxml form to my php. I then need the php to deposit the variables into files...
6
Cintury
by: Cintury | last post by:
Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...
0
by: mbenedict | last post by:
I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use...
0
by: veer | last post by:
Hi i installed sql server7.0 on my window XP operating system and now i want to create a server group and then register it but it alwys displays the error "SQL server doest exist or access denied...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.