[OTP] VB6 and ms SQL 2005 DATETIME

Question

Morning,
            Could'nt find a post / site that has addressed this issue and I would be very surprised if I'm the first to find this.

I am currently having an issue passing a parameter via a stored procedure in vb6 to SQL 2005 that is requiring a datetime format.

VB6 supports these separatly i.e. DATE, TIME were as VB.Net etc. support this as DATETIME.

Is there any way I can get the date into the SQL 2005 database, not fused about the time part as this would help being stored as 00:00:00.

What I've tried so far is:

strDate = Format(strDate, "yyyy-mm-dd 00:00:00")

but when passing through it details parameter not supported:

.Parameters.Append .CreateParameter("dteDate", adDate, adParamInput, , dteDate)

Any idea's?

Many thanks,

Dan

Answer 1

These forums are for VB.NET and there are better places to find answers for older versions of VB. Maybe the

VB6 newgroups - http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.vb.general.discussion&lang=en&cr=US

Or perhaps the VB6 resource center
http://msdn.microsoft.com/vbrun/

or  perhaps www.vbcity.com may be useful places to search for answers on VB6 related questions.

Hopefully this helps.