Re: Could not convert variant of type (Null) into type (String)

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/26/05

Next message: Brian Bushay TeamB: "Re: Interrupt a Query"
Previous message: Bas van Beek: "Re: Not enough Parameters?"
In reply to: zorba: "Re: Could not convert variant of type (Null) into type (String)"
Next in thread: lotemlotad_at_yahoo.com: "Re: Could not convert variant of type (Null) into type (String)"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 25 Feb 2005 20:56:00 -0600

>If I choose OleDB provider for SQL then I can't build ADOConnection
>String ... server doesn't exists ... probably I try to switch on

Then you will have to live with the error which is only produced when you run
out of the IDE.

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Next message: Brian Bushay TeamB: "Re: Interrupt a Query"
Previous message: Bas van Beek: "Re: Not enough Parameters?"
In reply to: zorba: "Re: Could not convert variant of type (Null) into type (String)"
Next in thread: lotemlotad_at_yahoo.com: "Re: Could not convert variant of type (Null) into type (String)"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: C# Windows Service Problem
... Note that connecting to SQL server and using DSO are ... I don't use an OLEDB provider anywhere in the program.. ... The error message refers to the OLEDB provider for DSO, ...
(microsoft.public.dotnet.languages.csharp)
Re: Insert Field Database only fails when I try to use filters
... you should be able to see the SQL it has generated by using ... because the OLEDB provider that gets the data /probably/ ... the OLEDB provider seems to require that you specify a "table alias" (which ... or even cut out the \c parameter altogether, ...
(microsoft.public.word.mailmerge.fields)
Re: C# Windows Service Problem
... Note that connecting to SQL server and using DSO are different things. ... I don't use an OLEDB provider anywhere in the program.. ... The error message refers to the OLEDB provider for DSO, that's why I said that the code you posted is not the source of the error message. ...
(microsoft.public.dotnet.languages.csharp)
Re: Need parameterized INSERT query
... Anyway, this is a .NET desktop app, connecting to a VFP7 table via ADO.NET ... the SQL statement and the parameters. ... it's starting to look like VFP's OleDb Provider doesn't support ...
(microsoft.public.fox.programmer.exchange)
Re: Insert Field Database only fails when I try to use filters
... It doesn't work because when you specify conditions and filters, ... you should be able to see the SQL it has generated by using ... because the OLEDB provider that gets the data /probably/ ...
(microsoft.public.word.mailmerge.fields)