SQL Server 7 Newbie

Dec 21, 2004

I have a bunch of .sql files that will create a data model for me.
I've created a new database in my SQL Server 7 Enterprise Manager called Test.
How do i run this script? In part it looks like:

create table AGP_TYPES (
WL_AGP_TYPE VARCHAR2(4) not null,
WL_AGP_TYPE_DESC VARCHAR2(40),
constraint PK_AGP_TYPES primary key (WL_AGP_TYPE)
)
/


create unique index PK_AGP_TYPES on AGP_TYPES (
WL_AGP_TYPE ASC
)
/


create table ALARM_SYSTEMS (
WL_ALARM_TYPE VARCHAR2(4) not null,
WL_ALARM_TYPE_DESC VARCHAR2(40),
constraint PK_ALARM_SYSTEMS primary key (WL_ALARM_TYPE)
)
/


create unique index PK_ALARM_SYSTEMS on ALARM_SYSTEMS (
WL_ALARM_TYPE ASC
)
/

View 5 Replies


ADVERTISEMENT

Newbie Here With A Newbie Error - Getting Database ... Already Exists.

Feb 24, 2007

Hi there
I sorry if I have placed this query in the wrong place.
I'm getting to grips with ASP.net 2, slowly but surely! 
When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:

Server Error in '/jarebu/site1' Application.


Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.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. Stack Trace:



[SqlException (0x80131904): Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.
Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735075
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
 
 This is the connection string that I am using:
 <connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
 
The database is definitly in the folder that the error message relates to.
What I'm finding confusing is that the connection string seems to be finding "aranga"s database.
Is it something daft?
 
Many thanks.
James 

View 1 Replies View Related

Newbie To Sql Server DTS...

Apr 9, 2005

Hi,
I am new to DTS.  I am also not sure whether this is the solution for my criteria. First my criteria. 
I have an Excel file where i would be capturing the data on a daily/weekly basis.  Now, i want to transfer the data to sqlserver at a regular interval let me say weekly once.  I want the record to append.  At later stages, planned to call from asp through asp.net.
Which is the best solution for to accomplish this task. 
Any good sample would be of great help.
Thanks in Advance to all.
 
Rgs
Ramu
 

View 1 Replies View Related

SQL SERVER 6.5 Newbie Please Help !!!!!!!!!!!!!!!!!!!!!!!!

Jan 3, 2000

Hi ,
My company will have a new application running On an NT Cluster .It has MICrosoft SQL 6.5 as its core element .I have been given Two Months to know Microsoft SQL 6.5 inside out .( commands configurationa and all ) .Please does anyone know any good books on Microsoft SQL 6.5 and knowing SQL thoroughly .
Please help
HAPPY NEW YEAR .
Thanks in anticipation .
Mibsun

View 3 Replies View Related

Newbie SQL Server Question

May 18, 2007

Hello. I'm new to SQL server and I've run into a really basic issue. I'm working on a Visual Studio 2005 project and I have a SQL databse with a .BAK extension I need to use with the project. I've read online that I need to restore the database to a new database to work with SQL Server Express. Here's where I am lost. I can't find good instructions on how to restore the DB to a new one. Any help is really appreciated. Thanks.

View 3 Replies View Related

Newbie In SQL Server 2005

May 20, 2007

Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.


Regards,
Anson

View 3 Replies View Related

SQL Server Newbie Question

Jan 21, 2005

I have SQL Server 2000 installed on XP Pro and I am having problems connecting from an ASP.Net application.

The DB in question was exported from my laptop, which is running MSDE on Windows 2000. On that machine Trusted_Connection=true seems to work from the ASP.Net application whereas the SQL Server login that I set up does not.

Now that the DB has been imported to my XP machine, Trusted_Connection=true no longer seems to work. I am assuming that this may be related to the same problem I had when I was trying to use system logs - the ASPNET user does not have the same privileges on XP as it does on 2000.

In any case, I'm not too concerned at the moment how I connect, just as long as I am able. So, I again tried using the SQL login I had set up with no success.

(I added the SQL Login at the server level then I added it at the DB level and granted it public, db_datareader and db_datawriter access. Later, when that didn't work, I also granted it db_owner rights. Still no success. (BTW, I remembered to repeat these steps on my XP machine once I had imported the DB.))

Then I thought to try using 'sa'. To make sure I that remembered the sa password, I logged into Enterprise Manager (which, I assume uses Windows authentication) and changed it. Then, I went over to Web Data Administrator and tried to log in, using the SQL Login option, with sa and the password that I had just set - IT DIDN'T WORK.

Am I going mad, or is there something I'm missing?

Thanks
Martin

View 1 Replies View Related

SQL Server Newbie (Triggers)

Jul 31, 2000

Good afternoon one and all,

I am migrating a access dbase to SQL. I have two tables, the first is a buffer table that collects data from various sources, the second table is an indexed version of the first table (to eliminate duplicate records etc. etc.)

I am currently using the DTS packaage to transfer data between them, would a trigger be a better solution?

Thanks in advance for any and all help

Gurmi

View 2 Replies View Related

SQL Server Newbie (Triggers)

Jul 31, 2000

Good afternoon one and all,

I am migrating a access dbase to SQL. I have two tables, the first is a buffer table that collects data from various sources, the second table is an indexed version of the first table (to eliminate duplicate records etc. etc.)

I am currently using the DTS packaage to transfer data between them, would a trigger be a better solution?

Thanks in advance for any and all help

Gurmi

View 1 Replies View Related

Newbie Set Up And Testing Server

Mar 31, 2003

My previous experience is with php and MySQL.

I currently have Apache, MySQL and php running on my local machine to enable me to test php code on localhost

I've been asked by a colleague if I'll work on an SQL 2000 database they're having trouble with. They said they will provide Visual.net, SQL 2000 and any other software I need.

I'm completely in the dark on this, but have some starting questions:

To test my code, will I need to set up a sever on localhost?

Will I need other software than Visual.net and SQL 2000? I'm using DW MX for my web stuff.

Whre can I find a basic introduction to ASP / SQL 2000 in the form of a tutorial?

How fast does this combination run? The database has 25,000 rows and 6 columns. What would be a reasonal expect time for a result?

Any help appreciated

H

View 3 Replies View Related

Difference Between The MS SQL And The SQL Server? (was Newbie To MS SQL)

Nov 30, 2005

Hi,
I am totally a newbie to MS SQL. I have a question regarding the MS SQL: What is the difference between the MS SQL and the SQL Server? Is it the same? and what should be install for MS SQL on the server and the client side???

View 14 Replies View Related

SQL Server 2005 Newbie

Aug 7, 2006

I am relatively new to SQL Server and I have 2005. I am developing a database with an Access ADP frontend. The development is taking place on my laptop running a separate instance of SQL Server. I am trying to put the database on the production server and I am not sure how to proceed.

My laptop is not part of the network so I need to create a file and then import it on the SQL Server instance running on the production server. I thought I could do a backup and restore, but apparently that is not working.

Any help would be greatly appreciated.

View 4 Replies View Related

MS SQL Server - Newbie And Have Some Problems

Apr 21, 2004

hi to all,

i'm new at MS SQL Server,
i developed an application with MS SQL Server Developer Edtn. and i want to try it with a real server and clients

i tried to install it to WinXP Pro and it asks a domain and a user account, is theere a way to create a domain with winxp pro, or working with only server windows (2003 server, 2000 server etc.). If it is working with only server, is there a tutorial at internet to create a domain and users at windows (i lost lots of time to setup Ms SQL Server)
pls i need a tutorial, or a way to install MS SQL Server...

i want to install ms sql server to vmware machine,
i wonder how to make configurations to access my server on real machine and other machines that is on the network of real machine
(i think i must user pat, but how to make configurations is a big problem, but the biggest is installing sql server)

it is urgent pls help, i dont want to lose more time because i lost enough...

MeCeX

View 1 Replies View Related

Total Newbie To SQL Server

Sep 30, 2005

I'm in a slightly sticky situation. I recently got a job I interviewed for as a business analyst/programmer. I know quite a bit of VB 6.0 and SQL language, also enough access to build a decent database as a backend for my apps. I've recently received a 4 yr CIS degree, so I know a little about everything. I told them very clearly three times in the interview that I'd never built a SQL Server DB, but they must not have cared about that. They need someone who can program, do some DB work, and also do some business analysis. I was the best fit they could find.

After working with the group a few days, I figured out they need a data warehouse and marts to do some historical analysis, and eventually data mining and trend analysis, etc. I think they said they'd like to have that by the end of next year.

What I need now is one or two really great books to get started with, and a small synopsis on what I'm going to need as far as dev software and server specifics to get this thing off the ground. The first thing they would like to see is simply enough tables to dump data into from 4 or 5 different DBs, from which they can pull data for analysis whenever they need to do so. The total rows for this DB will be around 170mil, but with just a few measures in each row. Microsoft spreadsheet says I should expect about 5gig per year of data.

So I'm freaking out because I know ziltch about SQL Server, what tools and server set up I'm going to need, and the more I read, the less it sounds like "Oh it's not that big of a deal. It's easy", as a few friends told me.

Help!

View 5 Replies View Related

Newbie: Sql Mobile Or It Is Sql Server Everywhere

Sep 18, 2006

I'm confused by the MS literature. I think that "SQL Server Everywhere" is the new name for what was "SQL Mobile". Am I correct?



TIA,

barkingdog

View 1 Replies View Related

SQL Server Newbie Question On Permission

Jan 9, 2007

Hi, I always had the impression to use asp.net membership, in sql server, I needed dbo permission because all its tables and what not always had [dbo] in front of them and "dbo." is all hard coded into their build-in membership classes.  In my shared hosting enviornment, I always had to ask my db admin to give me dbo permission explicitly. I saw this article today http://www.aquesthosting.com/HowTo/Sql2005/Providers.aspx and after I followed their direction, by using ec sp_addrolemember 'aspnet_Membership_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Personalization_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Profile_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Roles_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_WebEvent_FullAccess', 'yourUser'
got

View 1 Replies View Related

Newbie Question About SQL Server 2005

May 12, 2007

Hi, I have a very newbie question.I have been only developing websites locally on my computer (during my learning curve) and never actually put anything up in a server on internet, but I just bought a server from discountasp.net and an extra SQL 2005 Database.Now I need to put my database on that server (copy the local one) I know I have a connection string and username and password. But I really do not have any ideas how to do this.I would appreciate if you tell me where to start and what I should do at this stage.Thank you and have a good day. 

View 4 Replies View Related

Newbie - SQL Server Express And Other Stuff

Feb 16, 2008

Hi

View 1 Replies View Related

Newbie - Connecting Excel To MS SQL Server 7

Apr 9, 2001

Hi!

Does anybody could show me how to connect my Excel 97 to MS SQL Server 7 using ODBC? What are the MS Office Components needed for the connection and the necesary MS SQL server component, server and client, needed?

Thanks a lot.

View 1 Replies View Related

MS SQL Server 2005 Newbie Tutorials Available?

Aug 29, 2006

I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?

View 3 Replies View Related

HELP: Newbie Install. Can&#39;t Register Server.

Dec 19, 1998

I have installed SQL6.5 on my NT4.0 server.
I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:

"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"

The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL.
I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb

View 1 Replies View Related

Newbie Question About Importing Db Into SQL Server

Jun 10, 2004

Relatively new to SQL, will be using it as the engine for a dynamic website...I have a database in Access that is the foundation for this site -- it's pretty simple, just a few tables with relationships established & a couple of queries.

Is there a tool that can migrate this Access db into SQL, or should I just reconstruct it? Been looking around for some tech notes and have been unsuccessful so far. Thanks in advance! -Valerie

View 2 Replies View Related

Newbie Help: SQL Server Does Not Exist Error

Nov 23, 2004

I've seen this question asked when I searched, but I didn't see an answer that looked like it applied to me, so I'll ask again.....

Making the transition from VB 6 to VB.NET and decided to take a stab at database programming while I'm at it. I bought "Database Programming with Visual Basic.NET and ADO.NET" by Sams Publishing and ran into problems in the first chapter. I've posted some questions on the microsoft.public.vb.database newsgroup and got some help, but it's still not working.

I'll skip some of the boring stuff and dive right in with what I've found out so far:

From MSSQL$VSDOTNETLOGERRORLOG

2004-11-19 02:29:34.71 spid3 SQL global counter collection task is created.
2004-11-19 02:29:34.76 spid3 Warning: override, autoexec procedures skipped.
2004-11-19 02:29:58.87 spid51 Error: 15457, Severity: 0, State: 1
2004-11-19 02:29:58.87 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-11-19 02:29:59.01 spid51 Error: 15457, Severity: 0, State: 1
2004-11-19 02:29:59.01 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-11-19 02:29:59.46 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

The last suggestion was to uninstall and reinstall. I uninstalled VS and SQL and reinstalled getting the same error message in the log, but the message box said that installation was complete.

On the Server Explorer of the IDE, it shows my computers name (programmer) under Servers. When I expand that and expand SQL Servers, I see PROGRAMMERVSDOTNET. When I try to expand that, I get the SQL Server Login window with Server textbox disabled saying PROGRAMMERVSDOTNET and the Database blank. Under the Login it has James (my sign in name) and asks for a password. When I did the MS-DOS CLI installation, I used "password" as the SAPWD. I tried using password, and tried using the password to log on as James, and get the same error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Any help would be appreciated, as long as you remember that I am a COMPLETE newbie at this. I'm fairly computer literate, but I don't know the first thing about databases.....

Thanks again,

James

View 3 Replies View Related

How To Add Data To My Tables (was SQL Server Newbie)

Feb 1, 2005

Hi. I just set up my first sql server database and I've managed to connect to it via ASP as a test.
I'm not sure how to add data to my tables. In MS Access, you can edit the table and add records. How do I do that in SQL Server?
I'm using the Enterprise manager tool to create tables.... does it have something i can use?

Thanks

View 6 Replies View Related

Install Help For SQL Server 2005 Newbie

Feb 28, 2006

I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.

While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.

I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.

Thanks for your help.

Steve

View 1 Replies View Related

NEWBIE Needs Help Automating Data From Another Server

Sep 7, 2007

Hi,

I am able to do these actions interactively from SQL 2005 (not developers nor enterprise edition, just using SQL 2005 Mgmt Studio) and want to "script/batch" them so I can have them automatically run at a pre selected time.

First: I am able to delete the table by performing a right click on the table, then click Delete from Mgmt Studio SQL 2005. I verify the table is completely gone with a refresh. (I pulled the code that did this ..... DROP TABLE etc. to Notepad)

2nd: I am able to import the table (again from Mgmt Studio SQL 2005) and have saved this action as a SSIS. Execute the script and "waLa" I have all 17K rows of data. I pulled this create table code into notepad also.

Now I put the code of both of the above actions together (drop table and create table) into one SQL query and execute it. This does not give me the same results of above, instead my table is blank now.

Maybe there is a better way. The business problem I am attempting to solve: I am refreshing the data in a as/400 table weekly. I want that refreshed data to be available in the SQL2005 database without my having to press buttons first thing Monday morning. Can any one help? Thanks in advance.


Below is the Code:


USE [400kas]
GO
/****** Object: Table [dbo].[navar100] Script Date: 09/07/2007 16:09:04 ******/
DROP TABLE [dbo].[navar100]
GO


USE [400kas]
GO
/****** Object: Table [dbo].[Query] Script Date: 09/07/2007 16:12:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[navar100](
[CMPNO] [decimal](3, 0) NOT NULL,
[ARTDT] [datetime] NOT NULL,
[AUDDT] [datetime] NOT NULL,
[ARDDT] [datetime] NOT NULL,
[CCUS#] [decimal](6, 0) NOT NULL,
[CCNAM] [nvarchar](25) NOT NULL,
[CUSNO] [decimal](6, 0) NOT NULL,
[CNAME] [nvarchar](25) NOT NULL,
[SHPNO] [decimal](4, 0) NOT NULL,
[ARRCD] [nvarchar](1) NOT NULL,
[AUDUS] [nvarchar](10) NOT NULL,
[INVNO] [decimal](6, 0) NOT NULL,
[CUSPO] [nvarchar](15) NOT NULL,
[REFNO] [decimal](6, 0) NOT NULL,
[COMNT] [nvarchar](10) NOT NULL,
[SHPPO] [nvarchar](15) NOT NULL,
[AMONT] [decimal](13, 2) NOT NULL,
[AMOUNT] [decimal](24, 8) NOT NULL,
[REMAN] [decimal](13, 2) NOT NULL,
[INREG] [decimal](3, 0) NOT NULL,
[INSAL] [decimal](3, 0) NOT NULL,
[TMCOD] [nvarchar](2) NOT NULL,
[CRHLD] [nvarchar](1) NOT NULL,
[CRLIM] [decimal](13, 0) NOT NULL,
[CRDAY] [decimal](3, 0) NOT NULL,
[TCRCD] [nvarchar](3) NOT NULL,
[TEXRT] [decimal](11, 6) NOT NULL,
[R1RGL] [decimal](13, 2) NOT NULL,
[TAXAM] [decimal](13, 2) NOT NULL,
[TFRTX] [decimal](13, 3) NOT NULL,
[TFRGT] [decimal](13, 2) NOT NULL,
[TSPCH] [decimal](13, 2) NOT NULL,
[SPCST] [decimal](13, 2) NOT NULL,
[IRPFT] [decimal](13, 2) NOT NULL
) ON [PRIMARY]

View 2 Replies View Related

Newbie To SQL. Error Connecting To Server

Sep 27, 2007

hy.
i am a newbie to SQL

i downloaded and installed SQL SERVER 2005 EXPRESS.
i tried to convert an "ACCESS" database to sql and got the next error:

: "AN ERROR OCCURED
WHILE ESTABLIDHING A CONNECTION TO THE SERVER. WHEN CONNECTING TO SQL 2005,
THIS FALIURE MAY BE COUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL
SERVER DOES NOT ALLOW REMOTE CONNECTIONS. PROVIDOR NAMED PIPES ERROR 40 -
COULD NOT OPEN A CONNECTION TO SQL SERVER".

any help apreaciated.

View 1 Replies View Related

Newbie Confusion: File Vs Server

May 29, 2007

caution: this is not doubt a stupid newbie question...



In creating vs.net 2005 website, I can add a sql database to my project and a mdf file is created. I can create data providers against this file, etc, just as though it were a database in a sql server instance. I can deploy this dbf file to my finished web site.



Also, I can attach to a running instance of sql server 2005 express, and do exactly the same thing.



I can also take my mdf file created in step 1 above, and attach it to a running instance of sql server express.



Now, I have delt with access databases, and sql server 2000 databases, so this dual nature of sql server 2005 express confuses me a little.



Why would I ever need to use a server instance of sql server 2005 when I can use a file based data file in my web apps? Is there an advantage to one or the other?



I had a thought that when using the file based method, I was actually still using the server based stuff, which would explain why the sql server express notification bubble pops up when I debug on the dev machine.



In any case could someone explain the difference and should I install sql server 2005 express on my deployment server?



thanks.



View 7 Replies View Related

Very-NewBie Linked Server Problem

Jan 16, 2008

I'm having a problem selecting from an Excel linked server...

1. Create a new simple Excel file at C:DeleteMe.xls and add a couple column headers and a row of data. e.g.

--------------
ColA | ColB |
--------------
123 | 456 |
-------------

2. Execute the following command in SQL Server 2005 Management Studio...

EXEC sp_addlinkedserver
@server = 'ExcelSource',
@srvproduct = 'Excel',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@datasrc = 'Database=C:DeleteMe.xls',
@provstr = 'Excel 5.0'

select * from ExcelSource...[Sheet1$]

If you're like me, you'll get the following error:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource".


Does anyone have a solution?

THANKS in advance.

View 10 Replies View Related

Sql Server Express 2005 Newbie: Bcp Utility

Mar 8, 2008

I'm trying to learn how to use the bcp utility... but I keep getting an error message that says:
SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
 The command i'm running is:
bcp territore.dbo.import in territorydata.csv -T -c
territore is my database name... and dbo i think is the owner name.
and the table is called Import
I don't know how to check the default settings to see if remote connections are enabled.  Any help would be appreciated.

View 6 Replies View Related

How Does SQL Server Calculate GETDATE? (was Newbie Question)

Mar 8, 2006

My apologies if my question seems rather naive, but I'm looking for some info on how SQL Server (2K) calculates the GETDATE info. Is it from an internal algorithm of some type, or does it simply pull the info from the local server info?

Thanks to all.

View 3 Replies View Related

Newbie Question: Entering Data Into SQL Server?

Feb 28, 2008

Can someone help me to understand something about SQL Server? I will use Access for comparison.

Suppose you have a SQL Server database and you want users to be able to enter data into the fields just like you could with an Access database and forms. How would you set that up with SQL Server? I have noticed that you can convert an Access database into SQL Server, but you still need to use Access forms to enter data into the tables stored in SQL Server.

What if you wanted to create an SQL Server database from the ground up and set it up for user entry?

What am I missing here?

View 3 Replies View Related

Sql Server 2000 To SLQ Broker - Newbie Question

Jun 29, 2006

Hi!

I have a legacy database in SQL 2000 which I want to submit transactions thru triggers to SQL Broker, until I eventually upgrade this db to 2005. Can you tell me if this is possible?

Thanks

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved