When a report item is hidden, its document map still shows. I would like to
access the hidden attribute of the item (in this case they can be table or
chart, but I believe the model to be the same). I can't seem to find the
object model how to access that attribute. I tried ReportItems!table1.hidden,
ReportItems!table1.visible, ReportItems!table1.Visibility and they all say
those attributes do not belong to the member. Anyone can point me to the doc?
I'll try to dig around and find the dll for reporting services and see if
object browser might help.
Thanks.Hide document map label using expression
Showing posts with label access. Show all posts
Showing posts with label access. Show all posts
Wednesday, March 28, 2012
Hide databases in EM/QA
I have a MSSQL 2000 SP4 with ~200 databases of our clients.
Each client can access only his own database, but in Enterprise Manager
he able to view all databases on server.
How can I hide all other databases from client?Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
Analyzer, you will find that almost impossible.
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
<slousch@.gmail.com> wrote in message
news:1161762813.020209.171520@.f16g2000cwb.googlegroups.com...
>I have a MSSQL 2000 SP4 with ~200 databases of our clients.
> Each client can access only his own database, but in Enterprise Manager
> he able to view all databases on server.
> How can I hide all other databases from client?
>|||This is only true for Enterprise Manager. The users will be
able to see all the user databases although they can only
access those that they have been granted access to
explicitly or implicitly (groups, guest account
considerations).
In Query Analyzer, the databases will be restricted or
filtered to those which the user has access to.
-Sue
On Wed, 25 Oct 2006 12:18:33 -0700, "Arnie Rowland"
<arnie@.1568.com> wrote:
>Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
>Analyzer, you will find that almost impossible.|||Sue,
Maybe I'm doing something wrong, but this seems to work and provide a list
of all databases on the server EVEN if the login does not have permissions
for the database.
SELECT name
FROM master..sysdatabases
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:t810k2dq7tpgrmsi4lkvivgvevss73fs7a@.
4ax.com...
> This is only true for Enterprise Manager. The users will be
> able to see all the user databases although they can only
> access those that they have been granted access to
> explicitly or implicitly (groups, guest account
> considerations).
> In Query Analyzer, the databases will be restricted or
> filtered to those which the user has access to.
> -Sue
> On Wed, 25 Oct 2006 12:18:33 -0700, "Arnie Rowland"
> <arnie@.1568.com> wrote:
>
>|||That does not affect the view. Look at the available
databases in QA from the databases drop down.
-Sue
On Wed, 25 Oct 2006 22:48:19 -0700, "Arnie Rowland"
<arnie@.1568.com> wrote:
>Sue,
>Maybe I'm doing something wrong, but this seems to work and provide a list
>of all databases on the server EVEN if the login does not have permissions
>for the database.
>SELECT name
>FROM master..sysdatabases|||While I agree that the databases won't show up in the Object Explorer, I
read the OP's question as "How can I hide all other databases from client?",
and I replied that that was virtually impossible.
Your rejoinder seems to indicate to the OP that is was safe to use QA since
"the databases will be restricted or filtered to those which the user has
access to."
And I disagree that is it possible to 'hide all other databases" while using
QA.
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:mr91k2921p9mn4ousa61lj4govgj0brt44@.
4ax.com...
> That does not affect the view. Look at the available
> databases in QA from the databases drop down.
> -Sue
> On Wed, 25 Oct 2006 22:48:19 -0700, "Arnie Rowland"
> <arnie@.1568.com> wrote:
>
>
Each client can access only his own database, but in Enterprise Manager
he able to view all databases on server.
How can I hide all other databases from client?Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
Analyzer, you will find that almost impossible.
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
<slousch@.gmail.com> wrote in message
news:1161762813.020209.171520@.f16g2000cwb.googlegroups.com...
>I have a MSSQL 2000 SP4 with ~200 databases of our clients.
> Each client can access only his own database, but in Enterprise Manager
> he able to view all databases on server.
> How can I hide all other databases from client?
>|||This is only true for Enterprise Manager. The users will be
able to see all the user databases although they can only
access those that they have been granted access to
explicitly or implicitly (groups, guest account
considerations).
In Query Analyzer, the databases will be restricted or
filtered to those which the user has access to.
-Sue
On Wed, 25 Oct 2006 12:18:33 -0700, "Arnie Rowland"
<arnie@.1568.com> wrote:
>Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
>Analyzer, you will find that almost impossible.|||Sue,
Maybe I'm doing something wrong, but this seems to work and provide a list
of all databases on the server EVEN if the login does not have permissions
for the database.
SELECT name
FROM master..sysdatabases
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:t810k2dq7tpgrmsi4lkvivgvevss73fs7a@.
4ax.com...
> This is only true for Enterprise Manager. The users will be
> able to see all the user databases although they can only
> access those that they have been granted access to
> explicitly or implicitly (groups, guest account
> considerations).
> In Query Analyzer, the databases will be restricted or
> filtered to those which the user has access to.
> -Sue
> On Wed, 25 Oct 2006 12:18:33 -0700, "Arnie Rowland"
> <arnie@.1568.com> wrote:
>
>|||That does not affect the view. Look at the available
databases in QA from the databases drop down.
-Sue
On Wed, 25 Oct 2006 22:48:19 -0700, "Arnie Rowland"
<arnie@.1568.com> wrote:
>Sue,
>Maybe I'm doing something wrong, but this seems to work and provide a list
>of all databases on the server EVEN if the login does not have permissions
>for the database.
>SELECT name
>FROM master..sysdatabases|||While I agree that the databases won't show up in the Object Explorer, I
read the OP's question as "How can I hide all other databases from client?",
and I replied that that was virtually impossible.
Your rejoinder seems to indicate to the OP that is was safe to use QA since
"the databases will be restricted or filtered to those which the user has
access to."
And I disagree that is it possible to 'hide all other databases" while using
QA.
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
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:mr91k2921p9mn4ousa61lj4govgj0brt44@.
4ax.com...
> That does not affect the view. Look at the available
> databases in QA from the databases drop down.
> -Sue
> On Wed, 25 Oct 2006 22:48:19 -0700, "Arnie Rowland"
> <arnie@.1568.com> wrote:
>
>
Hide Database in SQL SErver 2000
Dear All
I have a question on the security control of sql server 2000.
Now I set a specified sql account can access corresponding database only,
however, how can I hide other database that he not allowed to access, as
well as master, tempdb and other system database?
ThanksYou cannot do that in SQL Server 2000 but only in SQL Server 2005
"a" <a@.l.q> wrote in message
news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Dear All
> I have a question on the security control of sql server 2000.
> Now I set a specified sql account can access corresponding database only,
> however, how can I hide other database that he not allowed to access, as
> well as master, tempdb and other system database?
> Thanks
>|||o....thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uu$cIZIBGHA.1032@.TK2MSFTNGP11.phx.gbl...
> You cannot do that in SQL Server 2000 but only in SQL Server 2005
>
> "a" <a@.l.q> wrote in message
> news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
only,[vbcol=seagreen]
>
I have a question on the security control of sql server 2000.
Now I set a specified sql account can access corresponding database only,
however, how can I hide other database that he not allowed to access, as
well as master, tempdb and other system database?
ThanksYou cannot do that in SQL Server 2000 but only in SQL Server 2005
"a" <a@.l.q> wrote in message
news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Dear All
> I have a question on the security control of sql server 2000.
> Now I set a specified sql account can access corresponding database only,
> however, how can I hide other database that he not allowed to access, as
> well as master, tempdb and other system database?
> Thanks
>|||o....thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uu$cIZIBGHA.1032@.TK2MSFTNGP11.phx.gbl...
> You cannot do that in SQL Server 2000 but only in SQL Server 2005
>
> "a" <a@.l.q> wrote in message
> news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
only,[vbcol=seagreen]
>
Hide Breadcrumbs
My users access SQL reports via weblinks from a Sharepoint portal. Even
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
Monday, March 26, 2012
Hide an ODBC connection?
We've purchased a 3rd party app that uses an Access db linked to SQL Server. Unfortunately, we've come to discover that a user of ours seems to know access and has decided to take report writing into their own hands.
We have the app and the access db on a server and a mapped a drive for each user.
Unfortunately, I can't lock down the ODBC connection because that would lock it down in the app. Someone suggested using a File DSN and removing the System DSN's off all users machines. I'm not too familiar with File DSN's and wanted to know if this would prevent users from creating their own Access mdb's linked to my server or not.
Any idea's are greatly appreciated.Dude,
Bad news :( - unless you can stop the end user from hacking the registry and prevent access to the odbcad32 (which you really can't lock out and have the machine access the server) there isn't much you can do AFAIK.
You didn't mention what OS's are in play. If you are a Win2k/WinXP shop you may be able to build a policy that limits the user from adding a new DSN, but I doubt even a file DSN will really stop him. If you go look in C:\Program Files\Common Files\ODBC\Data Sources All they really do is point to the system DSN. And he'll be able to pick it in Access.|||I figured the answer would go something like that.
Thank you anyways.
We have the app and the access db on a server and a mapped a drive for each user.
Unfortunately, I can't lock down the ODBC connection because that would lock it down in the app. Someone suggested using a File DSN and removing the System DSN's off all users machines. I'm not too familiar with File DSN's and wanted to know if this would prevent users from creating their own Access mdb's linked to my server or not.
Any idea's are greatly appreciated.Dude,
Bad news :( - unless you can stop the end user from hacking the registry and prevent access to the odbcad32 (which you really can't lock out and have the machine access the server) there isn't much you can do AFAIK.
You didn't mention what OS's are in play. If you are a Win2k/WinXP shop you may be able to build a policy that limits the user from adding a new DSN, but I doubt even a file DSN will really stop him. If you go look in C:\Program Files\Common Files\ODBC\Data Sources All they really do is point to the system DSN. And he'll be able to pick it in Access.|||I figured the answer would go something like that.
Thank you anyways.
Hidden User?
Did a remote backup of a database used to run a live website.
Restored the database to my local MSDE installation.
Now cannot access the local database using the user login FRED, which is the
same as the website, as I use it for local testing. Get error message:
cannot open user default database login failed.
Cannot see FRED the user anywhere, yet if I look under Roles, FRED is listed
as a db_owner.
If try and add FRED, get error saying User or Role already exists on this
database.
How can I reactivate FRED on my local server?
hi Kevin,
"Kevin" <kevgrim@.tesco.net> ha scritto nel messaggio
news:%23BNg60wdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Did a remote backup of a database used to run a live website.
> Restored the database to my local MSDE installation.
> Now cannot access the local database using the user login FRED, which is
the
> same as the website, as I use it for local testing. Get error message:
> cannot open user default database login failed.
> Cannot see FRED the user anywhere, yet if I look under Roles, FRED is
listed
> as a db_owner.
> If try and add FRED, get error saying User or Role already exists on this
> database.
> How can I reactivate FRED on my local server?
>
this problem is known as "orphaned users"... you can have a look at a
perfect article by Neil Boyl abot the matter at
http://www.sqlservercentral.com/colu...okenlogins.asp
the system stored procedure sp_chang_users_logins use is explained for
solving your trouble
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Restored the database to my local MSDE installation.
Now cannot access the local database using the user login FRED, which is the
same as the website, as I use it for local testing. Get error message:
cannot open user default database login failed.
Cannot see FRED the user anywhere, yet if I look under Roles, FRED is listed
as a db_owner.
If try and add FRED, get error saying User or Role already exists on this
database.
How can I reactivate FRED on my local server?
hi Kevin,
"Kevin" <kevgrim@.tesco.net> ha scritto nel messaggio
news:%23BNg60wdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Did a remote backup of a database used to run a live website.
> Restored the database to my local MSDE installation.
> Now cannot access the local database using the user login FRED, which is
the
> same as the website, as I use it for local testing. Get error message:
> cannot open user default database login failed.
> Cannot see FRED the user anywhere, yet if I look under Roles, FRED is
listed
> as a db_owner.
> If try and add FRED, get error saying User or Role already exists on this
> database.
> How can I reactivate FRED on my local server?
>
this problem is known as "orphaned users"... you can have a look at a
perfect article by Neil Boyl abot the matter at
http://www.sqlservercentral.com/colu...okenlogins.asp
the system stored procedure sp_chang_users_logins use is explained for
solving your trouble
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 21, 2012
Hi have u got any solution on this...! if yes then pls reply me on abhijeettidke@gmail.com
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
\Program Files\nddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
Did you ever find an answer to your problem? I am experiencing the very same thing.If I reference a local sdf it works fine, but if I reference the sdf located on the CE device, I get the same error as you.
|||
Windows CE devices (including emulator – simulated device) don't support drive letters (see that "D:\" in the path above? That makes it invalid on CE), don't support relative paths (that is, all paths must be full and absolute) and can't see your desktop hard drive (not by drive letter anyway). Common way to get absolute path is to append database name to the path to the application itself as done above.
Naturally, database on desktop won’t be updated because device has no idea it even exists. It changes database on device file system and it’s up to you to copy changed database from device file system to desktop file system as needed.
Now to using database on device from desktop application: that won’t work because there’s no way to reference database on device in desktop application; device is not mapped as desktop file system. Active Sync explorer extension simply fakes it. Visual Studio does that via special remote provider which is not public. If you want to access database on device then copy it to local file system (e.g. using RAPI), access it, and then copy it back to device. See this.
|||
If u got any soln on above please share this wiht me
My ID is abhijeettidke@.gmail.com
Hi Everyone
trying to login to ... SQL.Exception occurs
The result is SQL Server does not exist or access denied . . .
The code Im working with connection string is a forum fix from
http://p2p.wrox.com/topic.asp?TOPIC_ID37898
and the user account has been established.
<appSettings>
<add key="connection String" Value="server=(local)\MYSQLSERVERNAME; database=bids; Trusted_Connection=true"/>
</appSetting>
SQL Service Manager shows Server: SNOEMASTER
Services: MSSQLServerOLAPService
SQL Server Enterprise Manager indicates my SQL Server Group consists of
(local) (Windows NT)
and somewhere along the line I ran into something telling me to rename
(local) (windows NT) = MSSQLServer
Although when I do switch it over through the new registration wizard the connection fails. Stating MSSQLServer does not exist and come up with a error 1722 (RPC Server Unavailable) although in componet services it shows it running.
Initially I tried correctinig this because SQL SERVER repilcation does not support nicknames such as "." or (local) as server names and was given a message to
DELETE THE SQL SERVER REGISTRATION FOR THE SERVER AND REGISTER IT USING THE ACTUAL SERVER NAME MSSQLServer which component services confirmed in the properties tab "Dispaly Name" = MSSQLSERVER.
The problem seems to become two -fold because in the above connection string it maintains (local) as part of the string and instructs me to add on MYSQLSERVERNAME. ex. (local)\MYSQLSERVERNAME; database="bids"
Note: The database folder is named Bid.
Thanks for any input on this one anyone.
What you need to do is to replace MYSQLSERVERNAME with whatever your instance name is. If your SQL Server is the default instance, then user (local) or . directly rather than (local)\MSSQLSERVER or .\MSSQLSERVER
|||
Thank You!
i'm getting an access denied error but i can reset the user property from here. its better then the other errors I was recieving!
It clears up alot.! will make additional instance's of it in the future, one step at a time of course. I just installed SQL 2000 recently and want to make sure i have a solid understanding of what was happening.
http://192.168.1.65/Bid/default.aspx
icon_snowman
|||
After having reinstalled the Bid database and set the IUSR_SNOEMASTER permissions for the it from the SQL enterprise manager Bid \Properties\Security directory , i'm still recieving the double error . SQL server does not exist or access is denied..
I tried several combinations off the above resolution you mentioned but , not working yet. Will try Later.
On the second try I recieved a popup box to remember the passwaord and a confirmation that the user was added to the pool although checking the web.config file I realized I did not replace its original extension and had left it at web.txt to edit it.
Ohhhh is me
|||Latest SQL.Exception recieved using
<appSettings>
<add key="ConnectionString" value="server=(local);database=bids;Trusted_Connection=true" />
</appSettings>
Anyone have any ideas or previous same problem.?
icon_snowman
|||From your latest error, your client is able to find the SQL server. The new problem is that you login account may not have login privilege to the database "bids". In order to login successfully, the login account must have login priviledge to the initial database (i.e. bids for your case).|||In the above example the user (IUSER_SNOEMASTER) was left out of the connection string on purpose.
If I include the user in the connection string ( value="server=(local)\(IUSR_SNOEMASTER);databes=bids; . . . )then the error SQL Server does not exsist or access is denied to the user.
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.CreateConnection() at System.Data.SqlClient.ConnectionPool.UserCreateRequest() at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction
SQL Server Enterprise Manager:
Console Root|Microsoft SQL Servers|SQL Server Group|(local)(Windows NT)|Databases||bid|Users
In the right pane windows "Login Name" SNOEMASTER\ISUR_SNOEMASTER
"Database Access" status is Permit
If I use value="server=(local)\(SNOEMASTER\IUSR_SNOEMASTER); database=bids the following error occurs
Server Error in '/bid' Application.
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: Access is denied: 'Bid'.
Source Error:
|
Source File: c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 258
Assembly Load Trace: The following information can be helpful to determine why the assembly 'Bid' could not be loaded.
|
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Using the code below:
<appSettings>
<add key="ConnectionString" value="server=(local);database=bids;Trusted_Connection=true" />
</appSettings>
<appSettings>
<add key="ConnectionString" value="server=.\;database=bids;Trusted_Connection=true" />
</appSettings>
The following error is created:
System.Data.SqlClient.SqlException: Cannot open database requested in login 'bids'. Login fails. Login failed for user 'SNOEMASTER\IUSR_SNOEMASTER'. at System.Data.SqlClient.ConnectionPool.CreateConnection() at System.Data.SqlClient.ConnectionPool.UserCreateRequest() at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction
|||
server=(local)\(IUSR_SNOEMASTER);
Here (IUSR_SNOEMASTER) should be the instance name, NOT USER ACCOUNT. If your SQL Server is a default instance, then just use "(local)" or "." The client user account is determined by under which Windows account your client application is running if Windows authentication is used. From your last exemple, it looks like you have a default instance and your client app is running under 'SNOEMASTER\IUSR_SNOEMASTER'. So, you need to make sure this account has login priviledge to database "bids", as I said before.
OK Have Login Working:
<appSettings>
<add key="ConnectionString" value="server=(local);database=Bid;Trusted_Connection=true" />
</appSettings>
The problem was that the database=bids was not allowing it to access the Bid folder.
Initially building the data base as prescribed in the http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?the query uses a plural version of the database "bids" so I continued with this in the connection string. Doesnt work. I read about two lines in the SQL Server Books Online stating that the database names are case sensitive and made the adjustment from bids=Bid and a slight adjustment in the permissions by :
Console Root|Microsoft SQL Servers|(local)(Windows NT)|Databases|bid
In the right-hand pane right clicked properties, highlight SNOEMASTER\IUSR_SNOEMASTER
Clicked Permissions and set settings as instructed http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?
Clicked Ok then clicked Properties on the bottom. Check that Public is selected.(For what ever reason mine was not. Possibly an over sight having reinstalled the database and permissions.)
Once again set the settings as instructed http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?and clicked apply and OK and everything seems to be running as it is supposed to.
Thank You Xinwei Hong your response helped me sort it out. Knowing better I should have immediately changed bids=Bid If you recall I made a note of this in my first post at the bottom of the name difference.
Monday, March 12, 2012
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set
Hi,
I have a problem with linked servers.
I have an application running against a SQLServer 2005 Express. For some limitations, I had to access from the same application to another database, but I cannot change to another server.
So I have 2 created a second instances, where the first one refers the second one and I created synonyms in the first one to access to all the objects in the second one, to emulate a database in the first instances, but running on the second one. The final idea is to move to another server, but for the testing I use another instance.
But when I try to access to the aplication database, I hav the following error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
I searched solutions for this issue, but I only found to add SET ANSI_NULLS ON and SET ANSI_WARNINGS ON to my connection, before the queries, but I can't, because I cannot change the application.
If anyone can help me, I'd be veri greatfull
Best regards, ArielAriel,
I had a similar problem with SQL 2000 when I added a stored procedure to access the data on a linked server. I had created the stored proc through Query Analyzer and the work around was to create the stored proc through Enterprise Manager. Once I created within Enterprise Manager it worked.
A google search of this problem will provide results.|||The problem is the application have a lot of SPs, tables and views I have created the synonims.
The problem is only with the SPs?
If that, I can remove the synonims and create SPs that access the original ones.
Thanks, Ariel
I have a problem with linked servers.
I have an application running against a SQLServer 2005 Express. For some limitations, I had to access from the same application to another database, but I cannot change to another server.
So I have 2 created a second instances, where the first one refers the second one and I created synonyms in the first one to access to all the objects in the second one, to emulate a database in the first instances, but running on the second one. The final idea is to move to another server, but for the testing I use another instance.
But when I try to access to the aplication database, I hav the following error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
I searched solutions for this issue, but I only found to add SET ANSI_NULLS ON and SET ANSI_WARNINGS ON to my connection, before the queries, but I can't, because I cannot change the application.
If anyone can help me, I'd be veri greatfull
Best regards, ArielAriel,
I had a similar problem with SQL 2000 when I added a stored procedure to access the data on a linked server. I had created the stored proc through Query Analyzer and the work around was to create the stored proc through Enterprise Manager. Once I created within Enterprise Manager it worked.
A google search of this problem will provide results.|||The problem is the application have a lot of SPs, tables and views I have created the synonims.
The problem is only with the SPs?
If that, I can remove the synonims and create SPs that access the original ones.
Thanks, Ariel
heterogeneous Function
Hello Everyone,
I have a procedure which returns profits made by sales persons.
for this I need to access 2 data bases.
to calculate the profit I have written a function on one of the databases
but I get an error asking me to set ANSI_NULLS and ANSI_WARNINGS. when I set
these I get syntax error.
Am I missing to do something here.
Any help is greatly appreciated.
Rose.Without a repro, here is a guess: Make sure you have the settings while
creating the function.
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
CREATE FUNCTION ufn_test(...
...
GO
Anith
I have a procedure which returns profits made by sales persons.
for this I need to access 2 data bases.
to calculate the profit I have written a function on one of the databases
but I get an error asking me to set ANSI_NULLS and ANSI_WARNINGS. when I set
these I get syntax error.
Am I missing to do something here.
Any help is greatly appreciated.
Rose.Without a repro, here is a guess: Make sure you have the settings while
creating the function.
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
CREATE FUNCTION ufn_test(...
...
GO
Anith
Here's the answer ... figured it out myself
I'm quite addicted to Patterns-&-Practices Enterprise.Library.Data module, but I can't get it to access a SQL Server Express Database. I've tried several different .CONFIG files and a unch of different settings and I keep getting:
The local database "XXYYZZ" is not defined in configuration.
I'm using Visual Studio 2005 C# in a WinForms application.
Can Microsoft.Practices.EnterpriseLibrary.Data access SQL Server Express Database?
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
</configSections>
<dataConfiguration defaultDatabase="Connection String" />
<connectionStrings>
<add name="myDb" connectionString="Database=Database;Server=(local)\SQLEXPRESS;AttachDbFilename=C:\myDir\myDBname.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
- and it's use
Database db = DatabaseFactory.CreateDatabase("myDb");
DbCommand dbC = db.GetStoredProcCommand("mySPname");
db.AddInParameter(dbC, "MyParameterName", DbType.Int32, MyIntVal);
DataSet ds = db.ExecuteDataSet(dbC);
Needs this stuff too ...
using System.Data;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
|||As the Elib cannot find the "mydb" entry, it seems that the ELIB is requesting the wrong (in terms of your thinking) .config file. See if you are pointing to the right config file.Jens K. Suessmeyer. http://www.sqlserver2005.de
Wednesday, March 7, 2012
HELP:SQL Port lost or never set on new install
I just installed SQL Server on XP (SP2) attempted to access the Server
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc. SQL
service is running in the tasklist but the port doesn't show in netstat.
I turned all firewalls off, disconnected the internet and still no port. The
problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
remote access turned off by default
http://msdn2.microsoft.com/en-us/library/ms178763.aspx
is SQL2k check the SQL Errorlog \ Windows Application for Errors
cheers,
Andy.
"jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>I just installed SQL Server on XP (SP2) attempted to access the Server
> through JDBC and got a error abut the socket connect. After much searching
> I
> find that the port is not active even though all app that would set the
> port
> have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc.
> SQL
> service is running in the tasklist but the port doesn't show in netstat.
> I turned all firewalls off, disconnected the internet and still no port.
> The
> problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
>|||The errorlog has it listening on Shared Memory, & Named Pipes even though
Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility
.
I tried to scrambble the protocols by disabling and restarting the server,
but the TCP/IP protocol doesn't show.
"Andy Ball" wrote:
> its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
> remote access turned off by default
> http://msdn2.microsoft.com/en-us/library/ms178763.aspx
> is SQL2k check the SQL Errorlog \ Windows Application for Errors
> cheers,
> Andy.
>
> "jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
> news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>
>|||Problem solved with the SP4 update.
"jlopes151" wrote:
[vbcol=seagreen]
> The errorlog has it listening on Shared Memory, & Named Pipes even though
> Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utili
ty.
> I tried to scrambble the protocols by disabling and restarting the server,
> but the TCP/IP protocol doesn't show.
> "Andy Ball" wrote:
>
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc. SQL
service is running in the tasklist but the port doesn't show in netstat.
I turned all firewalls off, disconnected the internet and still no port. The
problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
remote access turned off by default
http://msdn2.microsoft.com/en-us/library/ms178763.aspx
is SQL2k check the SQL Errorlog \ Windows Application for Errors
cheers,
Andy.
"jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>I just installed SQL Server on XP (SP2) attempted to access the Server
> through JDBC and got a error abut the socket connect. After much searching
> I
> find that the port is not active even though all app that would set the
> port
> have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc.
> SQL
> service is running in the tasklist but the port doesn't show in netstat.
> I turned all firewalls off, disconnected the internet and still no port.
> The
> problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
>|||The errorlog has it listening on Shared Memory, & Named Pipes even though
Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility
.
I tried to scrambble the protocols by disabling and restarting the server,
but the TCP/IP protocol doesn't show.
"Andy Ball" wrote:
> its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
> remote access turned off by default
> http://msdn2.microsoft.com/en-us/library/ms178763.aspx
> is SQL2k check the SQL Errorlog \ Windows Application for Errors
> cheers,
> Andy.
>
> "jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
> news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>
>|||Problem solved with the SP4 update.
"jlopes151" wrote:
[vbcol=seagreen]
> The errorlog has it listening on Shared Memory, & Named Pipes even though
> Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utili
ty.
> I tried to scrambble the protocols by disabling and restarting the server,
> but the TCP/IP protocol doesn't show.
> "Andy Ball" wrote:
>
HELP:SQL Port lost or never set on new install
I just installed SQL Server on XP (SP2) attempted to access the Server
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc. SQL
service is running in the tasklist but the port doesn't show in netstat.
I turned all firewalls off, disconnected the internet and still no port. The
problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
remote access turned off by default
http://msdn2.microsoft.com/en-us/library/ms178763.aspx
is SQL2k check the SQL Errorlog \ Windows Application for Errors
cheers,
Andy.
"jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>I just installed SQL Server on XP (SP2) attempted to access the Server
> through JDBC and got a error abut the socket connect. After much searching
> I
> find that the port is not active even though all app that would set the
> port
> have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc.
> SQL
> service is running in the tasklist but the port doesn't show in netstat.
> I turned all firewalls off, disconnected the internet and still no port.
> The
> problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
>
|||The errorlog has it listening on Shared Memory, & Named Pipes even though
Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility.
I tried to scrambble the protocols by disabling and restarting the server,
but the TCP/IP protocol doesn't show.
"Andy Ball" wrote:
> its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
> remote access turned off by default
> http://msdn2.microsoft.com/en-us/library/ms178763.aspx
> is SQL2k check the SQL Errorlog \ Windows Application for Errors
> cheers,
> Andy.
>
> "jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
> news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>
>
|||Problem solved with the SP4 update.
"jlopes151" wrote:
[vbcol=seagreen]
> The errorlog has it listening on Shared Memory, & Named Pipes even though
> Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility.
> I tried to scrambble the protocols by disabling and restarting the server,
> but the TCP/IP protocol doesn't show.
> "Andy Ball" wrote:
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc. SQL
service is running in the tasklist but the port doesn't show in netstat.
I turned all firewalls off, disconnected the internet and still no port. The
problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
remote access turned off by default
http://msdn2.microsoft.com/en-us/library/ms178763.aspx
is SQL2k check the SQL Errorlog \ Windows Application for Errors
cheers,
Andy.
"jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>I just installed SQL Server on XP (SP2) attempted to access the Server
> through JDBC and got a error abut the socket connect. After much searching
> I
> find that the port is not active even though all app that would set the
> port
> have port 1433 set. If you follow. I ran netstat -ano and tasklist /svc.
> SQL
> service is running in the tasklist but the port doesn't show in netstat.
> I turned all firewalls off, disconnected the internet and still no port.
> The
> problem doesn't seem to be with the Firewall but XP SP2 & SQLServer.
>
|||The errorlog has it listening on Shared Memory, & Named Pipes even though
Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility.
I tried to scrambble the protocols by disabling and restarting the server,
but the TCP/IP protocol doesn't show.
"Andy Ball" wrote:
> its not SQL Server 2005 is it ? Most versions (Dev, Express, Eval) have
> remote access turned off by default
> http://msdn2.microsoft.com/en-us/library/ms178763.aspx
> is SQL2k check the SQL Errorlog \ Windows Application for Errors
> cheers,
> Andy.
>
> "jlopes151" <jlopes151@.discussions.microsoft.com> wrote in message
> news:363D1BB3-69C2-49E3-A77B-660117628D48@.microsoft.com...
>
>
|||Problem solved with the SP4 update.
"jlopes151" wrote:
[vbcol=seagreen]
> The errorlog has it listening on Shared Memory, & Named Pipes even though
> Named Pipes & TCP/IP protocols are enabled in the SQL Network Server Utility.
> I tried to scrambble the protocols by disabling and restarting the server,
> but the TCP/IP protocol doesn't show.
> "Andy Ball" wrote:
HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
\Program Files\nddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
Did you ever find an answer to your problem? I am experiencing the very same thing.If I reference a local sdf it works fine, but if I reference the sdf located on the CE device, I get the same error as you.
|||
Windows CE devices (including emulator – simulated device) don't support drive letters (see that "D:\" in the path above? That makes it invalid on CE), don't support relative paths (that is, all paths must be full and absolute) and can't see your desktop hard drive (not by drive letter anyway). Common way to get absolute path is to append database name to the path to the application itself as done above.
Naturally, database on desktop won’t be updated because device has no idea it even exists. It changes database on device file system and it’s up to you to copy changed database from device file system to desktop file system as needed.
Now to using database on device from desktop application: that won’t work because there’s no way to reference database on device in desktop application; device is not mapped as desktop file system. Active Sync explorer extension simply fakes it. Visual Studio does that via special remote provider which is not public. If you want to access database on device then copy it to local file system (e.g. using RAPI), access it, and then copy it back to device. See this.
|||
If u got any soln on above please share this wiht me
My ID is abhijeettidke@.gmail.com
Monday, February 27, 2012
HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
\Program Files\nddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
Moving to SQL Server Compact Edition forum where it has got better chances of being answered.
-Thanks,
Mohit
|||You can only access files located on the emulator, not your local drives. You have to copy or create the sdf file in the emulator in the desired location. There is no C: drive or D: drive in the emulator, just a "\" rootHELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
\Program Files\nddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
Did you ever find an answer to your problem? I am experiencing the very same thing.If I reference a local sdf it works fine, but if I reference the sdf located on the CE device, I get the same error as you.
|||
Windows CE devices (including emulator – simulated device) don't support drive letters (see that "D:\" in the path above? That makes it invalid on CE), don't support relative paths (that is, all paths must be full and absolute) and can't see your desktop hard drive (not by drive letter anyway). Common way to get absolute path is to append database name to the path to the application itself as done above.
Naturally, database on desktop won’t be updated because device has no idea it even exists. It changes database on device file system and it’s up to you to copy changed database from device file system to desktop file system as needed.
Now to using database on device from desktop application: that won’t work because there’s no way to reference database on device in desktop application; device is not mapped as desktop file system. Active Sync explorer extension simply fakes it. Visual Studio does that via special remote provider which is not public. If you want to access database on device then copy it to local file system (e.g. using RAPI), access it, and then copy it back to device. See this.
|||
If u got any soln on above please share this wiht me
My ID is abhijeettidke@.gmail.com
Friday, February 24, 2012
Help: MS Access to SQL Server 2005 using SSMA
I am new to databases and need some info that I'm having trouble researching. I just migrated a access database to SQL server 2005 using SQL Server Migration assistant (SSMA). I wondered how SSMA handles NULL values? Also how it treats differences between Access and SQL? Any help would be appreciated.
SSMA will create a table in SQL Server that has equivalent fields to those in Access and then transfer the data. So if you have a Text field in Access that is not Required (i.e. it allows NULL values) you will get an NVarchar(255) filed in SQL with the Nullable property set to True. When the data is migrated, the NULLs will be migrated as well.
Mike
Sunday, February 19, 2012
HELP: Crystal Report 8 with Acces 2003
Am I missing something?
I am trying to run a crystal 8 report, wich is feeded from a access 2003 database, this is done trough a vb 5 - program. It works all right on my computer (win 98) where Crystal Report 8 is installed.
But it doesn't work on my Win XP - computer (Here i don't want to install Crystal Report 8, because it has to run on other machines too), i am trying to install the needed files to make this work. So far I installed the following files:
[Files]
File1=1,,CRVIEWER.DL_,CRVIEWER.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 16:19:24,509328,8.0.0.371,"","",""
File2=1,,CRAXDRT.DL_,CRAXDRT.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 15:16:48,5550080,8.0.0.371,"","",""
File3=1,,IMPLODE.DL_,IMPLODE.DLL,$(WinSysPath),,$(Shared),11/18/1996 1:00:00,18944,1.0.0.1,"","",""
File4=1,,CRPAIG80.DL_,CRPAIG80.DLL,$(WinSysPath),,$(Shared),1/11/2000 7:09:56,618496,8.0.0.11,"","",""
File5=1,,sscsdk80.dl_,sscsdk80.dll,$(WinSysPath),,$(Shared),12/10/1999 15:24:30,974848,2.2.0.2,"","",""
File6=1,,P2SMON.DL_,P2SMON.DLL,$(WinSysPath),,$(Shared),12/15/1999 7:17:52,147456,8.0.0.15,"","",""
The strange thing is that it works allright when i use a report based , on a MS access 97 database. But when I use a report, based on a MS Access 2003 database, i get an error: "Unrecognized database format" , also i'm prompted for a password.
Does anybody know this problem?you need to redesign the report with Access 2003|||Dear Madhi
thanks for your reply, but i don't know what you exactly mean.
the report is designed with Crystal Report 8, in it there is a database connection with an MS Access 2003 mdb. As I said , this works on my win89 machine (with full crystal report on it), but not on my WinXp machine (with only the runtime files from crystal report on it.
You say that I have to redesign my report, but i'm sorry to say that I can't quit follow you there, could you be more specific?
thanks, paul|||Did you use Setup to install the application there?
If so, you need to add all the required dlls|||I think that i did that at first, but to be absolutely shure, i wil do that again.|||Mahdi
That was the problem, i didn't install all the required dll's. Now i have to sort out, wich dll was missing precisely . I wil post it here, as soon as i find out,
thanks
I am trying to run a crystal 8 report, wich is feeded from a access 2003 database, this is done trough a vb 5 - program. It works all right on my computer (win 98) where Crystal Report 8 is installed.
But it doesn't work on my Win XP - computer (Here i don't want to install Crystal Report 8, because it has to run on other machines too), i am trying to install the needed files to make this work. So far I installed the following files:
[Files]
File1=1,,CRVIEWER.DL_,CRVIEWER.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 16:19:24,509328,8.0.0.371,"","",""
File2=1,,CRAXDRT.DL_,CRAXDRT.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 15:16:48,5550080,8.0.0.371,"","",""
File3=1,,IMPLODE.DL_,IMPLODE.DLL,$(WinSysPath),,$(Shared),11/18/1996 1:00:00,18944,1.0.0.1,"","",""
File4=1,,CRPAIG80.DL_,CRPAIG80.DLL,$(WinSysPath),,$(Shared),1/11/2000 7:09:56,618496,8.0.0.11,"","",""
File5=1,,sscsdk80.dl_,sscsdk80.dll,$(WinSysPath),,$(Shared),12/10/1999 15:24:30,974848,2.2.0.2,"","",""
File6=1,,P2SMON.DL_,P2SMON.DLL,$(WinSysPath),,$(Shared),12/15/1999 7:17:52,147456,8.0.0.15,"","",""
The strange thing is that it works allright when i use a report based , on a MS access 97 database. But when I use a report, based on a MS Access 2003 database, i get an error: "Unrecognized database format" , also i'm prompted for a password.
Does anybody know this problem?you need to redesign the report with Access 2003|||Dear Madhi
thanks for your reply, but i don't know what you exactly mean.
the report is designed with Crystal Report 8, in it there is a database connection with an MS Access 2003 mdb. As I said , this works on my win89 machine (with full crystal report on it), but not on my WinXp machine (with only the runtime files from crystal report on it.
You say that I have to redesign my report, but i'm sorry to say that I can't quit follow you there, could you be more specific?
thanks, paul|||Did you use Setup to install the application there?
If so, you need to add all the required dlls|||I think that i did that at first, but to be absolutely shure, i wil do that again.|||Mahdi
That was the problem, i didn't install all the required dll's. Now i have to sort out, wich dll was missing precisely . I wil post it here, as soon as i find out,
thanks
Subscribe to:
Posts (Atom)