|
Hi,
I am BE final year student. I am doing project using data warehouse. It is review analysis of automobiles. Can anybody give me feedback of this, how is the project at final year level?
Also if i get some links regarding review analysis i will e grateful.
Thank you.
|
|
|
|
|
I have an x64 Server Running SQL Server 08 and within that server I am setting up a linked server to an XP box running SQL express 05. I am setting up the linked server with a server name of "ComputerName\SQLEXPRESS", using the Microsoft OLE DB Provider for SQL Server. It connects fine and passes a connection test, but when i write a simple select query to get all records from the linked server table it returns no records when there are multiple records in the table I have queried. Any one ever seen this before? It should be noted that when I try to add the linked server and keep the radio button selected for sql server it will not connect giving me an error message
VIA Provider: The specified module could not be found.
OLE DB provider: SQLNCLI10 for linked server returned message login timeout expired.
OLE DB Provider for linked server returned message a network related or instance specific error has occured while establishing.....
I am at a loss?
|
|
|
|
|
Member 8003276 wrote: a network related or instance specific error has occured
That's a general message, and there can be many reasons why it can't connect. Try using an IP-address to identify the computer.
Is Sql configured to use TCP/IP or use named pipes?
Did you install all the service-packs?
Bastard Programmer from Hell
|
|
|
|
|
HI
error under
error 1045 - access denied for user 'root' '@localhost'(using password : no)
php my admin tried to connect to the MYSQL server and the server rejected the connection .you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server.
|
|
|
|
|
|
a2bj wrote: you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server
Such a good error message! It perfectly tells you what to do.
I cannot believe that some internet provider would allow you to connect to a MySQL database on the server as root, and without a password...
|
|
|
|
|
You can rest easy. It's on localhost , not an ISP. OP just can't remember what he told mysql so he can enter it into phpmyadmin.
:groan:
Peter
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Edit config.inc.php this can be found in phpMyAdmin/libraries
change :
$cfg['PmaAbsoluteUri'] = '';
to
$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';
change
$cfg['Servers'][$i]['host'] = 'localhost';
to
$cfg['Servers'][$i]['host'] = 'Localhost';
and enter you're password in :
$cfg['Servers'][$i]['password'] = '';
eg
$cfg['Servers'][$i]['password'] = 'password';
reboot MySQL
|
|
|
|
|
Hi,
I am using the following code in sql server to get list of mobile numbers and add the country code to it.
select ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' order by file_no
I want to do the same but with selecting unque records only.. something like this (but throwing error!)
select DISTINCT ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' order by file_no
|
|
|
|
|
How about a subselect if your database system allows it?
SELECT ('973' + contact_moblle) AS mobile_number FROM (SELECT DISTINCT contact_moblle FROM persons WHERE ... ) T
Also...
"where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8"
can be reduced to:
"where len(contact_moblle) = 8"
|
|
|
|
|
jrahma wrote: something like this (but throwing error!)
You didn't post an error. I doubt that it'll update the correct field if the dataset is created using distinct values.
Bastard Programmer from Hell
|
|
|
|
|
select ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' GROUP BY contact_moblle order by file_no
Hope this will help. Check this and let me know the outcome
-Shenbaga Murugan Paramasivapandian
I hate computers and I just mess them up with my code!
|
|
|
|
|
Try this
;With CTE AS
(
Select
Rn = Row_Number() Over(Partition By ('973' + contact_moblle) Order By file_no)
,('973' + contact_moblle) AS mobile_number
from persons
where contact_moblle is not null
and contact_moblle != ''
and len(contact_moblle) = 8
and left(contact_moblle, 1) = '3'
)
Select mobile_number
From CTE
Where Rn = 1
Hope this helps
Niladri Biswas
|
|
|
|
|
Hi
Can anyone show me how to convert strings that start with Mc[x] to Mc[X]? (e.g. convert Mcgovern to McGovern, Mcdonald to McDonald) in Oracle (or just SQL code)?
I tried using the regexp_replace function in Oracle, but can't quite figure out how to upper case the third character.
Thanks
|
|
|
|
|
Though not elegant, I was able to do the following:
select regexp_replace(d_name,'Mc[a-z]', 'Mc' || upper(substr(d_name, 3, 1))) n from
(
select 'Mcfix' d_name from dual
);
Thanks
|
|
|
|
|
I would like to hear some opinions from experienced developers who have worked with Access and SQL Server Express.
I am thinking of building a desktop based room reservation system as a personal project. However, I am not sure what would be the best approach.
I am thinking of the following options:
1) Using MS Access for both the front-end and back-end.
2) Using C# for front-end and MS Access as back-end.
3) Using C# for front-end and MS SQL Server Express as back-end.
It would be a packaged software, so I'm wondering if MS Access would be stable enough.
I haven't worked with MS Access long enough, so I would like to find out from other experienced developers whether MS Access backend would be sufficient, and what are some of the recommended steps to take to prevent database corruption - maybe backup, compact and repair every time program closes; what else?
Thank you.
|
|
|
|
|
If you hope to sell it, don't use Access.
|
|
|
|
|
Thanks for the response. I did a bit more research, and found out about MS SQL CE, and also SQLite. For now, I will test out SQLite since deployment seems to be easy.
|
|
|
|
|
As always, it depends. Are you intending to put a lot of logic into the database (stored procedures)? Or are you intending to put as little logic into the database as possible, and just use it as a relatively dumb data store? I'm not suggesting either option is better than the other, but that decision might influence your choice of database. Or you could look at it the other way round - support for stored procs is better in some databases than in others so if you make the decision about the database first it may place limitations on how you design the application.
You could also use this as an opportunity to think about how you might build a system which is database agnostic, or at least ask yourself the question, how easy would it be to upgrade from MS Access to SQL Server six months from now if I find Access can't cut it?
It's not clear when you say this is a "personal" project whether that means it is just a learning exercise or whether you are considering possible commercial applications at some point (which is what I read into your statement about it being a "packaged" solution).
|
|
|
|
|
I am taking this chance to improve my development skill. At some point, I would like to sell it as a product. This is more of a side project, to be done after work or during the weekends.
I am looking at light-weight database. The application would be a standalone, single-user. For support of multi-user, I intend to use configuration to specify the database connection. So, the database should be able to support multi-user environment, within a LAN -> which I am looking at a client/server architecture.
This will be a data-entry, reporting application, so MS Access would be ideal. However, I do not have experience using the developer edition and compiled an executable with the Access run-time included in the package, which user can run without impacting the existing Access operation on their PC.
Hence, looking at a C# front-end and a suitable light weight database as data store. Stored procedure would be nice to have.
|
|
|
|
|
Stan Moong wrote: reporting application
This can cause severe problems with MS Access. When you calculate sums, averages etc. on joins of sub queries, the performance will be unacceptably slow even with few data. In such cases, go for MS SQL Server (Express edition is OK too).
|
|
|
|
|
If you are thinking of SQLite,which is an embedded DBS,you may also want to check out VistaDB[^] from Gibraltar software.
I have been using for several years and have found it both reliable and very fast, with a small footprint. It has a reasonable management interface, can import from Access and SQLServer, and can export to XML.
|
|
|
|
|
Thank you very much for the information. I will check it out!
|
|
|
|
|
If the database will grow very big use something besides MS Access. Access is good for small stuff but personal preferance would be something else. Note I have used both Access and SQL Server as backends. I have used Access as the front end for a SQL Server backend. Stick with a different backend then Access if possible. Using C# as your front end will prevent a few security problems.
Good luck and happy learning.
|
|
|
|
|
Thank you.
Yup, I am looking at the C# as front-end, and a light-weight database for data store.
|
|
|
|