Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Connectivity error microsfot ODBC SQL Server Driver [SQL…

Customer Question
Connectivity error microsfot ODBC...

Connectivity error microsfot ODBC SQL Server Driver [SQL Server] The conversion of a varchar data type to a datetime data type resulted in an out of range value. I get this message on an append blank command. All datetimes are either .null. or " / / 12:00 AM" in value. Any ideas?

Technician's Assistant: What's your objective for this SQL project?

Conversion of data from another system.

Technician's Assistant: Anything else you want the programmer to know before I connect you?

It is an intermittent problem, I might load 20,000 records before it happens.

Submitted: 8 months ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 1 day by:
12/17/2017
Software technician: George Sibiya, Research and Development replied 8 months ago
George Sibiya
George Sibiya, Research and Development
Category: Software
Satisfied Customers: 368
Experience: PhD in Computer Science
Verified

Hi,

Welcome to JustAnswer and thank you for utilising our services

Please post the specific part of the query which has the Convert function

Regards,

G

Ask Your Own Software Question
Customer reply replied 8 months ago
It is a Visual foxpro program. I'm added records to a table in the SQL Database that contain many date/time values. They
all appear to have a valid value in debug, some are set to " / / : :".
Software technician: George Sibiya, Research and Development replied 8 months ago

I can get an instance of foxpro running.

I'll give others a chance

Ask Your Own Software Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a software technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 803
803 Satisfied Customers
Experience: Computer Software Support specialist for more that 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

803 satisfied customers

Computer Software Support specialist for more that 10 years

Kamil Anwar

Kamil Anwar

Software Specialist

543 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Chris L.

Chris L.

Support Specialist

526 satisfied customers

Certified Software expert with over 10 years experience.

Jins M. N.

Jins M. N.

Computer Hardware Engineer

523 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

IT Miro

IT Miro

Computer Scientist

513 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

205 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
When trying to connect to a ".dbf" database in Crystal
When trying to connect to a ".dbf" database in Crystal Reports 11 I get a dialogue box asking for a Username and Password. I am unable to make connection. The creators of the software say there is no … read more
George Sibiya
George Sibiya
Research and Development
368 satisfied customers
We are getting the following error when trying to send
we are getting the following error when trying to send emails and log them in our SQL Server database. The application is written in ColdFusion. [Macromedia][SQLServer JDBC Driver]Request cannot be su… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Why does my PC randomly restart and the have a window that
why does my PC randomly restart and the have a window that says"keep the USB drive plugged in .......… read more
Bryan
Bryan
IT Consultant
8,751 satisfied customers
Im trying to find software to use on my pc to see my
Im trying to find software to use on my pc to see my security camera's. I'm only able to see live fee, not my recorded files. But on my cellphone thru NVSIP App I'm able to see live and recorded files… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Windows XP startup trouble] My XP system will not startup.
Windows XP startup trouble] My XP system will not startup. When I try to, it gives me the following message: "Windows could not start because the following file is missing or corrupt: WINDOWS\SYSTEM32… read more
Quiksilver07070
Quiksilver07070
Remote Technical Support
Associate Degree
68 satisfied customers
I have a FostexMR-8HD and am having difficulty getting both
I have a FostexMR-8HD and am having difficulty getting both tracks of a song to my PC. I have been successful with recording and overdubbing,and have been quite pleased with the final product. I have … read more
RickBrown
RickBrown
Engineer
Vocational, Technical or Trade Scho
80 satisfied customers
I have a POS windows based application with a customer data
I have a POS windows based application with a customer data entry screen. There is about 10 different fields that need to be input. I need to rekey all of our customer data back into the system and I … read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Designer deluxe 9.0.0.0After "skip labels" step, selected
Designer deluxe 9.0.0.0 After "skip labels" step, selected records do not show, do not print What to do?… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I need to install the proper version of MS SQL Express but
I need to install the proper version of MS SQL Express but there are several versions to choose from. I just selected the version that believed would work (x86 something) but received an error that th… read more
Mr.Med
Mr.Med
1,225 satisfied customers
I am running Ubuntu 12.04 on my desktop machine. Every now
I am running Ubuntu 12.04 on my desktop machine. Every now and then (getting to be more frequent), when I log in, the display will act as if it has lost connection with the computer. Screen turns blac… read more
ITguy1978
ITguy1978
102 satisfied customers
i want to learn exadata to get a job. i have a little unix
i want to learn exadata to get a job. i have a little unix exp, and i can learn quick (math major). i just installed an oracle virtualbox, then installed oracle linux. I was thinking I would install o… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I am using Crystal Reports 2008 to build a report that pulls
I am using Crystal Reports 2008 to build a report that pulls data from one table in our SQL server. We need parameters for querying by two year dates to compare both for meetings, phone calls and emai… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
when trying to install server mangement studio 2005 expres
when trying to install server mangement studio 2005 expres i get an error 1708 if i try to install the *.msi i get a message i higher version exists when there is not higher version… read more
routeranger
routeranger
Network Security Consultant
31 satisfied customers
I recently downloaded microsoft flight onto my Acer 5750G laptop
I recently downloaded microsoft flight onto my Acer 5750G laptop with i7 processor (2Ghz with turbo gives 2.9Ghz) that has 6Gb RAM and 2 Gb video RAM. I read some info on the support site and as a res… read more
Chris R.
Chris R.
Bachelor\u0027s Degree
87 satisfied customers
Suddenly it appears from one day to another instant search
Suddenly it appears from one day to another instant search in Outlook 2007 is not working, even after rebuilding index. For example, an email that I just sent, that appears in the sent folder, does no… read more
romr2009
romr2009
Bachelor's Degree
235 satisfied customers
I HAVE A NEW COMPUTER WITH MS XP. MS FLIGHT SIM WILL NOT RESPOND
I HAVE A NEW COMPUTER WITH MS XP. MS FLIGHT SIM WILL NOT RESPOND TO X & Y INPUTS FROM MY SAITEK CYBORG EVO FORCE JOYSTICK. IT RESPONDS WHEN I GO TO CALIBRATE BUT WILL NOT FLY ANY AIRPLANE. I HAVE 2 SA… read more
spoonz123
spoonz123
Company director/Engineer
City & Guilds 224
1 satisfied customers
While install Oracle 10g on windows 7, I ran into error, EM
While install Oracle 10g on windows 7, I ran into error, EM config failed due to instantiating EM config files. Keep in mind I am new to Oracle.… read more
Douglas
Douglas
SEM Specialist
163 satisfied customers
I was having issues loading ubuntu so I decided to do a new
I was having issues loading ubuntu so I decided to do a new install. the install seemed to go well, but when I did a restart, the only thing I get is a black screen and a blinky cursor at the top.… read more
Jeremy
Jeremy
1,344 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x