bug? outlook web access

Scenerio:
RS2000. Subscription delivers email with PDF attachment.
When the email is opened in Outlook client, the attachment is there and
working as expected.
Problem:
When the email is opened in the Outlook Web client (OWA), the paperclip is
there identifying the attachment, but when the email is opened, there is no
attachment.
It seems to be happening only with attachment coming from reporting
services. I can send an email with another PDF file and open it fine. The
PDF files are small in size so I do not think it is a size proble.I just tried this and also was not able to see the .pdf file. This appears
to be a bug to me. I would contact customer support to help get this issue
resolved.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:B4C39492-DC1A-4FA0-8198-F1727A020B34@.microsoft.com...
> Scenerio:
> RS2000. Subscription delivers email with PDF attachment.
> When the email is opened in Outlook client, the attachment is there and
> working as expected.
> Problem:
> When the email is opened in the Outlook Web client (OWA), the paperclip is
> there identifying the attachment, but when the email is opened, there is
> no
> attachment.
> It seems to be happening only with attachment coming from reporting
> services. I can send an email with another PDF file and open it fine.
> The
> PDF files are small in size so I do not think it is a size proble.|||Daniel,
Thank you for the response.
"Daniel Reib [MSFT]" wrote:
> I just tried this and also was not able to see the .pdf file. This appears
> to be a bug to me. I would contact customer support to help get this issue
> resolved.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:B4C39492-DC1A-4FA0-8198-F1727A020B34@.microsoft.com...
> >
> > Scenerio:
> > RS2000. Subscription delivers email with PDF attachment.
> > When the email is opened in Outlook client, the attachment is there and
> > working as expected.
> >
> > Problem:
> > When the email is opened in the Outlook Web client (OWA), the paperclip is
> > there identifying the attachment, but when the email is opened, there is
> > no
> > attachment.
> >
> > It seems to be happening only with attachment coming from reporting
> > services. I can send an email with another PDF file and open it fine.
> > The
> > PDF files are small in size so I do not think it is a size proble.
>
>

BUG? Extracting Data Stored in Multiple Languages

Hi,

I have an access database that is storing text in english and chinese characters. I am importing the data using SSIS and it is putting a 'square' character in place of all the chinese characters. Can I associate multiple code pages to a control? If this is not possible, I would just like to Extract the data and Load it into a table, and i will just handle the errors and write the key fields to an error log. The problem is that the error handler is not redirecting the row. It just simply fails. I have changed all the error actions to Redirect Row too. I currently have a script checking if the 'square' character exists but i feel this should be handled a better way? Has anyone run into this issue or have any suggestions?

This is the error code i get

Data conversion failed. The data conversion for column "FDCDOPS0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

Access stores string data as Unicode. Is it possible to keep it that way? Where do you transfer data to? If you are moving it to SQL Server tables, is it possible to use Unicode string types (nchar/nvarchar), and avoid conversions?

Thanks.

|||

I am storing the field in question as nvarchar(256). I'm transferring data to a SQL Server 2005 database. I still have had no luck in solving the issue. Unicode is the answer i think. I am using a Data Source and Data Source View in SSIS. When I view the data in the data view the conversion has already taken place. Is there a way to set the field types in the data source or view?

Thanks

|||

It is not quite clear to me what you are doing. Could you explain what components you are using in your package or even better attach a simplified version of it.

Thanks.

sql

Bug with Renaming Connection

I used the wizard to create a package that loads data from Access into SQL Server 2005. I then saved the package to the File System and added to my project.

I had two connections, one for SQL and one for Access. When I rename either one, the source or destination tasks in the Data Flow task reset to the other connection and/or I get an error that the old connection ID cannot be found.

I solved by opening the dtsx in Notepad and doing a global find/replace for the connection ID's. This is a real hassle.

Are you right-clicking on the connection manager and selecting rename? Or how are you renaming them?|||

That was how I tried to rename, by right-clicking. Also tried within the Properties and in the Package Explorer. Same thing.

|||

Do you want to know another bug. In the Import Data wizard that creates the package, I checked the Source box in the upper left which selected all the tables. I then went into Edit Mappings and checked to Delete Rows in Destination Tables.

However, when I execute the package, it doesn't delete the rows and instead appends the data. It might be because I am importing a lot of tables, because when I tried one table only, it worked. I believe it calls sp_executesql to execute the SQL statement and maybe the sql statement string is too long. Unfortunately, it doesn't warn that anything is incorrect, so one doesn't discover this until after testing. Don't mind bugs, but a bug like this without any kind of warning message is kind of dangerous.

|||

When building a package from the designer, renaming connections is fine, because actually the task stores the connection ID not the name.

I did a quick test with a Wizard built package and it varies, for example a snippet of the Exec SQL Task <SQLTask:SqlTaskData SQLTask:Connection="{5545ACCD-6E14-45EF-9112-2AC292C30609}" shows the use of the ID, so renames should keep working just fine, except that other stuff is doing it wrong.

For example an OLE-DB destination shows <connection id="48" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="DestinationConnectionOLEDB"/></connections> which uses the name.

If I then open the package, and open the UI and close it again for the OLE-DB component, the XMl is changed to this <connection id="48" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5545ACCD-6E14-45EF-9112-2AC292C30609}"/></connections> which clearly will survive a rename.

So why not log it at http://connect.microsoft.com

By the way, stop using notepad if you have added the package to a project. Just right click the package in the Solution Explore and select View Code. You get a much nicer text editor with better find and replace, and it keeps it all nicely liked to the designer window for the package as well. Much easier for when you do want to hack package XML directly.

BUG in SQL SERVER 2000 ?

I have an Access database that retrieves view definitions from an SQL server
database. I use this statement to get the view definitions :
select TABLE_NAME as VIEW_NAME,VIEW_DEFINITION
from INFORMATION_SCHEMA.VIEWS
I have a view thet is more then 4000 characters and then the call against
INFORMATION_SCHEMA returns NULL for the VIEW_DEFINITION. Why ?
If i query the syscomments table the view is splitted in two columns.
Regards
Robert Vabo
Senior developer
Gecko Informasjonssystemer AS
rv_nospam@.gecko.no
Remove the _nospam to send mail !
www.gecko.noDo you mean rows or columns in the syscomments table'
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Robert Vabo" <rvabo@.msn.com> wrote in message
news:%23jK0CCh8DHA.2116@.TK2MSFTNGP10.phx.gbl...
> I have an Access database that retrieves view definitions from an SQL
server
> database. I use this statement to get the view definitions :
> select TABLE_NAME as VIEW_NAME,VIEW_DEFINITION
> from INFORMATION_SCHEMA.VIEWS
> I have a view thet is more then 4000 characters and then the call against
> INFORMATION_SCHEMA returns NULL for the VIEW_DEFINITION. Why ?
> If i query the syscomments table the view is splitted in two columns.
>
> --
> Regards
> Robert Vabo
> Senior developer
> Gecko Informasjonssystemer AS
> rv_nospam@.gecko.no
> Remove the _nospam to send mail !
> www.gecko.no
>|||Sorry. I mean rows ofcourse.
But the problem is that the column VIEW_DEFINITION returns NULL when
querying the INFORMATION_SCHEMA
Regards
Robert Vabo
Senior developer
Gecko Informasjonssystemer AS
rv_nospam@.gecko.no
Remove the _nospam to send mail !
www.gecko.no
"SriSamp" <ssampath@.sct.co.in> skrev i melding
news:%23YBXKkh8DHA.452@.TK2MSFTNGP11.phx.gbl...
> Do you mean rows or columns in the syscomments table'
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "Robert Vabo" <rvabo@.msn.com> wrote in message
> news:%23jK0CCh8DHA.2116@.TK2MSFTNGP10.phx.gbl...
> server
against
>

BUG in SQL SERVER 2000 ?

I have an Access database that retrieves view definitions from an SQL server
database. I use this statement to get the view definitions :
select TABLE_NAME as VIEW_NAME,VIEW_DEFINITION
from INFORMATION_SCHEMA.VIEWS
I have a view thet is more then 4000 characters and then the call against
INFORMATION_SCHEMA returns NULL for the VIEW_DEFINITION. Why ?
If i query the syscomments table the view is splitted in two columns.
--
Regards
Robert Vabo
Senior developer
Gecko Informasjonssystemer AS
rv_nospam@.gecko.no
Remove the _nospam to send mail !
www.gecko.noDo you mean rows or columns in the syscomments table'
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Robert Vabo" <rvabo@.msn.com> wrote in message
news:%23jK0CCh8DHA.2116@.TK2MSFTNGP10.phx.gbl...
> I have an Access database that retrieves view definitions from an SQL
server
> database. I use this statement to get the view definitions :
> select TABLE_NAME as VIEW_NAME,VIEW_DEFINITION
> from INFORMATION_SCHEMA.VIEWS
> I have a view thet is more then 4000 characters and then the call against
> INFORMATION_SCHEMA returns NULL for the VIEW_DEFINITION. Why ?
> If i query the syscomments table the view is splitted in two columns.
>
> --
> Regards
> Robert Vabo
> Senior developer
> Gecko Informasjonssystemer AS
> rv_nospam@.gecko.no
> Remove the _nospam to send mail !
> www.gecko.no
>|||Sorry. I mean rows ofcourse.
But the problem is that the column VIEW_DEFINITION returns NULL when
querying the INFORMATION_SCHEMA
--
Regards
Robert Vabo
Senior developer
Gecko Informasjonssystemer AS
rv_nospam@.gecko.no
Remove the _nospam to send mail !
www.gecko.no
"SriSamp" <ssampath@.sct.co.in> skrev i melding
news:%23YBXKkh8DHA.452@.TK2MSFTNGP11.phx.gbl...
> Do you mean rows or columns in the syscomments table'
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "Robert Vabo" <rvabo@.msn.com> wrote in message
> news:%23jK0CCh8DHA.2116@.TK2MSFTNGP10.phx.gbl...
> > I have an Access database that retrieves view definitions from an SQL
> server
> > database. I use this statement to get the view definitions :
> > select TABLE_NAME as VIEW_NAME,VIEW_DEFINITION
> > from INFORMATION_SCHEMA.VIEWS
> >
> > I have a view thet is more then 4000 characters and then the call
against
> > INFORMATION_SCHEMA returns NULL for the VIEW_DEFINITION. Why ?
> > If i query the syscomments table the view is splitted in two columns.
> >
> >
> > --
> > Regards
> > Robert Vabo
> > Senior developer
> > Gecko Informasjonssystemer AS
> > rv_nospam@.gecko.no
> > Remove the _nospam to send mail !
> > www.gecko.no
> >
> >
>

Buffer Cache

hi,
How can we check buffer cache ratio of sql server..i don't want to go inside sql counters as i dont have direct access of sever..is it possible by some SP or command.
Regards
SunnyHi,
Execute the below command from Query Analyzer
DBCC PERFMON
Please refer BOL for more info in the above command.
Thanks
Hari
MCDBA
"Sunny" <anonymous@.discussions.microsoft.com> wrote in message
news:ED4DADFD-C6E4-4D03-B2E4-6755EE1C5949@.microsoft.com...
> hi,
> How can we check buffer cache ratio of sql server..i don't want to go
inside sql counters as i dont have direct access of sever..is it possible by
some SP or command.
> Regards
> Sunny

Buffer Cache

hi,
How can we check buffer cache ratio of sql server..i don't want to go inside
sql counters as i dont have direct access of sever..is it possible by some
SP or command.
Regards
SunnyHi,
Execute the below command from Query Analyzer
DBCC PERFMON
Please refer BOL for more info in the above command.
Thanks
Hari
MCDBA
"Sunny" <anonymous@.discussions.microsoft.com> wrote in message
news:ED4DADFD-C6E4-4D03-B2E4-6755EE1C5949@.microsoft.com...
> hi,
> How can we check buffer cache ratio of sql server..i don't want to go
inside sql counters as i dont have direct access of sever..is it possible by
some SP or command.
> Regards
> Sunny

btrieve

Hi
first excuse my bad english, I am french.
I think with older access version we can access to btrieve
files via ODBC but now I have not found a such driver for
actuate version and I have no more first access version ;
I want only to read once time old btrieve files for make
new files with the old data.
Somedy know an odbc driver for btrieve ? not too expansive ;-)
or any suggestions for my recovery/translation ?
In advance Thank you very much.
I also post this question to access odbc driver and data odbc
Jacques
You can find a list of third party ODBC drivers at:
http://www.sqlsummit.com/ODBCVend.htm
If you search the page for Btrieve, you will find the
vendors for Btrieve drivers.
-Sue
On Tue, 03 May 2005 14:42:23 +0200, ICSD n&f
<J-Thery@.ouca.fr> wrote:

>Hi
>first excuse my bad english, I am french.
>I think with older access version we can access to btrieve
>files via ODBC but now I have not found a such driver for
>actuate version and I have no more first access version ;
>I want only to read once time old btrieve files for make
>new files with the old data.
>Somedy know an odbc driver for btrieve ? not too expansive ;-)
>or any suggestions for my recovery/translation ?
>In advance Thank you very much.
>I also post this question to access odbc driver and data odbc
>Jacques
|||I found in fact 2or3 vendors that I did not know
Thank you Sue,
Sue Hoegemeier a =E9crit :
> You can find a list of third party ODBC drivers at:
> http://www.sqlsummit.com/ODBCVend.htm
> If you search the page for Btrieve, you will find the
> vendors for Btrieve drivers.
>=20
> -Sue
>=20
> On Tue, 03 May 2005 14:42:23 +0200, ICSD n&f
> <J-Thery@.ouca.fr> wrote:
>=20
>=20
>=20
>=20

btrieve

Hi
first excuse my bad english, I am french.
I think with older access version we can access to btrieve
files via ODBC but now I have not found a such driver for
actuate version and I have no more first access version ;
I want only to read once time old btrieve files for make
new files with the old data.
Somedy know an odbc driver for btrieve ? not too expansive ;-)
or any suggestions for my recovery/translation ?
In advance Thank you very much.
I also post this question to access odbc driver and data odbc
JacquesYou can find a list of third party ODBC drivers at:
http://www.sqlsummit.com/ODBCVend.htm
If you search the page for Btrieve, you will find the
vendors for Btrieve drivers.
-Sue
On Tue, 03 May 2005 14:42:23 +0200, ICSD n&f
<J-Thery@.ouca.fr> wrote:

>Hi
>first excuse my bad english, I am french.
>I think with older access version we can access to btrieve
>files via ODBC but now I have not found a such driver for
>actuate version and I have no more first access version ;
>I want only to read once time old btrieve files for make
>new files with the old data.
>Somedy know an odbc driver for btrieve ? not too expansive ;-)
>or any suggestions for my recovery/translation ?
>In advance Thank you very much.
>I also post this question to access odbc driver and data odbc
>Jacques|||I found in fact 2or3 vendors that I did not know
Thank you Sue,
Sue Hoegemeier a =E9crit :
> You can find a list of third party ODBC drivers at:
> http://www.sqlsummit.com/ODBCVend.htm
> If you search the page for Btrieve, you will find the
> vendors for Btrieve drivers.
>=20
> -Sue
>=20
> On Tue, 03 May 2005 14:42:23 +0200, ICSD n&f
> <J-Thery@.ouca.fr> wrote:
>=20
>=20
>=20
>=20

Browse date

After I built the cube I clicked browse date in the cube
file and received the message Undefined error. What gives?
How do I access the data. I'm new to this program and was
following the sample program that came with Analysis
Manager.
Thanks for the helpYou should re-post this on the Datawarehouse newsgroup... They should be
able to help you there.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gary" <gsylvester@.npgcable.com> wrote in message
news:2b9ea01c46881$22a97fa0$a401280a@.phx.gbl...
> After I built the cube I clicked browse date in the cube
> file and received the message Undefined error. What gives?
> How do I access the data. I'm new to this program and was
> following the sample program that came with Analysis
> Manager.
> Thanks for the help

Browse date

After I built the cube I clicked browse date in the cube
file and received the message Undefined error. What gives?
How do I access the data. I'm new to this program and was
following the sample program that came with Analysis
Manager.
Thanks for the helpYou should re-post this on the Datawarehouse newsgroup... They should be
able to help you there.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gary" <gsylvester@.npgcable.com> wrote in message
news:2b9ea01c46881$22a97fa0$a401280a@.phx
.gbl...
> After I built the cube I clicked browse date in the cube
> file and received the message Undefined error. What gives?
> How do I access the data. I'm new to this program and was
> following the sample program that came with Analysis
> Manager.
> Thanks for the help

Browse date

After I built the cube I clicked browse date in the cube
file and received the message Undefined error. What gives?
How do I access the data. I'm new to this program and was
following the sample program that came with Analysis
Manager.
Thanks for the help
You should re-post this on the Datawarehouse newsgroup... They should be
able to help you there.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gary" <gsylvester@.npgcable.com> wrote in message
news:2b9ea01c46881$22a97fa0$a401280a@.phx.gbl...
> After I built the cube I clicked browse date in the cube
> file and received the message Undefined error. What gives?
> How do I access the data. I'm new to this program and was
> following the sample program that came with Analysis
> Manager.
> Thanks for the help

Break mirror availability

I need to break a mirror on one of our reporting servers but it's 24/7 and
pretty busy. Does anyone know if this would interupt db access?
Thanks in advanceBy "break mirror", what do you mean exactly? Is it that you have RAID1 and
want to remove one of the disks? In that case, thee should be no
interruption. Just keep in mind that you are vulnerable until the
remirroring has been completed.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
I need to break a mirror on one of our reporting servers but it's 24/7 and
pretty busy. Does anyone know if this would interupt db access?
Thanks in advance|||Sorry Tom, my bad.
I'm mean database mirroring, not IO.
I want to break the mirror but I'm wondering if the primary will experience
any unavailability when I execute the SET PARTNER = NONE or whatever the
syntax is.
"Tom Moreau" wrote:
> By "break mirror", what do you mean exactly? Is it that you have RAID1 and
> want to remove one of the disks? In that case, thee should be no
> interruption. Just keep in mind that you are vulnerable until the
> remirroring has been completed.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
> news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
> I need to break a mirror on one of our reporting servers but it's 24/7 and
> pretty busy. Does anyone know if this would interupt db access?
> Thanks in advance
>|||You can stop DB mirroring without affecting the principal. What you have to
do later depends on how mirroring was stopped. If you formally did an ALTER
database and told it that you don't want to mirror any more, then when you
do go to mirror again, you'll need to restore a full backup to the mirror
server and resynch. However, if all you did was take the mirror server
offline, then transactions will remain in the log of the primary until you
can get the mirror back online again.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:AD0CCDB5-2D7F-4FCE-94EA-28D814CA837D@.microsoft.com...
Sorry Tom, my bad.
I'm mean database mirroring, not IO.
I want to break the mirror but I'm wondering if the primary will experience
any unavailability when I execute the SET PARTNER = NONE or whatever the
syntax is.
"Tom Moreau" wrote:
> By "break mirror", what do you mean exactly? Is it that you have RAID1
> and
> want to remove one of the disks? In that case, thee should be no
> interruption. Just keep in mind that you are vulnerable until the
> remirroring has been completed.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
> news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
> I need to break a mirror on one of our reporting servers but it's 24/7 and
> pretty busy. Does anyone know if this would interupt db access?
> Thanks in advance
>

brackets in parameter using URL navigation

I am passing my report parameter descriptions from an .aspx page to one
report parameter (concatenated) using url access. It works great except when
the description contains brackets "()" the url get confused on the first "("
and I get an invalid path.
Any ideas?It was Friday when I wrote the original thread, It is actually an "&" that is
causing the problem
"KENWOOD" wrote:
> I am passing my report parameter descriptions from an .aspx page to one
> report parameter (concatenated) using url access. It works great except when
> the description contains brackets "()" the url get confused on the first "("
> and I get an invalid path.
> Any ideas?|||Try uniciding the URL, as an "&" is a special character in a URL, same with %
etc.
"KENWOOD" wrote:
> It was Friday when I wrote the original thread, It is actually an "&" that is
> causing the problem
> "KENWOOD" wrote:
> > I am passing my report parameter descriptions from an .aspx page to one
> > report parameter (concatenated) using url access. It works great except when
> > the description contains brackets "()" the url get confused on the first "("
> > and I get an invalid path.
> >
> > Any ideas?

BPA install error

Trying to install BPA and get an error message "Error writing to file BpaCommon.dll. Verify you have access to that directory" I can see that file in the installed directory and permissions look fine. Tried install with inteegrated and mixed mode authenti
cation as well as installing to different folder. Same error. Can't find any reference to this dll in NG or MS site.
Thanks for any help
Hi
Maybe you need to unregister and re-register it with regsvr32? It may also
be corrupted, so manually extracting it may be another possibility?
John
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:5672F0D9-EE90-4780-AB66-F32654113C11@.microsoft.com...
> Trying to install BPA and get an error message "Error writing to file
BpaCommon.dll. Verify you have access to that directory" I can see that file
in the installed directory and permissions look fine. Tried install with
inteegrated and mixed mode authentication as well as installing to different
folder. Same error. Can't find any reference to this dll in NG or MS site.
> Thanks for any help
|||Dave
BpaCommon.dll is also registered in the Global Assembly Cache (aka GAC).
Usually located in <windows folder>\assembly
Can you verify that there is no bpacommon.dll in the GAC before you install?
You can manually try to register in the GAC by using gacutil.exe (available
from the .net framework SDK).
Let me know if you still can't get it to work.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:e9WP2hVVEHA.2828@.TK2MSFTNGP10.phx.gbl...
> Hi
> Maybe you need to unregister and re-register it with regsvr32? It may also
> be corrupted, so manually extracting it may be another possibility?
> John
> "Dave" <Dave@.discussions.microsoft.com> wrote in message
> news:5672F0D9-EE90-4780-AB66-F32654113C11@.microsoft.com...
> BpaCommon.dll. Verify you have access to that directory" I can see that
file
> in the installed directory and permissions look fine. Tried install with
> inteegrated and mixed mode authentication as well as installing to
different
> folder. Same error. Can't find any reference to this dll in NG or MS site.
>

bout union select....

can someone help me how can i access datas using union? or show my data in the gridview....pls....

coz i have 3 tables...

i need to output the datas of the 3 tables in 1 gridview.

tables are: TT0001,TM0011,TM0001

TT0001 has syain_id(PK),time_in,time_out,year(PK),month(PK),day(PK)

TM0011 has office_name,office_id(PK)

TM0001 has syain_id(PK) office_id(PK),empl_date

the scenario is:

i have a combo box for office_name, and a textbox for imputting the date( 2007/01/23).when i click the button OK.

the time_in,time_out and syain_name of the person who is present in the choosen date(ex. 2007/01/23) will be shown in my gridview_info.

i already have some codes but it still confuse me and has many errors...

my code:

GridView_info.Visible = True

'//for odbc
Dim StrConn As String = "Dsn=MS_PKG01;UID=emiline;APP=Microsoft? Visual Studio? 2005;WSID=MSHNP200603;DATABASE=MS_PKG01;Trusted_Connection=Yes"
Dim MyConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(StrConn)

'Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("MS_PKG01ConnectionString").ConnectionString)

MyConn.Open()

'//parsing 2
Dim MyString As String = TextBox_date.Text
Dim MyDateTime As DateTime = DateTime.Parse(MyString)
Console.WriteLine(MyDateTime)

Dim stringQuery2 As String = "SELECT * from tempo_db"

Dim SQLcommand2 As New Odbc.OdbcCommand("Create table tempo_db ( syain_name char(40),year char(4), month char(2), day char(2), in_hh int, in_mi int, out_hh int, out_mi int )", MyConn)
SQLcommand2.ExecuteNonQuery()

Dim SQLcommand1 As New Odbc.OdbcCommand("Drop table tempo_db", MyConn)
SQLcommand1.ExecuteNonQuery()

Dim da As New Odbc.OdbcDataAdapter("Select TT0001.Year,TT0001.Month,TT0001.Day,TT0001.in_hh,TT0001.in_mi,TT0001.out_hh,TT0001.out_min where TT0001.Year =" + MyString + " and TT0001.Month =" + MyString + " and TT0001.Day =" + MyString + " and TT0001.syain_id =" + TM0001.syain_id + " Union Select TM0001.syain_name where TM0001.syain_id =" + TT0001.syain_id + " 　Union Select　TM0011.office_name where TM0011.office_id =" + TM0001.office_id + "
Dim ds As New DataSet()
Dim foundrow As DataRow
Dim ds2 As New DataSet
'Dim temp_data_table As New DataTable

GridView_info.DataSource = ds
da.Fill(ds, "TT0001")

Dim sqldataadapter2 As New Odbc.OdbcDataAdapter(stringQuery2, MyConn)
sqldataadapter2.Fill(ds2, "tempo_db")
Dim date_ctr As Integer
date_ctr = 1

While date_ctr <= Date.DaysInMonth(Now.Year, Now.Month)

ds.Tables(0).PrimaryKey = New DataColumn() {ds.Tables(0).Columns("Year")}
'ds.Tables(1).PrimaryKey = New DataColumn() {ds.Tables(0).Columns("Month")}
'ds.Tables(2).PrimaryKey = New DataColumn() {ds.Tables(0).Columns("Day")}

foundrow = ds.Tables(0).Rows.Find(date_ctr)
'foundrow = ds.Tables(1).Rows.Find(date_ctr)
'foundrow = ds.Tables(2).Rows.Find(date_ctr)

Dim in_hh, in_mi, out_hh, out_mi As String

If foundrow IsNot Nothing Then
in_hh = foundrow.Item("in_hh")
in_mi = foundrow.Item("in_mi")
out_hh = foundrow.Item("out_hh")
out_mi = foundrow.Item("out_mi")
End If

End While

GridView_info.DataSource = ds2
GridView_info.DataBind()
MyConn.Close()

End Sub

/// ps: im having problem with my select statements....

can someone help me analyze what i had written... and what is my mistake...

any help is greatly appreciated...

thanks

nat!

Remember in union all select statement have to returns the same table structure, and you should use syntax like :

Select * from t1 where a=b

UNION

select * from t2 where b=c

instead of

Select * where a=b

UNION

select * where b=c

(you have it in da As New Odbc.OdbcDataAdapter)

If you select statements returns different number of columns just add dummy columns to where you need them

like

Select c1,c2,c3,c4 from t1 where a=b

UNION

select d1,d2,d3 ,'dummy value' from t2 where b=c

but remember that all columns have to have the same format like 1 select statement

Thanks

JPazgier

Bound Control on Access Form Causing High Memory Usage on SQL Server

I got about 50 Access users every day using the SQL Server
2000 database. At the end of the day, SQL Server always
ran out of the memory. Someone told me this is because of
the bound connection on the Access form causing the memory
leak. Is there a way to fix this problem without changing
my Access form design.not really.
acccess bound controls open numerous connections PER FORM.
this is not good.
only way to fix it would be to code your connectivity manually.
GAJ|||I currently have 2 GB physical memory which could last for
about 2 to 3 days if no one runs a big report. What if I
increase the memory size to 4 GB?

>--Original Message--
>not really.
>acccess bound controls open numerous connections PER FORM.
>this is not good.
>only way to fix it would be to code your connectivity
manually.
>
>GAJ
>
>.
>|||I suspect you will still eventually run out of connections and\or memory.
instead of using bound controls, write the code manually to populate
controls. that way you have explicit control over connection management.
will this work for you ?
GAJ|||Ken,
Are you sure it is really a memory leak? SQL Server will not release memory
once it grabs it unless the OS specifically calls for it. That is by
design. http://www.support.microsoft.com/?id=321363 Do you have things
other than sql server running on the same machine? If so you may want to
set your max memory setting to something less than the default of max and
see if that helps.
Andrew J. Kelly
SQL Server MVP
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:bf6601c3ecfa$9f12e2a0$a401280a@.phx.gbl...
> I got about 50 Access users every day using the SQL Server
> 2000 database. At the end of the day, SQL Server always
> ran out of the memory. Someone told me this is because of
> the bound connection on the Access form causing the memory
> leak. Is there a way to fix this problem without changing
> my Access form design.

Bound Control on Access Form Causing High Memory Usage on SQL Server

I got about 50 Access users every day using the SQL Server
2000 database. At the end of the day, SQL Server always
ran out of the memory. Someone told me this is because of
the bound connection on the Access form causing the memory
leak. Is there a way to fix this problem without changing
my Access form design.not really.
acccess bound controls open numerous connections PER FORM.
this is not good.
only way to fix it would be to code your connectivity manually.
GAJ|||I currently have 2 GB physical memory which could last for
about 2 to 3 days if no one runs a big report. What if I
increase the memory size to 4 GB?
>--Original Message--
>not really.
>acccess bound controls open numerous connections PER FORM.
>this is not good.
>only way to fix it would be to code your connectivity
manually.
>
>GAJ
>
>.
>|||I suspect you will still eventually run out of connections and\or memory.
instead of using bound controls, write the code manually to populate
controls. that way you have explicit control over connection management.
will this work for you ?
GAJ|||Ken,
Are you sure it is really a memory leak? SQL Server will not release memory
once it grabs it unless the OS specifically calls for it. That is by
design. http://www.support.microsoft.com/?id=321363 Do you have things
other than sql server running on the same machine? If so you may want to
set your max memory setting to something less than the default of max and
see if that helps.
--
Andrew J. Kelly
SQL Server MVP
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:bf6601c3ecfa$9f12e2a0$a401280a@.phx.gbl...
> I got about 50 Access users every day using the SQL Server
> 2000 database. At the end of the day, SQL Server always
> ran out of the memory. Someone told me this is because of
> the bound connection on the Access form causing the memory
> leak. Is there a way to fix this problem without changing
> my Access form design.

Bottom half of Page Not Found

I have RS2k on SQL2k for several months with no issues, all users can access
reports for which they have been granted access.
I have one new user lately that has not been able to access a report that he
has been granted access to.
He clicks the link to the report server http://servername.domain.com/reports
and gets directed to the Home folder where he can see the report folder he
needs.
Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
the two linked reports that his user group has been granted access to. When
he clicks the hyperlink to either of these two reports, the header fo the
site (that has the breadcrumb bar) is still viewable, but the part of the
page that would normally show the "report is generating" message does not
appear and instead he gets a 'Page Not Found' error.
I have tried granting access to his username specifically, but no success.
I have looked at the web.config file but did not make any changes
(Impersonate is set to true, but no username or password is specified which
should cause the logged on user credentials to pass through.)
No other users are having this issue.
The reports are linked to reports in another folder which he does not have
access to.
Any suggestions?
Thanks.2 Other things:
1. Actual error message is "The Page Cannot Be Displayed. The page you are
looking for is currently unavailable..."
2. User is getting the same experience on other reports as well.
"Phillip" wrote:
> I have RS2k on SQL2k for several months with no issues, all users can access
> reports for which they have been granted access.
> I have one new user lately that has not been able to access a report that he
> has been granted access to.
> He clicks the link to the report server http://servername.domain.com/reports
> and gets directed to the Home folder where he can see the report folder he
> needs.
> Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
> the two linked reports that his user group has been granted access to. When
> he clicks the hyperlink to either of these two reports, the header fo the
> site (that has the breadcrumb bar) is still viewable, but the part of the
> page that would normally show the "report is generating" message does not
> appear and instead he gets a 'Page Not Found' error.
> I have tried granting access to his username specifically, but no success.
> I have looked at the web.config file but did not make any changes
> (Impersonate is set to true, but no username or password is specified which
> should cause the logged on user credentials to pass through.)
> No other users are having this issue.
> The reports are linked to reports in another folder which he does not have
> access to.
> Any suggestions?
> Thanks.

Bother switching from MSDE to Access database?

We wrote our .Net 2.0 application using MSDE.
However, the demo programs we have sent out
many times have trouble installing MSDE on the
customer's computer.
We are thinking about converting our database from
MSDE to access because of this practical problem.
The question is this:
Will the sql server 2005 replacement for MSDE have
an easier time installing than MSDE?
thanks in advance
jay
jay w
jay,
I'll let the SQL Server experts here address the installation issues of SQL
Express. My limited experience with Express is that it is an easier install.
But if you're considering Access I thought you might be interested in SQL
Server Compact Edition:
http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en
Although the current download is RC1, release is expected for the first week
in December. Installation can be as simple as copying a few DLLs and a
database is a single file, but you would need to change your .NET 2.0 code
slightly to use the SqlCe namespace rather than SqlClient. SQL Compact also
does not support stored procedures or triggers, but then neither does
Access.
Ginny Caughey
Device Application Development MVP
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w
|||For SQL Express the setup has been completely rewritten but it still uses
the Windows installer technology so there are places where it can fail. For
demo purposes you might want to look at SQL Server Compact Edition. It is
smaller and simpler than SQL Express or Access. It doesn't have all the
features of SQL Server Express but it is more compatible than Access would
be.
http://msdn2.microsoft.com/en-us/library/ayee3tzx.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w
|||This article may provide you some pointers about using Unattended
installations with SQL Server.
SQL Server 2005 UnAttended Installations
http://www.devx.com/dbzone/Article/31648
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w