 | |
RE: Max parameters
Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet
 |
| | Thread Tools | Search this Thread | Display Modes |
#1
 
| |||
| |||
|
RE: Max parameters -
08-07-2003
, 11:20 AM
|
From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz Subject: Max parameters Date: Thu, 7 Aug 2003 12:43:46 +1200 Lines: 5 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2896 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet We are trying to do an insert to a RDB table with 145 columns and we get an error. Is there a limit on the number of parameters you can have in a query and what is it? |
#2
| |||
| |||
|
|
Off hand I do not know what the limit might be (and 145 would be a strange number anyway, if it was 255 or 64 or something like that maybe). It Could |
Quote:
|
(You did not mention the database you are using) is this an Insert or Update Query? Are you using a Stored Proc? Do you have a primary Key for the |
Quote:
|
query? Is this a Single table or across multiple table? Do you happen to have a small sample code project that reproduces the problem? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz Subject: Max parameters Date: Thu, 7 Aug 2003 12:43:46 +1200 Lines: 5 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2896 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet We are trying to do an insert to a RDB table with 145 columns and we get an error. Is there a limit on the number of parameters you can have in a query and what is it? |
#3
| |||
| |||
|
|
What is the error you are seeing returned? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz References: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl 1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: Max parameters Date: Fri, 8 Aug 2003 08:30:47 +1200 Lines: 59 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <ed9hKLSXDHA.2200 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2902 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet It a simple insert query into a table with 145 columns. The database is Oracle RDB on OpenVMS. The driver is the latest from Oracle, v 3.0.2.6. No, I don't have a sample. The same code works fine with Microsoft.Data.Odbc or the old version 2 ODBC driver. "Scot Rose [MSFT]" <scotr (AT) online (DOT) microsoft.com> wrote in message news:1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl... Off hand I do not know what the limit might be (and 145 would be a strange number anyway, if it was 255 or 64 or something like that maybe). It Could be a limitation of your driver (You did not mention the database you are using) is this an Insert or Update Query? Are you using a Stored Proc? Do you have a primary Key for the table and is it included in the query? Is this a Single table or across multiple table? Do you happen to have a small sample code project that reproduces the problem? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz Subject: Max parameters Date: Thu, 7 Aug 2003 12:43:46 +1200 Lines: 5 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2896 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet We are trying to do an insert to a RDB table with 145 columns and we get an error. Is there a limit on the number of parameters you can have in a query and what is it? |
#4
| |||
| |||
|
|
From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz References: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl> <1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl> <ed9hKLSXDHA.2200 (AT) TK2MSFTNGP09 (DOT) phx.gbl o0kfILTXDHA.2116 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: Max parameters Date: Tue, 12 Aug 2003 08:23:30 +1200 Lines: 116 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <ulxqvZEYDHA.2524 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2910 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet This is not helpful - I've already done all the searching I can. Can we start again? All I want to know is if there is a physical limit on the number of parameters that can be specified in a query - either within the ODBC.Net provider or in ODBC drivers spec. "Scot Rose [MSFT]" <scotr (AT) online (DOT) microsoft.com> wrote in message news  0kfILTXDHA.2116 (AT) cpmsftngxa06 (DOT) phx.gbl...What is the error you are seeing returned? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz References: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl 1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: Max parameters Date: Fri, 8 Aug 2003 08:30:47 +1200 Lines: 59 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <ed9hKLSXDHA.2200 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2902 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet It a simple insert query into a table with 145 columns. The database is Oracle RDB on OpenVMS. The driver is the latest from Oracle, v 3.0.2.6. No, I don't have a sample. The same code works fine with Microsoft.Data.Odbc or the old version 2 ODBC driver. "Scot Rose [MSFT]" <scotr (AT) online (DOT) microsoft.com> wrote in message news:1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl... Off hand I do not know what the limit might be (and 145 would be a strange number anyway, if it was 255 or 64 or something like that maybe). It Could be a limitation of your driver (You did not mention the database you are using) is this an Insert or Update Query? Are you using a Stored Proc? Do you have a primary Key for the table and is it included in the query? Is this a Single table or across multiple table? Do you happen to have a small sample code project that reproduces the problem? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz Subject: Max parameters Date: Thu, 7 Aug 2003 12:43:46 +1200 Lines: 5 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2896 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet We are trying to do an insert to a RDB table with 145 columns and we get an error. Is there a limit on the number of parameters you can have in a query and what is it? |
#5
| |||
| |||
|
|
No limit set. Definately NOT 145. What is the error you are getting, Perhaps I can find something in my sources here that might narrow it down. |
Quote:
|
message and number. Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz References: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl 1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl |
Quote:
|
o0kfILTXDHA.2116 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: Max parameters Date: Tue, 12 Aug 2003 08:23:30 +1200 Lines: 116 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <ulxqvZEYDHA.2524 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2910 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet This is not helpful - I've already done all the searching I can. Can we start again? All I want to know is if there is a physical limit on the number of parameters that can be specified in a query - either within the ODBC.Net provider or in ODBC drivers spec. "Scot Rose [MSFT]" <scotr (AT) online (DOT) microsoft.com> wrote in message news 0kfILTXDHA.2116 (AT) cpmsftngxa06 (DOT) phx.gbl...What is the error you are seeing returned? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz References: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl 1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: Max parameters Date: Fri, 8 Aug 2003 08:30:47 +1200 Lines: 59 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <ed9hKLSXDHA.2200 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2902 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet It a simple insert query into a table with 145 columns. The database is Oracle RDB on OpenVMS. The driver is the latest from Oracle, v 3.0.2.6. No, I don't have a sample. The same code works fine with Microsoft.Data.Odbc or the old version 2 ODBC driver. "Scot Rose [MSFT]" <scotr (AT) online (DOT) microsoft.com> wrote in message news:1TfGzdPXDHA.2440 (AT) cpmsftngxa06 (DOT) phx.gbl... Off hand I do not know what the limit might be (and 145 would be a strange number anyway, if it was 255 or 64 or something like that maybe). It Could be a limitation of your driver (You did not mention the database you are using) is this an Insert or Update Query? Are you using a Stored Proc? Do you have a primary Key for the table and is it included in the query? Is this a Single table or across multiple table? Do you happen to have a small sample code project that reproduces the problem? Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com Scot Rose, MCSD Microsoft Visual Basic Developer Support Email : scotr (AT) online (DOT) microsoft.com <Remove word online. from address This posting is provided "AS IS", with no warranties, and confers no rights. -------------------- From: "Peter Jones" <p.jones (AT) it (DOT) canterbury.ac.nz Subject: Max parameters Date: Thu, 7 Aug 2003 12:43:46 +1200 Lines: 5 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Message-ID: <eRXL3zHXDHA.2648 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 132.181.31.26 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2896 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet We are trying to do an insert to a RDB table with 145 columns and we get an error. Is there a limit on the number of parameters you can have in a query and what is it? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.