473,385 Members | 1,344 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Web part blues

I made a web part for Business Portal using Visual Studio. It worked fine on
my station. On the remote server, it gave me the following error message:
"Unrecoginzed configuration section 'connectionStrings'". I googled the
error message, and was told to install .NET Framework 2.0. Now Business
Portal tells me, "This page has encountered a critical error. Contact your
system administrator if this problem persists." and I'm not even navigating
to the page with the new webpart.

Thx in advance for your help.

trufaux
Nov 23 '05 #1
8 2162
It sounds like there's a syntax error in the web.config. There should be
more detail in the event log.

"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...
I made a web part for Business Portal using Visual Studio. It worked fine
on
my station. On the remote server, it gave me the following error message:
"Unrecoginzed configuration section 'connectionStrings'". I googled the
error message, and was told to install .NET Framework 2.0. Now Business
Portal tells me, "This page has encountered a critical error. Contact your
system administrator if this problem persists." and I'm not even
navigating
to the page with the new webpart.

Thx in advance for your help.

trufaux


Nov 23 '05 #2
Event log? Sorry, I'm a newbie. Could you be more specific please?

What follows is the configuration error:
*****
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section 'connectionStrings'

Source Error:
[No relevant source lines]
Source File: web.config Line: 12
*****

This is line 12 from my web.config:
*****
<add name="ePrizeAppConnectionString" connectionString="Data
Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
providerName="System.Data.SqlClient"/>
*****

Am I correct in assuming that 'Integrated Security=True' is the same as
Windows Authentication? Could this be the difference between my station and
the server?

Thanks again
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300

"Ken Cox [Microsoft MVP]" wrote:
It sounds like there's a syntax error in the web.config. There should be
more detail in the event log.

"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...
I made a web part for Business Portal using Visual Studio. It worked fine
on
my station. On the remote server, it gave me the following error message:
"Unrecoginzed configuration section 'connectionStrings'". I googled the
error message, and was told to install .NET Framework 2.0. Now Business
Portal tells me, "This page has encountered a critical error. Contact your
system administrator if this problem persists." and I'm not even
navigating
to the page with the new webpart.

Thx in advance for your help.

trufaux


Nov 23 '05 #3
re:
Version:1.1.4322.2300
Parser Error Message: Unrecognized configuration section 'connectionStrings'
<connectionStrings> is not part of the 1.1 Framework configuration.
It's part of the 2.0 .Net Framework configuration.

If you're using 1.1, use <appSettings>, instead.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com... Event log? Sorry, I'm a newbie. Could you be more specific please? What follows is the configuration error:
*****
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section 'connectionStrings'

Source Error:
[No relevant source lines]
Source File: web.config Line: 12
*****

This is line 12 from my web.config:
*****
<add name="ePrizeAppConnectionString" connectionString="Data
Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
providerName="System.Data.SqlClient"/>
*****

Am I correct in assuming that 'Integrated Security=True' is the same as
Windows Authentication? Could this be the difference between my station and
the server?

Thanks again
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300

"Ken Cox [Microsoft MVP]" wrote:
It sounds like there's a syntax error in the web.config. There should be
more detail in the event log.

"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...
>I made a web part for Business Portal using Visual Studio. It worked fine
>on
> my station. On the remote server, it gave me the following error message:
> "Unrecoginzed configuration section 'connectionStrings'". I googled the
> error message, and was told to install .NET Framework 2.0. Now Business
> Portal tells me, "This page has encountered a critical error. Contact your
> system administrator if this problem persists." and I'm not even
> navigating
> to the page with the new webpart.
>
> Thx in advance for your help.
>
> trufaux


Nov 23 '05 #4
Adding to my previous reply, you need to change
the .Net Framework version that your application targets.

Use the ASP.NET tab in the Internet Service Manager
to change the Asp.Net version for your app to 2.0.


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com...
Event log? Sorry, I'm a newbie. Could you be more specific please?

What follows is the configuration error:
*****
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section 'connectionStrings'

Source Error:
[No relevant source lines]
Source File: web.config Line: 12
*****

This is line 12 from my web.config:
*****
<add name="ePrizeAppConnectionString" connectionString="Data
Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
providerName="System.Data.SqlClient"/>
*****

Am I correct in assuming that 'Integrated Security=True' is the same as
Windows Authentication? Could this be the difference between my station and
the server?

Thanks again
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300

"Ken Cox [Microsoft MVP]" wrote:
It sounds like there's a syntax error in the web.config. There should be
more detail in the event log.

"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...
>I made a web part for Business Portal using Visual Studio. It worked fine
>on
> my station. On the remote server, it gave me the following error message:
> "Unrecoginzed configuration section 'connectionStrings'". I googled the
> error message, and was told to install .NET Framework 2.0. Now Business
> Portal tells me, "This page has encountered a critical error. Contact your
> system administrator if this problem persists." and I'm not even
> navigating
> to the page with the new webpart.
>
> Thx in advance for your help.
>
> trufaux


Nov 23 '05 #5
Do you mean Internet Information Services Manager? Do you mean to set
ASP.NET v2.0.50727 to "Allowed" under Web Services Extensions? That was done.

Thanks

"Juan T. Llibre" wrote:
Adding to my previous reply, you need to change
the .Net Framework version that your application targets.

Use the ASP.NET tab in the Internet Service Manager
to change the Asp.Net version for your app to 2.0.


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com...
Event log? Sorry, I'm a newbie. Could you be more specific please?

What follows is the configuration error:
*****
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section 'connectionStrings'

Source Error:
[No relevant source lines]
Source File: web.config Line: 12
*****

This is line 12 from my web.config:
*****
<add name="ePrizeAppConnectionString" connectionString="Data
Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
providerName="System.Data.SqlClient"/>
*****

Am I correct in assuming that 'Integrated Security=True' is the same as
Windows Authentication? Could this be the difference between my station and
the server?

Thanks again
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300

"Ken Cox [Microsoft MVP]" wrote:
It sounds like there's a syntax error in the web.config. There should be
more detail in the event log.

"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...
>I made a web part for Business Portal using Visual Studio. It worked fine
>on
> my station. On the remote server, it gave me the following error message:
> "Unrecoginzed configuration section 'connectionStrings'". I googled the
> error message, and was told to install .NET Framework 2.0. Now Business
> Portal tells me, "This page has encountered a critical error. Contact your
> system administrator if this problem persists." and I'm not even
> navigating
> to the page with the new webpart.
>
> Thx in advance for your help.
>
> trufaux


Nov 23 '05 #6
re:
Do you mean Internet Information Services Manager?
Yes.

re: Do you mean to set ASP.NET v2.0.50727
to "Allowed" under Web Services Extensions?
No.

I mean right-clicking your application's name in the
list in the Internet Information Services Manager,
selecting "Properties", and then selecting the "ASP.NET" tab.

There, you can set your application to run under 2.0, instead of 1.1

That mioght bring other problems, but at least you'll be running
the correct version of the .Net Framework for <connectionStrings>.

<connectionStrings> is not part of the 1.1 Framework configuration.
It's part of the 2.0 .Net Framework configuration.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com... Do you mean Internet Information Services Manager? Do you mean to set
ASP.NET v2.0.50727 to "Allowed" under Web Services Extensions? That was done.

Thanks

"Juan T. Llibre" wrote:
Adding to my previous reply, you need to change
the .Net Framework version that your application targets.

Use the ASP.NET tab in the Internet Service Manager
to change the Asp.Net version for your app to 2.0.


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com...
> Event log? Sorry, I'm a newbie. Could you be more specific please?
>
> What follows is the configuration error:
> *****
> Description: An error occurred during the processing of a configuration file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
>
> Parser Error Message: Unrecognized configuration section 'connectionStrings'
>
> Source Error:
>
>
> [No relevant source lines]
>
>
> Source File: web.config Line: 12
> *****
>
> This is line 12 from my web.config:
> *****
> <add name="ePrizeAppConnectionString" connectionString="Data
> Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
> providerName="System.Data.SqlClient"/>
> *****
>
> Am I correct in assuming that 'Integrated Security=True' is the same as
> Windows Authentication? Could this be the difference between my station and
> the server?
>
> Thanks again
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
>
>
>
>
>
> "Ken Cox [Microsoft MVP]" wrote:
>
>> It sounds like there's a syntax error in the web.config. There should be
>> more detail in the event log.
>>
>> "trufaux" <tr*****@discussions.microsoft.com> wrote in message
>> news:D7**********************************@microsof t.com...
>> >I made a web part for Business Portal using Visual Studio. It worked fine
>> >on
>> > my station. On the remote server, it gave me the following error message:
>> > "Unrecoginzed configuration section 'connectionStrings'". I googled the
>> > error message, and was told to install .NET Framework 2.0. Now Business
>> > Portal tells me, "This page has encountered a critical error. Contact your
>> > system administrator if this problem persists." and I'm not even
>> > navigating
>> > to the page with the new webpart.
>> >
>> > Thx in advance for your help.
>> >
>> > trufaux
>>
>>


Nov 23 '05 #7
That was already done. Now my Business Portal page says
*****
This page has encountered a critical error. Contact your system
administrator if this problem persists.

Web Parts Maintenance Page: If you have permission, you can use this page to
temporarily disable Web Parts or remove personal settings. For more
information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.
*****
and I didn't even put my new webpart on it.

I changed connectionStrings to appSettings in my web.config, and the error
message is "Parser Error Message: It is an error to use a section registered
as allowDefinition='MachineToApplication' beyond application level. This
error can be caused by a virtual directory not being configured as an
application in IIS."

Thanks for all your help.

"Juan T. Llibre" wrote:
re:
Do you mean Internet Information Services Manager?


Yes.

re:
Do you mean to set ASP.NET v2.0.50727
to "Allowed" under Web Services Extensions?


No.

I mean right-clicking your application's name in the
list in the Internet Information Services Manager,
selecting "Properties", and then selecting the "ASP.NET" tab.

There, you can set your application to run under 2.0, instead of 1.1

That mioght bring other problems, but at least you'll be running
the correct version of the .Net Framework for <connectionStrings>.

<connectionStrings> is not part of the 1.1 Framework configuration.
It's part of the 2.0 .Net Framework configuration.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com...
Do you mean Internet Information Services Manager? Do you mean to set
ASP.NET v2.0.50727 to "Allowed" under Web Services Extensions? That was done.

Thanks

"Juan T. Llibre" wrote:
Adding to my previous reply, you need to change
the .Net Framework version that your application targets.

Use the ASP.NET tab in the Internet Service Manager
to change the Asp.Net version for your app to 2.0.


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com...
> Event log? Sorry, I'm a newbie. Could you be more specific please?
>
> What follows is the configuration error:
> *****
> Description: An error occurred during the processing of a configuration file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
>
> Parser Error Message: Unrecognized configuration section 'connectionStrings'
>
> Source Error:
>
>
> [No relevant source lines]
>
>
> Source File: web.config Line: 12
> *****
>
> This is line 12 from my web.config:
> *****
> <add name="ePrizeAppConnectionString" connectionString="Data
> Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
> providerName="System.Data.SqlClient"/>
> *****
>
> Am I correct in assuming that 'Integrated Security=True' is the same as
> Windows Authentication? Could this be the difference between my station and
> the server?
>
> Thanks again
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
>
>
>
>
>
> "Ken Cox [Microsoft MVP]" wrote:
>
>> It sounds like there's a syntax error in the web.config. There should be
>> more detail in the event log.
>>
>> "trufaux" <tr*****@discussions.microsoft.com> wrote in message
>> news:D7**********************************@microsof t.com...
>> >I made a web part for Business Portal using Visual Studio. It worked fine
>> >on
>> > my station. On the remote server, it gave me the following error message:
>> > "Unrecoginzed configuration section 'connectionStrings'". I googled the
>> > error message, and was told to install .NET Framework 2.0. Now Business
>> > Portal tells me, "This page has encountered a critical error. Contact your
>> > system administrator if this problem persists." and I'm not even
>> > navigating
>> > to the page with the new webpart.
>> >
>> > Thx in advance for your help.
>> >
>> > trufaux
>>
>>


Nov 23 '05 #8
Hi, Trufaux.

You might want to review how Web Parts work under 2.0.
Some things have changed between 1.1 and 2.0.

See : http://beta.asp.net/QUICKSTART/aspne...s/default.aspx

Review the source code for each of the example controls there.

If this is too steep a change, you might want to consider
keeping the application under 1.1, and using <appSettings>
instead of <connectionStrings>


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:FD**********************************@microsof t.com...
That was already done. Now my Business Portal page says
*****
This page has encountered a critical error. Contact your system
administrator if this problem persists.

Web Parts Maintenance Page: If you have permission, you can use this page to
temporarily disable Web Parts or remove personal settings. For more
information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.
*****
and I didn't even put my new webpart on it.

I changed connectionStrings to appSettings in my web.config, and the error
message is "Parser Error Message: It is an error to use a section registered
as allowDefinition='MachineToApplication' beyond application level. This
error can be caused by a virtual directory not being configured as an
application in IIS."

Thanks for all your help.
"Juan T. Llibre" wrote:
re:
> Do you mean Internet Information Services Manager?


Yes.

re:
> Do you mean to set ASP.NET v2.0.50727
> to "Allowed" under Web Services Extensions?


No.

I mean right-clicking your application's name in the
list in the Internet Information Services Manager,
selecting "Properties", and then selecting the "ASP.NET" tab.

There, you can set your application to run under 2.0, instead of 1.1

That mioght bring other problems, but at least you'll be running
the correct version of the .Net Framework for <connectionStrings>.

<connectionStrings> is not part of the 1.1 Framework configuration.
It's part of the 2.0 .Net Framework configuration.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"trufaux" <tr*****@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com...
> Do you mean Internet Information Services Manager? Do you mean to set
> ASP.NET v2.0.50727 to "Allowed" under Web Services Extensions? That was done.
>
> Thanks
>
> "Juan T. Llibre" wrote:
>
>> Adding to my previous reply, you need to change
>> the .Net Framework version that your application targets.
>>
>> Use the ASP.NET tab in the Internet Service Manager
>> to change the Asp.Net version for your app to 2.0.
>>
>>
>>
>>
>> Juan T. Llibre, ASP.NET MVP
>> ASP.NET FAQ : http://asp.net.do/faq/
>> ASPNETFAQ.COM : http://www.aspnetfaq.com/
>> Foros de ASP.NET en Español : http://asp.net.do/foros/
>> ======================================
>> "trufaux" <tr*****@discussions.microsoft.com> wrote in message
>> news:01**********************************@microsof t.com...
>> > Event log? Sorry, I'm a newbie. Could you be more specific please?
>> >
>> > What follows is the configuration error:
>> > *****
>> > Description: An error occurred during the processing of a configuration file
>> > required to service this request. Please review the specific error details
>> > below and modify your configuration file appropriately.
>> >
>> > Parser Error Message: Unrecognized configuration section 'connectionStrings'
>> >
>> > Source Error:
>> >
>> >
>> > [No relevant source lines]
>> >
>> >
>> > Source File: web.config Line: 12
>> > *****
>> >
>> > This is line 12 from my web.config:
>> > *****
>> > <add name="ePrizeAppConnectionString" connectionString="Data
>> > Source=JACKIE;Initial Catalog=ePrizeApp;Integrated Security=True"
>> > providerName="System.Data.SqlClient"/>
>> > *****
>> >
>> > Am I correct in assuming that 'Integrated Security=True' is the same as
>> > Windows Authentication? Could this be the difference between my station and
>> > the server?
>> >
>> > Thanks again
>> >
>> >
>> > --------------------------------------------------------------------------------
>> > Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
>> > Version:1.1.4322.2300
>> >
>> >
>> >
>> >
>> >
>> > "Ken Cox [Microsoft MVP]" wrote:
>> >
>> >> It sounds like there's a syntax error in the web.config. There should be
>> >> more detail in the event log.
>> >>
>> >> "trufaux" <tr*****@discussions.microsoft.com> wrote in message
>> >> news:D7**********************************@microsof t.com...
>> >> >I made a web part for Business Portal using Visual Studio. It worked fine
>> >> >on
>> >> > my station. On the remote server, it gave me the following error message:
>> >> > "Unrecoginzed configuration section 'connectionStrings'". I googled the
>> >> > error message, and was told to install .NET Framework 2.0. Now Business
>> >> > Portal tells me, "This page has encountered a critical error. Contact your
>> >> > system administrator if this problem persists." and I'm not even
>> >> > navigating to the page with the new webpart.
>> >> >
>> >> > Thx in advance for your help.
>> >> >
>> >> > trufaux

Nov 23 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Frank | last post by:
Hi, we are using oracle clients (Release 9.0.1.0.1 - Production) on an NT4 (Service Pack6) computers. the server is a W2K, (Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the...
2
by: Marc Champagne | last post by:
Hi folks! I have built a VB project in VS.NET 7 which also includes a deployment project. Everything builds ok. When I install the setup package, it installs without a glitch.
2
by: JumpinJeff | last post by:
I am about to revamp the most referenced table in my whole database and am unsure the best way to approch it. The table's primary key is also used as a part number for all the items in the table. ...
3
by: ChadDiesel | last post by:
Hello everyone. I need some advice on table structure for a new project I've been given. One of our customers sends us an Excel spreadsheet each week containing their order. Currently, someone...
7
by: Shannan Casteel via AccessMonster.com | last post by:
I have a form for entering part numbers along with the associated quantity for each part. There are 25 Part fields and 25 associated Quantity fields. If I go to record 1 and enter part number 1234...
2
by: maxw_cc | last post by:
Hi to all of you, I was wondering what the Semantics part in C standard is really for? What should be on the constraints part and what should be on the semantics part? Is the implementation...
1
by: mknoll217 | last post by:
I am recieving this error from my code: The multi-part identifier "PAR.UniqueID" could not be bound. The multi-part identifier "Salary.UniqueID" could not be bound. The multi-part identifier...
1
by: tbrogdon | last post by:
I am new to this group and new to DBs. I am building a small DB for my work. We create sheetmetal parts. Each part has a part number (e.g., 1054471 or 50TG508506 - both formats are typical for a...
5
geolemon
by: geolemon | last post by:
I'm building a small-scale MRP system for an electronics manufacturing business. There are assemblies that are built, and parts that go into those assemblies. The individual component parts that go...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.