Data Type Mismatch

[Guest]

Hi, somebody please help me .........I am getting an error returned as
"Data type mismatch" when I try to insert from an Sql server 2000 stored
procedure to a .DBF file.....I try to insert for exemple:

'01/01/2006' into dbf file...and he doesn't work
'01-01-2006' into dbf file...and he doesn't work
'01.01.2006' into dbf file...and he doesn't work

how is the corect format....or what is the source from my problem?

if I renounce to this......the insert is corect .....this variable is the
only who is "datetime" format....the rest who is "varchar" or "numeric" works
fine.....

 

[Louwsma]

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Louwsma]

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Louwsma]

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Louwsma]

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Guest]

yes I try but he doesn't work

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Guest]

yes I try but he doesn't work

Dio,

You could try placing # around the date. So then it would be
#01-01-2006# instead of '01-01-2006'.

E.

Dio schreef:

 

[Louwsma]

Have you linked the .dbf file and the stored procedure in Access as a
linked table? And are you inserting values via a query in Access or via
SQL server?

Dio schreef:

 

[Louwsma]

Have you linked the .dbf file and the stored procedure in Access as a
linked table? And are you inserting values via a query in Access or via
SQL server?

Dio schreef:

 

[Guest]

yes I linked the .dbf file in access to see the rows in the table....to check
the rows.....to see if the insert is OK.....but I create an INSERT INTO with
VB.NET from a stored procedures from SQL server 2000

 

[Guest]

yes I linked the .dbf file in access to see the rows in the table....to check
the rows.....to see if the insert is OK.....but I create an INSERT INTO with
VB.NET from a stored procedures from SQL server 2000