ON/OFF-LINE WEB DATABASE

Hi,

I have just started learning Visual Web Developer (Express) and SQL Server (Express) but have not been able to figure how to solve this problem: my organization uses a local network for the staff and intends to collect data through the internet, but we lose our connection to the internet for several hours in a day. What considerations should we bear in mind as we design the web application and database? For example, is it wise to reside the database in the web application? How do we synchronize the database whenever we come on-line?

You can configure your SQL Server 2005 Express for replication. Check out this MSDN documentation for reference

OLEDB for DM Express!!!

I am pursuing a course on Data Warehousing & Data Mining as part of my Post-Graduation degree. I got an introduction to Microsoft's OLEDB for DM as part of the course, which got me interested for experiencing it hands-on.

I developed a traditional Database application for my college's library using the .NET 2.0 framework, which is running fine.

Now, I want to see the power of Data Mining in general & OLEDB for DM in particular, to help me mine information & patterns from the mostly transactional data generated by the library daily, like the rush hours, the average issue duration for a book, books that are issued more frequently, books that are issued to students from multiple streams etc. etc.

Now, I have heard MSOLAP provider, ADOMD data provider, SQL Server Analytical Services, OLEDB for DM libraries etc. are required for Data Mining.
Now, what exactly is each of these tools? Are they independent servers for DW & DM like SQL Server for DBs, or they are libraries for extending SQL Server itself?
Moreover, are separate libraries required for OLAP & Mining?

I have SQL Server Express Edition. I believe that they are extensions for SQL Server. So, will they work with Express Edition? If not, are their Express Editions available (like OLEDB for DM Express!!!!) that are compatible with SQL Server Express.

Thanx in advance if you take time to answer so many questions...

Hi Rahul,

SQL Analysis Services is the core piece of all the technologies you're discussing (Data Mining, OLAP, ADOMD, etc.) and it is not included in SQL Express. There is no Express version of the Analysis Services line of products, but you can get the Trial version of SQL Server which includes all features, but is limited for Evaluation purposes and expires after 180 days. You can obtain the trial from http://www.microsoft.com/sql/downloads/trial-software.mspx.

MIke

|||But do I have to download & install libraries for each of them separately, or SQL Analysis Services encapsulates all of them?
|||

hi,

the Trial edition includes "all features"... you cn select what to install while running the installation wizard..

regards

OLE DB Provider for ODBC and Oracle

Hi,

I created a linked server for MS SQL Server 2005 Express to an Oracle
database using the OLE DB Provider for ODBC. My ODBC Source uses the
Microsoft ODBC for Oracle driver.
I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
providers because those don't handle Oracle's Numeric Data Type well.
When I set this up yesterday it worked fine. However I log in today and
attempt to run sp_tables_exec against my linked server and get the
following

OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC driver for Oracle][Oracle]".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "MSDASQL"
for linked server "WHATEVER".

I can tnsping the server, and I have no trouble connecting with the
Oracle OLE DB provider

I try to set up ODBC logging but the log file is blank -- same with
attempting to set up logging for Oracle's network client. I've been
dealing with crap like this the last 4 days, something works one day,
then the next nothing (I've done nothing to change the configuration
between these outages).

Can anyone help me?

Thanks
FrustratedReplied to duplicate post of 22/12 !

"Crazy Cat" <danbredy@.hotmail.com> wrote in message
news:1135178623.892320.137120@.o13g2000cwo.googlegr oups.com...
> Hi,
> I created a linked server for MS SQL Server 2005 Express to an Oracle
> database using the OLE DB Provider for ODBC. My ODBC Source uses the
> Microsoft ODBC for Oracle driver.
> I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
> providers because those don't handle Oracle's Numeric Data Type well.
> When I set this up yesterday it worked fine. However I log in today and
> attempt to run sp_tables_exec against my linked server and get the
> following
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC driver for Oracle][Oracle]".
> Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
> Cannot initialize the data source object of OLE DB provider "MSDASQL"
> for linked server "WHATEVER".
> I can tnsping the server, and I have no trouble connecting with the
> Oracle OLE DB provider
> I try to set up ODBC logging but the log file is blank -- same with
> attempting to set up logging for Oracle's network client. I've been
> dealing with crap like this the last 4 days, something works one day,
> then the next nothing (I've done nothing to change the configuration
> between these outages).
> Can anyone help me?
> Thanks
> Frustrated

Old problem, but... Cannot open user default database. Login failed. Login failed for user '

I didn't use SQL Express before, now I am trying to use it. I thinkk it is convinient if you just want to copy db files to user's machine. like this

<add name="schsecurity" connectionString="Data Source=.\SQLExpress;Integrated Security=true;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />

as long as user has sql express installed, he should be able to use the db once he copy the file aspnetdb.mdf over.

but when I tried it, I got

Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

it looks simple, SQL express can not verify user 'NT AUTHORITY\NETWORK SERVICE'

so I connect SQL express with SQL server management studio, and add the user into login of the SQL express and set the user as sysadmin. But I still get the error.

Any idea?

thanks!

I doubt it has anything to do with copying files to your machine. The default database does not have proper permissions for access. I receive the same message when attempting to log in using username and password. I know the username and password are correct. I'm not sure of how to give the default db permission for access.|||

You should not post like that, it is not helpful.

Can anyone help?

thanks