Database

Re: Using ADO.Net to retrieve data from Excel 2007 - Cannot import more than 255 columns

5-Mar-08 21:38

Mehawitchi wrote:
I take it that you are dead sure that no way on earth could a "Select" statement pick more than 255 columns.

Certainly not on earth.

Maybe in a galaxy far, far away... Smile | :)

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Mehawitchi7-Mar-08 9:49

Mehawitchi

7-Mar-08 9:49

Hi again Paul,

I followed your suggestion and split the uploads.

The problem now in the rows of second upload, instead of adding them to the same rows of first upload, they are bieng added on top of them.

To explain further, the excel sheet has 280 columns x 100 rows. In the first upload, I fill the dataset with 255 clms x 100 rows. In the second upload, I fill the dataset with 25 clmns x 100 rows, but in the end result I get a dataset with 280 clmns (cool) and 200 rows (Not cool)

Is there any way perhaps in a galaxy not far away Big Grin | :-D

, that I enforce the dataset to add the rows of the second upload into those of the first upload

Greatly appreciate your help

Re: Using ADO.Net to retrieve data from Excel 2007 - Cannot import more than 255 columns

jvandertol122-Jun-09 9:49

jvandertol1

22-Jun-09 9:49

Perhaps this might work better:

SELECT * from [MyNamedRange]

or

SELECT * from [Sheet1$A1:B10]

How to Execute a DTS Package within a Procedure

Vimalsoft(Pty) Ltd4-Mar-08 23:06

Re: How to Execute a DTS Package within a Procedure

4-Mar-08 23:06

Good afternoon All

i have a DTS Package from a Different Server and i want to Execute it from inside a Stored procedure and execute it in vb. The Vb part i will handle, i would like to know how am i going to achieve that in SQL

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

pmarfleet5-Mar-08 1:14

Re: How to Execute a DTS Package within a Procedure

5-Mar-08 1:14

Did you try searching Google before posting?

I did and got several relevent results[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Vimalsoft(Pty) Ltd5-Mar-08 1:18

Re: How to Execute a DTS Package within a Procedure

5-Mar-08 1:18

Good Afternoon Paul

i always Google, but the one Find was complicated, they pass a Parameter, but i managed go sort it out like this and its working fine, please Comment on it.

<br />
Create procedure sp_Call_Refresh_ValuationRoll_dts <br />
AS <br />
declare @Command varchar(1000) <br />
SET @Command = 'DTSRun /S SGIIRCONETGS01 /U sde /P topology /N Valuation_Roll_Refresh' <br />
<br />
EXEC master.dbo.xp_cmdshell @Command <br />
GO <br />

Thanks

pmarfleet5-Mar-08 1:30

Re: How to Execute a DTS Package within a Procedure

5-Mar-08 1:30

It looks OK. Does it work for you?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Vimalsoft(Pty) Ltd5-Mar-08 1:32

SQL Server 2000 and aspnet_regsql.exe

5-Mar-08 1:32

i get some Permission Errors like

<br />
xp_cmdshell failed to execute because LogonUserW returns error 1909. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_account.<br />
Msg 50001, Level 1, State 0<br />

But am still busy on permission of a user sde.

Thanks

xls

SVb.net4-Mar-08 21:46

SVb.net

4-Mar-08 21:46

i need open file xls from query?
i used this command
select *
FROM
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\a.xls; Extended properties = Excel 8.0')...[sheet1$] a
but make error
Server: Msg 7314, Level 16, State 1, Line 15
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'sheet1$'. The table either does not exist or the current user does not have permissions on that table.
OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='Microsoft.Jet.OLEDB.4.0', TableName='sheet1$'].
--------------
i'm sure from sheet1$ is exist in file a.xls

123

Re: xls

Krish - KP4-Mar-08 23:27

Krish - KP

4-Mar-08 23:27

hi 123,

excle file should have sheet with name "sheet1" i.e. excluding $ sign.

Regards
KP

Re: xls

SVb.net4-Mar-08 23:30

SVb.net

4-Mar-08 23:30

thanks , i need open file excell from network 82.99.99.1

123

Brendan Vogt4-Mar-08 21:34

Brendan Vogt

4-Mar-08 21:34

Hi,

Has anyone had any problems runnin the aspnet_regsql.exe tool with a SQL Server that is on a different server as your development PC?

When the tools ask me to enter the Server, I type in abc-def,1234. The 1234 is the name of the port. The when I click on the database drop down I get the following error:

Failed to query a list of database names from the SQL Server. Invalid object name 'sysdatabases'.

Why does it do this? I can open the database in SQL Server Eneterprise Manager for the 2000 database.

Regards
.NET Enthusiast

goto in sql server 2000 stoed procedure

Sonia Gupta4-Mar-08 20:40

Sonia Gupta

4-Mar-08 20:40

in stored procedure sql server 2000 , i am using the goto keyword to send the user to execute the particular line , Is this the right way to do so ?
I am saying this because , in general , we are told to stop using the goto keyword , as far as the memory consumption is concerned.

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: goto in sql server 2000 stoed procedure

pmarfleet4-Mar-08 21:46

Re: goto in sql server 2000 stoed procedure

4-Mar-08 21:46

Sonia Gupta wrote:
we are told to stop using the goto keyword , as far as the memory consumption is concerned.

I'm not sure why memory consumption should be an issue. The traditional arguments against using GOTO are outlined in this article[^]. What are you using GOTO for?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Khawar Abbas15-Mar-08 1:44

Khawar Abbas1

5-Mar-08 1:44

its better not to use goto statement. try to use some alternate to perform the functionality.

Do good and have good.

How used Sql Server in LAN [modified]

M.Nouri4-Mar-08 20:14

4-Mar-08 20:14

I Want design a database in sql server that used this database with Remote Machine from of LAN (Application installed in Remote Machine). please send answer, in way step by step.
Sigh | :sigh:

Thanks. Have A Good Time.

modified on Wednesday, March 5, 2008 2:21 AM

Vimalsoft(Pty) Ltd4-Mar-08 21:06

4-Mar-08 21:06

Take your time and Explain your Problem and what you want to achieve

Thanks

M.Nouri5-Mar-08 17:53

5-Mar-08 17:53

Thanks for your answer. I design my database in sqlserver2005 and application in delphi and create a udl file then i try to connect to remote machine that sqlserver2005 installed . but i could not connect.

Vimalsoft(Pty) Ltd5-Mar-08 19:07

5-Mar-08 19:07

hi M.Nouri

What is the Error when you try to Connect?

i was gonna Say post your code so i see if there is something wrong, am not into Delphi and i don't know how the syntax looks like, am into .NET C# or Vb then it would be easy for me to help you. Why do you still use Delphi if i may ask, what is it there is there and that is not in .NET?

i have done some small googling and i found this hope it will help.

http://www.delphi3000.com/articles/article_1725.asp?SK=[^]

Hope it Helps

M.Nouri5-Mar-08 20:04

5-Mar-08 20:04

hi Vuyiswa
I run sql server 2005 management studio and then select network server, i see my remote machine name , then i select remote machine name and select windows authenitication tnen click connect but sql server give login fail the user ... .

Vimalsoft(Pty) Ltd5-Mar-08 21:24

5-Mar-08 21:24

Do you have Permissions to Access that server?

Check you login if its Correct.

Do you have SQl installed in your system?

Thanks

M.Nouri5-Mar-08 23:33

5-Mar-08 23:33

I installed sql server2005 on two computer and in start->run->ip address(or name) i could connect to another computer ; but in sql server configuration and service when i want to change local server to network server ;sql server message could not logon to ip address.

thanks very much.

Vimalsoft(Pty) Ltd6-Mar-08 0:36