Monday, March 26, 2012
Export data into a script as "insert into"s
I am using a Web based front end to a SQL Server db installed at my host that only lets me import data into tables either manually (in a 'datasheet' view) or with a SQL query.
Does anybody know if I can export data from my local db as a script such as
insert into TestTable(Id, Name) values ("1", "Test1")
insert into TestTable(Id, Name) values ("2", "Test2")
.
.
.
... so that I can run this script on the Web front end and insert data into the db at my host?
Many thanks in advance.Here's a link to some stored procedures you might find useful. I think the DataAs InsCommand may be what you are looking for.
http://www.mssqlcity.com/Scripts/scrImpExp.htm|||Thanks for your help Fred.
That stored procedure mostly does the job but looks like it needs a few slight mods because some data types aren't implemented (such as text which is written out as 'None Yet')...
Wednesday, March 21, 2012
Export - Excel Error
i am not able to export the report as excel. it showing the below
error:
i am using the MSRS2000. i have installed microsoft office excel 2003.
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and
Settings\vinod_banagani\Desktop\AppointmentLog.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
is RS2000 supports Excel 2000 only?
if anyone have faced this problem earlier, please tell me the solution.
Thanks in advance for your help...Thanks for your response Bruce.
i have upgraded SP2.
When I select the export to excel file format, I get the following in
the
excel file: "Data Regions within table/matrix cells are
ignored".
i am using tables and rectangles inside the table... and texboxes
inside the rectangle in my report. the report is showing perfectly but
when i select the export to excel file, it is throwing an error.
Is this a known bug in RS..
Any info will be appreciated.
Thanks,
Vinod
vinodsh_82@.hotmail.com wrote:
> Hi All,
>
> i am not able to export the report as excel. it showing the below
> error:
>
> i am using the MSRS2000. i have installed microsoft office excel 2003.
>
> Microsoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and
> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
> The following is a list of repairs:
>
> Damage to the file was so extensive that repairs were not possible.
> Excel attempted to recover your formulas and values, but some data may
> have been lost or corrupted.
>
> is RS2000 supports Excel 2000 only?
>
> if anyone have faced this problem earlier, please tell me the solution.
>
> Thanks in advance for your help...|||Well, at least you got a better error message. It sounds like whatever
combination of tables, rectangles, tables within tables etc causes a
problem.
I don't know if 2005 would work better or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>|||Hi Vinod. It sounds like you are using a sub-report. Sub-reports are not
exported in the Excel rendering extension in RS2000 or RS2005. MHTML and
PDF rendering extensions do support sub-reports.
-Tim
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>
Export - Excel Error
i am not able to export the report as excel. it showing the below
error:
i am using the MSRS2000. i have installed microsoft office excel 2003.
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and
Settings\vinod_banagani\Desktop\AppointmentLog.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
is RS2000 supports Excel 2000 only?
if anyone have faced this problem earlier, please tell me the solution.
Thanks in advance for your help...
Regds,
vinodRS 2000 supports Excel 2003 out of the box. The inital release of RS did not
support Excel 2000 because it was using a format that 2003 knew but 2000 did
not. With SP1 this was fixed and both version of Excel work now. If you are
not on Sp1 or SP2 I recommend upgrading.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vinodsh_82@.hotmail.com> wrote in message
news:1147792560.164426.63070@.g10g2000cwb.googlegroups.com...
> Hi All,
>
> i am not able to export the report as excel. it showing the below
> error:
>
> i am using the MSRS2000. i have installed microsoft office excel 2003.
>
> Microsoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and
> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
> The following is a list of repairs:
>
> Damage to the file was so extensive that repairs were not possible.
> Excel attempted to recover your formulas and values, but some data may
> have been lost or corrupted.
>
> is RS2000 supports Excel 2000 only?
>
> if anyone have faced this problem earlier, please tell me the solution.
>
> Thanks in advance for your help...
> Regds,
> vinod
>
Monday, March 12, 2012
expiry of sql server 2000
Friday, March 9, 2012
experience a hard time to connect to the database my dbase is sql express ed 2005
hi to all , well i succesfully installed SQL server 2005 express edition in windows 2000 however when i am trying to connect my program thru ODBC im having a difficulty to connect. but based on my observation if i am not connected to the internet i cannot connect to my database but if i am connected to the internet i could access the SQL server 2005 express edition.i have read the hardware requirements for SQL server 2005 express edition i have upgraded the IE5 into IE6 SP1,windows 2000 SP4, even my memory to 1GB.but still i have the problem.
my question is, do i have to maintain my connection to the internet for me to have a smooth SQL connection?
BTW, i badly need the answer.Bigthanks!
-gae-
Have a look at my screencast for enabling Remote connections, that should help. They are available in the screencasts section of my site.HTH, jens Suessmeyer.
http://www.sqlserver2005.de
Sunday, February 26, 2012
ExOleDB Permissions problem as linked server
box. I using the ExOLEDB data provider to set up Exchange as a linked
server in SQL Server. A public folder is queried in a stored procedure
using OpenQuery and a SQL Query against the Exchange folder.
This all works fine, as long as the user is an administrator. If a
non-admin attempts to use the stored procedure, the SQL Server returns
the error "Could not create an instance of OLE DB provider
'exoledb.DataSource.1'.". I know that it can (as I can do it as
admin), so it appears to be a permissions problem. What do I need to
set to give regular users access to this data? I've tried playing with
the permissions in ESM with no luck.
Thank you,
ErickIs the procedure using the sp_OACreate? If so non-administrators cannot use
these procedures. This is documented in Books on lIne.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||No, the procedure is using OpenQuery. It basically does the following
SELECT * FROM OpenQuery(Exchange, 'SELECT * FROM SCOPE(''SHALLOW
TRAVERSAL OF "http://nbr-sql.nbr.lan/public/Intranet%20Calendar/"'')
WHERE NOT "urn:schemas:calendar:instancetype" = 1
AND "DAV:contentclass" = ''urn:content-classes:appointment''
ORDER BY Start desc'
)
It appears if the logged in user is a member of the Enterprise Admin
group in active directory, then it will work. However, this is not a
solution that is workable...
An odd thing is that if I add a user to the Enterprise Admin group,
and then remove them, they appear to keep the ability to run the
query. It might simply be a delay until the removal takes effect, I'm
not sure yet. But I'd like to set the permission so it's not as issue.
Thanks,
Erick
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<6EUAwUB7DHA.3496@.cpmsftngx
a07.phx.gbl>...
> Is the procedure using the sp_OACreate? If so non-administrators cannot us
e
> these procedures. This is documented in Books on lIne.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.|||I'm having the exact same problem with Index Server as a linked server..
any ideas?
thx,
mo
"Erick T" <joikm@.hotmail.com> wrote in message
news:888ecafd.0402042350.13ed45dc@.posting.google.com...
> I have Exchange 2000 server and SQL Server 2000 installed on the same
> box. I using the ExOLEDB data provider to set up Exchange as a linked
> server in SQL Server. A public folder is queried in a stored procedure
> using OpenQuery and a SQL Query against the Exchange folder.
> This all works fine, as long as the user is an administrator. If a
> non-admin attempts to use the stored procedure, the SQL Server returns
> the error "Could not create an instance of OLE DB provider
> 'exoledb.DataSource.1'.". I know that it can (as I can do it as
> admin), so it appears to be a permissions problem. What do I need to
> set to give regular users access to this data? I've tried playing with
> the permissions in ESM with no luck.
> Thank you,
> Erick
Friday, February 24, 2012
Existing Oracle Program Prevents SQL Server Express Being Installed in Windows XP Pro that is in
Hi all,
Our Microsoft NT 4 Network has Oracle program for all the Windows XP Pro PC terminals to use. We did not have the SQL Server Express Beta version installed before. Recently our Computer Administrator tried to install the SQL Server Express Edition that is downloaded from Microsoft Website to my Windows XP Pro PC terminal without luck, because the Oracle program is already in our LAN Network and prevents the installation of the SQL Server Express. Please help and advise me how to get the SQL Server Express installed in this situation.
Thanks in advance,
Scott Chang
Hi Scott,
First off, you'll need to take a look at the installer logs to get an idea of why installation failed. The logs are in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG and C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.
Second, I'm going to move this to the Setup forum so they can take a look at this once you've come back with information from the logs.
- Mike
|||Can you supply the exact error encountered when trying to install Express, as well as the logs referenced by Mike above?Existing MSDE with SQL2005 installation
I have a box woth MSDE installed.
I need to install sql2005.
My question is that
1. Do i have to uninstall MSDE first or I could upgrade MSDE to SQL2005
server?
2. Can I have both MSDE and SQL2005 existed in the same box?
Thanls allHi
SQL Server 2000 and SQL Server 2005 can run as different instances on the
same server. You can upgrade in place or side by side. Check out the upgrade
advisor, update technical reference and upgrade handbook at
http://www.microsoft.com/sql/soluti...de/default.mspx
John
"mecn" wrote:
> Hi,
> I have a box woth MSDE installed.
> I need to install sql2005.
> My question is that
> 1. Do i have to uninstall MSDE first or I could upgrade MSDE to SQL2005
> server?
> 2. Can I have both MSDE and SQL2005 existed in the same box?
> Thanls all
>
>
Existing MSDE with SQL2005 installation
I have a box woth MSDE installed.
I need to install sql2005.
My question is that
1. Do i have to uninstall MSDE first or I could upgrade MSDE to SQL2005
server?
2. Can I have both MSDE and SQL2005 existed in the same box?
Thanls allHi
SQL Server 2000 and SQL Server 2005 can run as different instances on the
same server. You can upgrade in place or side by side. Check out the upgrade
advisor, update technical reference and upgrade handbook at
http://www.microsoft.com/sql/solutions/upgrade/default.mspx
John
"mecn" wrote:
> Hi,
> I have a box woth MSDE installed.
> I need to install sql2005.
> My question is that
> 1. Do i have to uninstall MSDE first or I could upgrade MSDE to SQL2005
> server?
> 2. Can I have both MSDE and SQL2005 existed in the same box?
> Thanls all
>
>
Existing license for installed mssql server
Server is licensed, both on 7.0 and 2000?
Thanks for any help.
Donna CunninghamHi Donna
You could look at the values returned from the SERVERPROPERTY function such
as propertynames LicenseType and NumLicences although these do not always
report values. Also check out productversion, productlevel and edition.
John
"donna.cunningham@.ingrambook.com" wrote:
> Is there a way to determine how an existing installation of MS SQL
> Server is licensed, both on 7.0 and 2000?
> Thanks for any help.
> Donna Cunningham
>
Existing license for installed mssql server
Server is licensed, both on 7.0 and 2000?
Thanks for any help.
Donna CunninghamHi Donna
You could look at the values returned from the SERVERPROPERTY function such
as propertynames LicenseType and NumLicences although these do not always
report values. Also check out productversion, productlevel and edition.
John
"donna.cunningham@.ingrambook.com" wrote:
> Is there a way to determine how an existing installation of MS SQL
> Server is licensed, both on 7.0 and 2000?
> Thanks for any help.
> Donna Cunningham
>