LongText not suppoeted as output parameter
in [Programming SQL]
|
Prev: Restore database using SMO
Next: Declare in a view
From: Sylvain Lafontaine on 31 Mar 2010 20:01 SQLNCLI10 is the native client that comes with SQL-Server 2008; you can download it separately from the following page: http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en and it should work as well against SQL-Server 2005. SQLNCLI is the native client that comes with SQL-Server 2005 and if you have the later installed on your system, you shouldn't have see an error message about this missing provider. However, as you didn't provide any example of your code, we cannot exclude that you have made an error there. You can download it from: http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en Finally, if you have so much trouble with nvarchar(max), try using nText instead. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "Scott Morris" <bogus(a)bogus.com> wrote in message news:e%23teRUN0KHA.3708(a)TK2MSFTNGP02.phx.gbl... > "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <sanjay(a)microbrain.in> wrote > in message news:%23CrlUBN0KHA.6104(a)TK2MSFTNGP06.phx.gbl... >> Hi Dan, >> >> If I use provider SQLNCLI10 then it display error message provider not >> found. >> >> I tried to use SQLNCLI as a provider & ADO 2.8 but same error is coming. > > Have you tried a simple web search? > > http://www.google.com/search?q=ado+2.6+varchar%28max%29&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8 > http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic62664.aspx > http://msdn.microsoft.com/en-us/library/bb399384.aspx > > Note the last link has a specific example of this. You might also try > posting to a newsgroup specific to ADO or VB (e.g.., > microsoft.public.vb.database.ado) >
From: SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. on 1 Apr 2010 05:58 Hi Sylvin, I tried to user nText, Text, VarChar but at ADO Parameter is I don't user adLongVarChar or adLongVarWChar then it trim text upto 4000 or 8000 character. Please see my other reply for my code. Sanjay Shah "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message news:OSMS05S0KHA.752(a)TK2MSFTNGP04.phx.gbl... > SQLNCLI10 is the native client that comes with SQL-Server 2008; you can > download it separately from the following page: > http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en > and it should work as well against SQL-Server 2005. > > SQLNCLI is the native client that comes with SQL-Server 2005 and if you > have the later installed on your system, you shouldn't have see an error > message about this missing provider. However, as you didn't provide any > example of your code, we cannot exclude that you have made an error there. > You can download it from: > http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en > > Finally, if you have so much trouble with nvarchar(max), try using nText > instead. > -- > Sylvain Lafontaine, ing. > MVP - Windows Live Platform > Blog/web site: http://coding-paparazzi.sylvainlafontaine.com > Independent consultant and remote programming for Access and SQL-Server > (French) > > > "Scott Morris" <bogus(a)bogus.com> wrote in message > news:e%23teRUN0KHA.3708(a)TK2MSFTNGP02.phx.gbl... >> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <sanjay(a)microbrain.in> wrote >> in message news:%23CrlUBN0KHA.6104(a)TK2MSFTNGP06.phx.gbl... >>> Hi Dan, >>> >>> If I use provider SQLNCLI10 then it display error message provider not >>> found. >>> >>> I tried to use SQLNCLI as a provider & ADO 2.8 but same error is coming. >> >> Have you tried a simple web search? >> >> http://www.google.com/search?q=ado+2.6+varchar%28max%29&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8 >> http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic62664.aspx >> http://msdn.microsoft.com/en-us/library/bb399384.aspx >> >> Note the last link has a specific example of this. You might also try >> posting to a newsgroup specific to ADO or VB (e.g.., >> microsoft.public.vb.database.ado) >> > >
From: SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. on 1 Apr 2010 07:57 Hi Sylvain, I tried using SQL Native Client 10 & ADO 2.8 but same problem is there. Please help me. Sanjay Shah "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message news:OSMS05S0KHA.752(a)TK2MSFTNGP04.phx.gbl... > SQLNCLI10 is the native client that comes with SQL-Server 2008; you can > download it separately from the following page: > http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en > and it should work as well against SQL-Server 2005. > > SQLNCLI is the native client that comes with SQL-Server 2005 and if you > have the later installed on your system, you shouldn't have see an error > message about this missing provider. However, as you didn't provide any > example of your code, we cannot exclude that you have made an error there. > You can download it from: > http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en > > Finally, if you have so much trouble with nvarchar(max), try using nText > instead. > -- > Sylvain Lafontaine, ing. > MVP - Windows Live Platform > Blog/web site: http://coding-paparazzi.sylvainlafontaine.com > Independent consultant and remote programming for Access and SQL-Server > (French) > > > "Scott Morris" <bogus(a)bogus.com> wrote in message > news:e%23teRUN0KHA.3708(a)TK2MSFTNGP02.phx.gbl... >> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <sanjay(a)microbrain.in> wrote >> in message news:%23CrlUBN0KHA.6104(a)TK2MSFTNGP06.phx.gbl... >>> Hi Dan, >>> >>> If I use provider SQLNCLI10 then it display error message provider not >>> found. >>> >>> I tried to use SQLNCLI as a provider & ADO 2.8 but same error is coming. >> >> Have you tried a simple web search? >> >> http://www.google.com/search?q=ado+2.6+varchar%28max%29&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8 >> http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic62664.aspx >> http://msdn.microsoft.com/en-us/library/bb399384.aspx >> >> Note the last link has a specific example of this. You might also try >> posting to a newsgroup specific to ADO or VB (e.g.., >> microsoft.public.vb.database.ado) >> > >
From: Sylvain Lafontaine on 1 Apr 2010 11:49
> I tried to user nText, Text, VarChar but at ADO Parameter is I don't user > adLongVarChar or adLongVarWChar then it trim text upto 4000 or 8000 > character. I'm sorry but I absolutely don't understand what you are trying to say here. You will have to repeat your explanation but first, see my other answer. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <sanjay(a)microbrain.in> wrote in message news:u1J05IY0KHA.4420(a)TK2MSFTNGP02.phx.gbl... > Hi Sylvin, > > I tried to user nText, Text, VarChar but at ADO Parameter is I don't user > adLongVarChar or adLongVarWChar then it trim text upto 4000 or 8000 > character. > > Please see my other reply for my code. > > Sanjay Shah > > "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message > news:OSMS05S0KHA.752(a)TK2MSFTNGP04.phx.gbl... >> SQLNCLI10 is the native client that comes with SQL-Server 2008; you can >> download it separately from the following page: >> http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en >> and it should work as well against SQL-Server 2005. >> >> SQLNCLI is the native client that comes with SQL-Server 2005 and if you >> have the later installed on your system, you shouldn't have see an error >> message about this missing provider. However, as you didn't provide any >> example of your code, we cannot exclude that you have made an error >> there. You can download it from: >> http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en >> >> Finally, if you have so much trouble with nvarchar(max), try using nText >> instead. >> -- >> Sylvain Lafontaine, ing. >> MVP - Windows Live Platform >> Blog/web site: http://coding-paparazzi.sylvainlafontaine.com >> Independent consultant and remote programming for Access and SQL-Server >> (French) >> >> >> "Scott Morris" <bogus(a)bogus.com> wrote in message >> news:e%23teRUN0KHA.3708(a)TK2MSFTNGP02.phx.gbl... >>> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <sanjay(a)microbrain.in> >>> wrote in message news:%23CrlUBN0KHA.6104(a)TK2MSFTNGP06.phx.gbl... >>>> Hi Dan, >>>> >>>> If I use provider SQLNCLI10 then it display error message provider not >>>> found. >>>> >>>> I tried to use SQLNCLI as a provider & ADO 2.8 but same error is >>>> coming. >>> >>> Have you tried a simple web search? >>> >>> http://www.google.com/search?q=ado+2.6+varchar%28max%29&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8 >>> http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic62664.aspx >>> http://msdn.microsoft.com/en-us/library/bb399384.aspx >>> >>> Note the last link has a specific example of this. You might also try >>> posting to a newsgroup specific to ADO or VB (e.g.., >>> microsoft.public.vb.database.ado) >>> >> >> > > |