have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know we can access C# and other .NET Framework code, but how can you access a Java Class?
How would you access a Java class from "normal" .NET code?Niels
string strConn = "Data Source=" + "Mobile Device\\My Documents\\Nutricom.sdf";
SqlCeConnection connDB = new SqlCeConnection(strConn);
connDB.Open();
And the error i get is..
The path is not valid. Check the directory for the database. [ Path = Mobile Device\My Documents\Nutricom.sdf ]
Everytime it thorws an error saying the path is invalid and to check the locaiton of the database. Ive tried it without the "Mobile Device" bit of the string and still nothing. The database is definately in this location.
Any help? It's driving me insane.
Lewis
You can not do that as remote SQL CE provider you have to use to accomplish that is undocumented and to be used by VS only.
Local provider you’re probably using is incapable of accessing database on device as device file system is not accessible from desktop using standard APIs.
Due to licensing restrictions you can use local desktop provider only if one of the following is true:
1. You have VS 2005 installed on this PC.
2. You have SQL Server 2005 installed on this PC.
3. Your PC is running Windows XP Tablet edition.
Assuming licensing conditions are met, you can copy data base from device using RAPI, open it with local provider, change it and copy it back to the device.
|||Hi,Thank you for your reply.
I am using Visual Studio 2005. Just to clarify are you saying there is no way to access the database on the device WITHOUT coping it over using RAPI? or just that it is un-documented?
I have considered using RAPI and will look into it. However I have fears it may cause syncronisation issues so I would prefer to do it the first way if possible.
|||
Using remote SQL Mobile provider is undocumented and probably would violate your license.
However, there's always a way (complexity on scale from 1 to 10):
1. Map device storage to desktop drive (8).
2. Make sure application which uses database is stopped on device while desktop is changing copy of the data base (1).
3. Add remote data access capabilities to your application (3).
4. Use 3rd party tools if available (1).
I'd go with #3 as it's simple enough and has no licensing issues.
|||Hi,I'm afraid one again I don't fully understand 
Number 3 sounds good to me but I don't understand what you mean by "remote data access capabilities". Is there anywhere I can find further information on this?
For anyone else wanting to do something similar I found an excellent set of libraries from OpenNETCF.org that simplify the RAPI method of coping the database tot he device and back again. I'll use them if I can't get one of the methods above working.
Lewis
|||
Basically that means what somewhere in your code you need to listen on the TCP/IP port, accepting command and data from desktop and sending requested data back. It's not related to .Net platform, concept is known for 40 years or so.
There are some 3rd part products like that:
http://www.gui-innovations.com/html/remotesqlce.html
|||
Ah thank you very very much.
At least I understand my options now.
Thanks again for your patience and help.
Lewis
|||I Still Have Problem"The path is not valid. Check the directory for the database."
if any one solve this problem Tell me.
Thank You
mahyar
|||
I have developed some tools that may help you:
http://www.primeworks-mobile.com
string strConn = "Data Source=" + "Mobile Device\\My Documents\\Nutricom.sdf";
SqlCeConnection connDB = new SqlCeConnection(strConn);
connDB.Open();
And the error i get is..
The path is not valid. Check the directory for the database. [ Path = Mobile Device\My Documents\Nutricom.sdf ]
Everytime it thorws an error saying the path is invalid and to check the locaiton of the database. Ive tried it without the "Mobile Device" bit of the string and still nothing. The database is definately in this location.
Any help? It's driving me insane.
Lewis
You can not do that as remote SQL CE provider you have to use to accomplish that is undocumented and to be used by VS only.
Local provider you’re probably using is incapable of accessing database on device as device file system is not accessible from desktop using standard APIs.
Due to licensing restrictions you can use local desktop provider only if one of the following is true:
1. You have VS 2005 installed on this PC.
2. You have SQL Server 2005 installed on this PC.
3. Your PC is running Windows XP Tablet edition.
Assuming licensing conditions are met, you can copy data base from device using RAPI, open it with local provider, change it and copy it back to the device.
|||Hi,Thank you for your reply.
I am using Visual Studio 2005. Just to clarify are you saying there is no way to access the database on the device WITHOUT coping it over using RAPI? or just that it is un-documented?
I have considered using RAPI and will look into it. However I have fears it may cause syncronisation issues so I would prefer to do it the first way if possible.
|||
Using remote SQL Mobile provider is undocumented and probably would violate your license.
However, there's always a way (complexity on scale from 1 to 10):
1. Map device storage to desktop drive (8).
2. Make sure application which uses database is stopped on device while desktop is changing copy of the data base (1).
3. Add remote data access capabilities to your application (3).
4. Use 3rd party tools if available (1).
I'd go with #3 as it's simple enough and has no licensing issues.
|||Hi,I'm afraid one again I don't fully understand
Number 3 sounds good to me but I don't understand what you mean by "remote data access capabilities". Is there anywhere I can find further information on this?
For anyone else wanting to do something similar I found an excellent set of libraries from OpenNETCF.org that simplify the RAPI method of coping the database tot he device and back again. I'll use them if I can't get one of the methods above working.
Lewis
|||
Basically that means what somewhere in your code you need to listen on the TCP/IP port, accepting command and data from desktop and sending requested data back. It's not related to .Net platform, concept is known for 40 years or so.
There are some 3rd part products like that:
http://www.gui-innovations.com/html/remotesqlce.html
|||
Ah thank you very very much.
At least I understand my options now.
Thanks again for your patience and help.
Lewis
|||I Still Have Problem"The path is not valid. Check the directory for the database."
if any one solve this problem Tell me.
Thank You
mahyar
|||
I have developed some tools that may help you:
http://www.primeworks-mobile.com
Hello friends when I am working in VWD and accessing sql data this error came?
I am using asp.net visual web developer edition and sql server 2005 expressedition.
plz check it out and help me.
Exception Details:System.Data.SqlClient.SqlException: The log scan number (588:85:1) passed to log scan in database 'D:\GCAP\APP_DATA\GRIET_IT.MDF' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Could not open new database 'D:\GCAP\APP_DATA\GRIET_IT.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file D:\GCAP\App_Data\GRIET_IT.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.[SqlException (0x80131904): The log scan number (588:85:1) passed to log scan in database 'D:\GCAP\APP_DATA\GRIET_IT.MDF' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Could not open new database 'D:\GCAP\APP_DATA\GRIET_IT.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file D:\GCAP\App_Data\GRIET_IT.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +171
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2406
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +34
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +223
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +371
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +184
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +510
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +159
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +118
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +82
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1653
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +82
System.Web.UI.WebControls.ListControl.PerformSelect() +18
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
System.Web.UI.Control.PreRenderRecursiveInternal() +88
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5684
Hi radhekrishna,
The error message indicates that either the database file you are trying to attached has already been attached in sql express or there is data corruption in your database file(.mdf file) , thus the db file could not be attached. I would suggest you connect to your sql express server through management studio to make a verification (Note here that since Sql Express use customer instance, in management studio, you must login using the same account as the one you used in your application). If that db file has been attached, detach it and take another try.
If there is no such file attached already in your sql express, I would suggest you first attach that mdf file to your database. If you still get this error, it means that the mdf file is data corrupted (information in ldf file and mdf file does not match) and cannot be used anymore--You need to restore it then.
Hope my suggestion helps
hi friends,
I m new to asp.net... actually i have an application where the data for current week needs to be displayed from all the data present in different weeks.actually i want to retrieve the syllabus of current week from all weeks
i used the below query but itz not working
sqlString = "SELECT DATEPART(ww,sylWeeKID)AS Week FROM SylWeeks WHERE SyllabusIDFK= " & SylId & " GROUP BY DATEPART(ww,sylWeeKID) "
..can anyone suggest me how to retrieve data for current week , for a related itemthanks in advance
i need urgent help.
select begin_of_week = dateadd(week, datediff(week, 0, getdate()), 0),You can try the following:
SELECT *FROM SylWeeksWHERE sylWeeKID>=dateadd(wk,datediff(wk, 0,getdate()), -1)AND sylWeeKID<dateadd(wk,datediff(wk, 0,getdate())+1, -1)|||
could you try following
select * from tablename where datepart(wk, datefiled) = datepart(wk,getdate())
thanks,
satish.
|||Hi khtan,
Thanks alot for your help,
actually the query that u sent helped me with little modification...actually i wanted to select sylweeksid
condition 1: where syllabusIdfk="& sylId & ",which is a foreign key
condition 2: sylweekid should return only current week criteria...that worked...which uu suggested
but i wanted to have condition 1 also in it...it is not working in any respect ??
i did following:
sqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate=dateadd(week,datediff(week,0,getdate())+1,-1)) "
but its not working
can u help.
thanks
overview:
tablename1: sylweeks----fields--sylweekid(primary key),sylweekcode,syllabusidfk(foreign key) ,sortorder--startdate,enddate
tablename2: syllabus--fields syllabusid(primary key),ImeIdfk(foreign key),course id
|||
Hi limno,
Thanks alot for your help,
actually the query that u sent helped me with little modification...actually i wanted to select sylweeksid
condition 1: where syllabusIdfk="& sylId & ",which is a foreign key
condition 2: sylweekid should return only current week criteria...that worked...which uu suggested
but i wanted to have condition 1 also in it...it is not working in any respect ??
i did following:
sqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate=dateadd(week,datediff(week,0,getdate())+1,-1)) "
but its not working
can u help.
thanks
overview:
tablename1: sylweeks----fields--sylweekid(primary key),sylweekcode,syllabusidfk(foreign key) ,sortorder--startdate,enddate
tablename2: syllabus--fields syllabusid(primary key),ImeIdfk(foreign key),course id
|||
Hi limno,
Thanks alot for your help,
can u check my query in one of the replies, i m not able to duplicate it.
thanks
|||hi satish
thanks for your help,
can u check my query ,i m not able to duplicate it.
thanks
amanat
|||sqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate>=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate<dateadd(week,datediff(week,0,getdate())+1,-1)) "
|||Hi limno,
Thanks alot it worked...
thank u so much
amanat
i dont know how to give points at this time...but will surely
thanks alot
|||Hi Limno,
I wan to add another query
Sqlstring1 = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ")order by sortorder"
which state that if there is no week that matches current date then first week present in database should be executed ..
please guide me where i should fix it
Public
OverloadsSharedFunction getFirstWeekId(ByVal SylIdAs Int32)AsInteger'this function returns the ID of the first week of the sylbi'It is used to seed the sylabus detail page when the page first loadsDim connAs SqlConnectionDim cmdAs SqlCommandDim countAs Int32Dim sqlStringAsString'Dim Sqlstring1 As StringDim drAs SqlDataReaderconn =
New SqlConnectioncmd =
New SqlCommand'the querysqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate>=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate<dateadd(week,datediff(week,0,getdate())+1,-1)) "
conn.ConnectionString = ConfigurationSettings.AppSettings("ConnStr")
cmd.CommandType = CommandType.Text
cmd.CommandText = sqlString
Trycmd.Connection = conn
IfNot conn.State = ConnectionState.OpenThenconn.Open()
EndIfdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
If dr.HasRows =TrueThendr.Read()
ReturnCInt(dr.Item(0))EndIfCatch exAs ExceptionThrow exFinally
dr.Close()
EndTryEndFunction---------------
If (Session("curWEEK"))IsNothingThenweek = -1
EndIf'The following case statement checks the value of weekSelectCase weekCase -1'if week is set to -1 that means the session variable curWEEK has not been set'hence this is possibly the initial rendering of the syllabus.' since this is the initial visit, the syllabus is rendered with' the first week of the syllabus.week = daWeeks.getFirstWeekId(
CInt(Session("SylId")))doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))Case 0'if week is set to 0 then the user has selected to view all weeks'so all weeks are rendered to the syllabus (this is can effect performance
doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))CaseElse'if week is set to any other value, the user has selected to view a specific week'that week ID is the value of week' that specific week is rendered to the syllabusdoc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))EndSelect
|||
Hi Limno,
I wan to add another query
Sqlstring1 = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ")order by sortorder"
which state that if there is no week that matches current date then first week present in database should be executed ..
please guide me where i should fix it
Public
OverloadsSharedFunction getId(ByVal SylIdAs Int32)AsInteger'this function returns the ID of the first week of the sylbiDim connAs SqlConnectionDim cmdAs SqlCommandDim countAs Int32Dim sqlStringAsStringDim drAs SqlDataReaderconn =
New SqlConnectioncmd =
New SqlCommandsqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate>=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate<dateadd(week,datediff(week,0,getdate())+1,-1)) "
conn.ConnectionString = ConfigurationSettings.AppSettings("ConnStr")
cmd.CommandType = CommandType.Text
cmd.CommandText = sqlString
Trycmd.Connection = conn
IfNot conn.State = ConnectionState.OpenThenconn.Open()
EndIfdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
If dr.HasRows =TrueThendr.Read()
ReturnCInt(dr.Item(0))EndIfCatch exAs ExceptionThrow exFinally
dr.Close()
EndTryEndFunction---------------
If (Session("curWEEK"))IsNothingThenweek = -1
EndIf'The following case statement checks the value of weekSelectCase weekCase -1'if week is set to -1 that means the session variable curWEEK has not been setweek = daWeeks.getId(
CInt(Session("SylId")))doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))Case 0
doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))CaseElse'if week is set to any other value, the user has selected to view a specific weekdoc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))EndSelectThanks alot once again for your kind help
|||
Hi Limno,
I wan to add another query
Sqlstring1 = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ")order by sortorder"
which state that if there is no week that matches current date then first week present in database should be executed ..
please guide me where i should fix it
Public
OverloadsSharedFunction getId(ByVal SylIdAs Int32)AsInteger'this function returns the ID of the first week of the sylbiDim connAs SqlConnectionDim cmdAs SqlCommandDim countAs Int32Dim sqlStringAsStringDim drAs SqlDataReaderconn =
New SqlConnectioncmd =
New SqlCommandsqlString = "Select sylWeekId FROM SylWeeks Where (syllabusIDFK=" & SylId & ") AND (startdate>=dateadd(week,datediff(week,0,getdate()),-1))AND (Enddate<dateadd(week,datediff(week,0,getdate())+1,-1)) "
conn.ConnectionString = ConfigurationSettings.AppSettings("ConnStr")
cmd.CommandType = CommandType.Text
cmd.CommandText = sqlString
Trycmd.Connection = conn
IfNot conn.State = ConnectionState.OpenThenconn.Open()
EndIfdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
If dr.HasRows =TrueThendr.Read()
ReturnCInt(dr.Item(0))EndIfCatch exAs ExceptionThrow exFinally
dr.Close()
EndTryEndFunction---------------
If (Session("curWEEK"))IsNothingThenweek = -1
EndIf'The following case statement checks the value of weekSelectCase weekCase -1'if week is set to -1 that means the session variable curWEEK has not been setweek = daWeeks.getId(
CInt(Session("SylId")))doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))Case 0
doc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))CaseElse'if week is set to any other value, the user has selected to view a specific weekdoc.LoadXml(Syllabus.CreateRoot(
CType(Session("sylID"), Int32), week))EndSelectThanks alot once again for your kind help
First let me give you a little back ground on me. I'm very new to the ASP, ASP.NET, Visual Studio, Sql Server, Frameworks...thing. I am coming over from a PHP/MySql background of over 5 years. The change over to VBScript and VB has been to tough and I have a basic liking for the Visual Studio 2005 and the ease of putting things together. However, I have come across something that to me seems like it should be relatively simple, but haven't been able to find the documentation or samples to describe what I'm looking to do.
Rough Need:
1. Start with a form will a couple labels and a singe textbox to get the lookup date from an user.
2. Query one table/view based on the users choice of date and select only one field of returned data.(Doing this by itself is not a problem and I can display my results in a Gridview, but this is where it starts getting tricky and the gridviews won't work for me.)
3. If there is something returned, I need to start a HTML table layout or possibly some form of a Gridview(I don't see how I would use the Gridview) and start a loop, adding the first returned row from this query into the first cell.
4. Now, based on that same User Date and the returned row value from the previous query, I need to query another Table/view and return another single field, which might return 1 or multiple rows, which I need to start a loop to display unique items in cells under the first on above.
5. Based on the original User Date and each returned row from the first query, I need to query two other Table/views and get some additional information. 4-5 fields will be returned and be displayed on one row in the number of necessary columns.
6. This would finish the first row from the first query, so I would need to loop back up to see if there were any further results and continue looping until the get to the last of the results from the first query.
7. Finally, I would just need to close up the Table/gridview.
The basic results I'm looking for would be similar to the following:
Results for 10/11/2005
Info from Query 3
Info from Query 3
Info from Query 3
Info from Query 3
It seems me from what I have read and slowly figuring out, is that I should be able to directly access the DataSet returned by four SqlDataSources, one for each of the above querys and then just write my own VB to handle the necessary looping, table format and such. I can easily add the for SqlDataSources to the page and add a Gridview for each one and get 4 separate chunks of info, but can't see a way with GridViews to intermingle the info like displayed above.
So, if it can be done with Gridviews, then I would love to see how that is done. But, if someone could explain to me how I access the DataSets directly that I get from the 4 SqlDataSources, then that would be ok too. I have figured enough out with VB, that I can write the code to do my looping requirements, if I can just access the information I get back. Thanks for reading all the way through this long post.
Jack
First let me apologize for the mis-spellings and the two links in my sample layout. I did some copy-n-pasting, then changed the wording, but forgot to remove the link behind. I didn't see any way on this forum to be able to Edit my own post to make the necessary corrections.
Second, is this as big of a problem as it seems, since know one made any replies to it? From what little research I've done, it looks like this should be possible with nested Repeaters, but I just can't seem to figure out how to put it all together so that the second SqlDataSource can use each returned value from the results of the first SqlDataSource to get the next set of records and then again with the third and fourth SqlDataSources.
If someone could just give a very short example of a form with a single texbox and submit button, that on postback, you could manually loop through the results returned by a single field onto the page, then I think that would give me some direction here. This is one of those cases that I don't think I want to use a Control to display the returned information, I just need to know how to manually access that returned info. Thanks again.
Jack
I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?
How can I access AS 2005 from an ASP.NET application? Is there any feature to use?
I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?
1) Using kerberos
2) creating a webservice with some Identity to access AS 2005 and using an agent in the application;
3) some other mechanism.
Has AS 2005 come up with some mechanism to allow easy access from web applications (just like sql server authentication in SQL 2005). Is there any feature that we could use? What about anonymous access?
The closest thing we have with AS and sql logins, is http access. Using http access you can set a uid and pwd on the connect string and then the system will use those to authenitcate you against IIS (where the AS server is). This allows your ASP.NET application to use a canned account to access AS. See the connection string parameters allowed on ADOMD.NET (which is what you should be using as a managed provider for your ASP.NET application).
_-_-_ Dave
|||And how do you implement AS role-based security in this scenario?1) getting basic connectivity. If the IIS / ASP.NET machine is in a common domain then you can connect using normal NT authentication (run the virtual directory anonymously and do your own authentication within the application) -- have the anonymouse user for the vd to be a common domain account with the AS server and ensure that it is an Analysis Services sysadmin. If not in a common domain, then use http connectivity and specify an NT UID/PWD which is an AS sysadmin.
2) Once you are connected as an AS sysadmin, then you can use the new EFFECTIVEUSERNAME to set the appropriate username for the connection. Then BINGO there you are.
Hope that helps.
_-_-_ Dave
Hay there,
I have an asp.net project website with an sql Database. I need to access this same database from another project (a class library that needs to access this database). In fact i want to be able to use the tableadapters that I have implemented for my database in this new class library..
I guess it has to do something with making my database not part of the website but and independemt entitiy that can be seen by others.... I cannot seem to find a way to do that can anyone help meee ??
Thanks for your time!
If its a database then how is it tied to application.
Atleast It must have the mdf files which you can create a real independent entity and then play wiith it using connection strings.
|||
All your databases resides in a databse server (e.g. MS SQL Server 2005).
What you need is to point your ConnectionString from your application to that database.
My guess is, you have two projects (e.g. ProjectA and ProjectB) and thay are using diffrent databases but in some part of ProjectB needs to use the same database of ProjectA.
So, you should have two ConnectionStrings for ProjectB. One you will use it for most part of the project and it is specific to ProjectB (keep it in Web.Config file) while you need another ConnectionString that will access the database (which ProjectA is using it) from ProjectB.
Here, have another ConnectionString in the web.config file of ProjectB and lets it point to the same database used by ProjectA.
Good luck.
|||Hi,
Thanks for your very clear reply and clarification.
I can't seem to apply your reply to my situation as My project B is just a class library i.e. I have no webconfig ...
Note that project A and Project B are part of the same solution too.
Thanks for your help.
Hi ekosha,
Why you have the databse within the project itself?!
|||
Well good question, Well I was just implementing this application then and didn't think I would need to use it from another project. seems that was a wrong decision any idea how I can fix that?
ekosha:
Well good question, Well I was just implementing this application then and didn't think I would need to use it from another project. seems that was a wrong decision any idea how I can fix that?
This database has a file with .mdf extension, take that file and attached to a new database in MS SQL Server.
Now, you can use that database for all your projects (even if they are within one solution).
Good luck.
Hi everyone,
First of all I'd like to say I'm new to the forums, and in fact new to ASP.net.
I've had a couple of applications running in VB.net for the last year or so that I now am looking to move on and into ASP.net (main reason is to do with implementation to remote sites in foreign countries).
I'm currently following through the "Working with data and ASP.net 2.0" walkthrough on this site, which I must say has been a great help.
I'll start with the background stuff first
I have my main database on an SQL server. I also have 2 other databases on there - Customer and Employee. The reason for these are that they are shared amongst my VB applications and I kept them as seperate databases so that one database is all that needs to be administered and maintained, and these changes are then seen on both apps (takes away redundant data as well).
In my main database, main table, is a field called CustomerID. This value relates to the CustomerID in the Customer table. In my VB app all I do is have the user select a customer name, and then the customer ID value is copied to the CustomerID field of my main table when inserting / updating a row. This is simply accomplished with 2 SQL connections and 2 dataAdapters. I also use 2 dataSets - one for Customer, one for WorkRequests (the main database)...
I use ComponentOne stuff so that my grid will show the CustomerName instead of the CustomerID etc, and the same applies when I use my Employee database - I run many dataAdapters to this for things such as Account Manager, Technologist, Creator, UpdatedBy etc etc.
Now, I'm new to VS 2005 - my apps were created in VS 2003 and .net 1.1. Can I easily re-create my apps in ASP.net? My primary goal at the moment is to make sure I can load a row, and display the "lookup" values instead of the "integer" value. As my tables are in seperate databases, I would like to know the best way of accomplishing this, if it is of course possible.
Help and advice much appriciated.
Kind Regards,
Luke
SQL supports 4-section object name, in?the?format?of?server.database.owner_name.object_name,?so?just?add?database?part?when?you?want?to?refer?to?object?in?other?database.?For?more?information,?please?refer?to:?Using Identifiers as Object Names|||
Thank you very much, you reminded me about that, I think I looked into it ages ago but then put it to the back of my mind.
To display my CustomerName field by linking to the CustomerID field I'm using;
SELECT npd_dwr.dbo.dwr.dwrnumber, npd_dwr.dbo.dwr.customerid, customerdb.dbo.customer.customername
FROM npd_dwr.dbo.dwr
INNER JOIN customerdb.dbo.customer ON npd_dwr.dbo.dwr.customerid = customerdb.dbo.customer.customerid
Thanks again,
Regards
Terri
In a previous post in Installation and Setup I was having problems just getting an ASP.NET 2.0 app to run on my web server. Now I'm having some different weird security issues.
I'm getting this message when just trying to open a database and put its contents into a gridview.
Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sqlEmployees' because of security settings.
I think this may have to do with our web server and our SQL server being separate machines. That always gives us issues. But I have impersonation=true in my web.config along with windows authentication and I have SQL Server configured with Windows and SQL authentication so things should be right, I'm thinking.
Any ideas??
I guess I stumped everyone. Thanks anyways.|||Did you find the solution? If so please post it, so that it will help others :)
|||Had the same problem. There was a web.config in the root directory, deleted it and solved the problemWhen I moved the app to my server, I detached the database with SMSS express, moved the MDF file over along with the app files and I attached to the database with SSMS to make sure everything went over ok but when I try to open a table I get the error,
SQL Execution Error
Executed statement: Select x, x, x, x,x from tblFile
Error source: .Net SqlClient Data Provider
Error Message: Access to table dbl.tblFile is blocked because the signature is not valid.
I can open the stored procedures fine by choosing modify from the context menu.
Any ideas here?
This post was moved to the sql server express data category however to be clear the problem is not happening within sql server express.
I have windows 2003 server running sql server 2005 I cannot open tables to the database I've attached to sql server 2005 which I originally created on my local machine using visual studio 2005 and the bundled sql express. My problem is happening sql server 2005 not sqlexpress.
Hi,
I have to write an VB.NET application which imports data from an Access database to an Ms SQL server. Is there any code for this kind of task.
Thanks.
Take a look at this post
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=320478&SiteID=1
Connection string to retrieve from Access DB is as follows
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.mdb;"
Hope this helps
