Wednesday, August 02, 2006 10:35 AMMorning,
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)
Thursday, August 03, 2006 1:44 AM
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
or perhaps www.vbcity.com may be useful places to search for answers on VB6 related questions.
Hopefully this helps.