Unable To Telnet
Jul 17, 2007Hello,
I was trying to telnet a remote server but I get following error message.
Connecting To "Remote machine address" Could not open a connection to host: Connect faile
Can anyone tell me what to do?
ADVERTISEMENT
Telnet Disconnect
Nov 5, 2007Running server 2003. I am running a program from home and am telneting in. When I leave for over 1/2 hour without inputting anything it disconnects me. How can I reset this setting to several hours befor it will disconnect me?
View 1 Replies View RelatedCan't Telnet X.x.x.x 1433 On Localhost
Oct 4, 2006Hi,
I used Microsoft SQL server 2000 on Microsoft Windows Server 2003 for database server and used Redhat Linux Enterprise for Web server.
I wrote the PHP script (on Redhat) connect to database server, its does not work. And then I install freetds on Web server but not work too.
I have problem not be solve...
- on Redhat, cannot telnet x.x.x.x 1433 to database server. But telnet to other port is success.
- on database server, cannot telnet x.x.x.x 1433 and telnet 127.0.0.1 1433.
- between web server and database server can used ping !
- I used command 'netstat -an' on database server is not show for 1433 port.
please help me... :eek:
Test SQL Connection With Telnet
Aug 23, 2007I have just been able to configure remote connection on SQL 2005. I can also access the AdventureWorks database remotely via ODBC on port 1433. The install directions of a some software instruct me to do telnet <hostname> 1433 to check for connectivity. It doesn't work! I gave my instance the name RM and I also tried telnet <hostname>RM 1433 but again failed.
When I try just telnet <hostname> it works.
Can anyone help?
Sql Server Connection Via Telnet
Oct 28, 2006
hello
How can we Connect the SQL server Via TELnet.
Client system at LAN "A"........
Sql Server Instance at LAN "B".....
So, how can i connect these two , along with how to send the Querries to sql Server at Lan "B" inorder to retrive from the server to Client......
Can Anybody help in this regard and give a small details / give a path to find out this..
Thanx in Advance..........
Canot Telnet Into Port 1433 Affter Intalling SQL Server !
Sep 21, 2006I'm working on a completely virgin install of SQL Server 2k in Windows 2003.
Just after install I check that the TCP/IP protocol is enabled under the
server properties and then I try to Telnet into port 1433. On this one
particular box I get back the following:
C:>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port
1433: Connect failed.
For comparison I tested telnet on a couple other machines and I get back a
blank window ready for my commands, as I'd expect.
I've checked the firewall settings and other IP Filtering settings to see if
any of those were blocking traffic to 1433... nothing. I've triple checked
the SQL Server settings for any "problems" and nothing jumps out at me.
Blocking Telnet Command For SQL Server Detection 1433/1434
Aug 7, 2006Any ideas how I can I block telnet connections to SQL Server ports ?
Telnet Connection Works, Sql Cmd Connection Works, SQL Server Managment Studio 2005 Does Not
Jun 20, 2007I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are being listed to. I can establish a connection both by running
telnet sql5.hostinguk.net 1433 and
sqlcmd -S sql5.hostinguk.net -U username -P password
See below:
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP 81.105.102.47:1134 217.194.210.169:1433 ESTABLISHED
TCP 81.105.102.47:1135 217.194.210.169:1433 ESTABLISHED
TCP 127.0.0.1:1031 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51114 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51201 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51202 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51203 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51204 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51206 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1030 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 81.105.102.47:123 *:*
UDP 81.105.102.47:1900 *:*
UDP 81.105.102.47:5353 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1086 *:*
UDP 127.0.0.1:1900 *:*
Both these utilities show as establishing a connection in netstat so I am able to connect the database server every time, this worked throughout yesterday and has continued this morning.
The problem is when I attempt to use SQL Server Management Studio. When I attempt to connect to tcp:sql5.hostinguk.net, 1433 nothing shows in netstat at all. There is an option to encrypt the connection in the connection properties tab in management studio, when I enable this I do get an entry in netstat -an, see below:
TCP 81.105.102.47:1138 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1139 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1140 217.194.210.169:1433 TIME_WAIT
Amost as if it's trying the different ports but you get this time_wait thing. The error message is more meaningful and hopefull because I get:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)
I would expect this as the DNS has not been advised to encrypt the conection.
This is much better than the : Login failed for user 'COX10289'. (.Net SqlClient Data Provider) that I get, irrespective of whether I enter a password or not.
This is on a XP machine trying to connect to the remote webhosting company via the internet.
I can ping the server
I have enabled shared memory and tcp/ip in protocols, named pipes and via are disabled
I do not have any aliases set up
No I do not force encryption
I wonder if you have any further suggestions to this problem?
Unable To Connect To DB
Nov 27, 2006Hello everybody
I wrote a vb.net win app that uses a mssql 2005 express DB.
On my localcomputer everything worked without a problem.
Now I wish to deploy my app on a remote computer (that has mssql 2005 express installed), so. I added an app setup project to my project using the vs2005 setup tool, installed the app on the remote computer, and copied the mdf file to the remote computer.
I'm able to see the DB through the remote computer mssql manager, But when I try to start the app on the remote computer I get this error massage :
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. error: 0 - No process is on the other end of the pipe.)
my connectionstring (in the config file) looks like that :
<connectionStrings> <add name="Info_Manager.My.MySettings.MaxinetConnectionString" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="Info_Manager.My.MySettings.MaxinetConnectionString1" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings>
by the way changing the user instance attribute to "false" didn't help.
Does anybody know how to fix this problem.
Unable To Use SQL Profiler
Aug 8, 2000I am using SQL7. On the client network utility, I am using name pipe and have 4 entries and they are in the same format (ie. server name, named pipes and ip address). I have problem to connect to some of them and getting
[microsoft][ODBC SQL Server Driver]Client unable to establish connection
and [microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(CreateFile())
Any idea?
Unable To Register
Jan 30, 2001Hi,
I am trying to register one server and I get the following message -
"Client unable to establish connection Connection OpenCreatefile()"
Any advice highly appreciated.
Thanks
PD
Unable To Connect
Aug 14, 1998Howdy
Every time i reboot my NT Server and the SQL server service starts up. It logs this message to the event Viewer
Severity: 9 Error:10004, OS: 11001 Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.ConnectionOpen (gethostbyname()()).
I don`t have any problem with the databases, all the users are able to connect to server and database without any problems, looks like everything is working at its best. But i am little concerned about this error message.
Please help
Thanks
vIVEk
Unable To Restore To Other DB ?
Jul 22, 2004Hi,
I have every nights a backup script that is running using the following command on my sql server 2000 :
backup database MYDB to disk="d:mssql2000MSSQLBACKUPdb_MYSERVER_MYDB.bak" with init
Now, i need to restore one of these files to a new Database with another name...in order to look at certain table and its content
I'm unable to find the correct RESTORE command and didn't find how to do it using enterprise Manager..
Any help would be VERY welcome ;-))
Florent -- Near the whole
Unable To Connect
Apr 1, 2002Everything has been working fine our SQL Server (lets call it Server A) (v2000 under NT 4), however sometime over the weekend it is unable to connect to one of our other SQL Servers (Server B).
In the Event Viewer I found this error:
SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip (TCP/IP)): Error 10013.
Everything on this server appears to be working fine, as in everything can connect to Sever A that needs to, but Server B can't connect to A, nor is it working the other way.
Also, Server A SQL Services run on port 2006, and B is on the standard 1433. Everything has been working with this up until today?
Any ideas?
Thanks!
Keith
Unable To Backup All The Dbs
Apr 24, 2008i am using sql 2005,i want to backup all the databases when i try to schedule a maintenance plan , i dont get all the databases listed event though i authenticate as SA.
View 6 Replies View RelatedUnable To Complie
Jan 26, 2007hi
i WAS ABLE TO COMPLIE this proc in the morning but droped unknowningly now iam unable to complie
all the column 'empr_id' exists when i run this speratly the select statement it works
CREATE PROCEDURE search_trans
(
@tpa_idvarchar(6),
@empr_idvarchar(18) = NULL,
@empe_keyint = NULL,
@service_start_dtedatetime= NULL,
@user_id_keyint,
@acct_type_cdevarchar(4) = NULL,
@batch_countint = 20
)
AS
BEGIN
SET NOCOUNT ON
DECLARE@total_errorstinyint,
@TXN_PROCESS_CDE_VALIDsmallint,
@DuplicateFlagint,
@user_type_cdesmallint,
@USER_TYPE_MBIsmallint,
@USER_TYPE_SYSTEMsmallint
SELECT@total_errors = 0,
@TXN_PROCESS_CDE_VALID= 1,
@DuplicateFlag=16,
@user_type_cde= dbo.udf_GetUserTypeCode(@user_id_key),
@USER_TYPE_MBI= 1,
@USER_TYPE_SYSTEM= 16,
@tpa_id = dbo.udf_IsDefaultString(@tpa_id, NULL),
@empr_id = dbo.udf_IsDefaultString(@empr_id, NULL),
@empe_key = dbo.udf_IsDefaultInt32(@empe_key, NULL),
@acct_type_cde = dbo.udf_IsDefaultString(@acct_type_cde, NULL),
@service_start_dte = dbo.udf_IsDefaultDateTime(@service_start_dte, NULL)
IF @tpa_id IS NULL
BEGIN
EXECUTE @total_errors = dbo.usp_ERR_InsertUserError @error_cde = 18015, -- TODO error code
@error_cnt = @total_errors
END
IF @total_errors > 0
BEGIN
GOTO EXITSP
END
DECLARE@TEMP_DUPLICATES TABLE
(
tpa_id VARCHAR(6) NOT NULL,
empr_id VARCHAR(18) NOT NULL,
empe_key INT NOT NULL,
service_start_dte datetime, -- TODO finish this declaration,
service_end_dte datetime,
cardholder_name VARCHAR(2000),
txn_amt_orig decimal(19,4),
approved_amt int,
denied_amt int,
merchant_name VARCHAR(50),
MTC char(4),
notes varchar(255),
txn_options smallint
)
INSERT INTO @TEMP_DUPLICATES
(
tpa_id,
empr_id,
empe_key,
service_start_dte,
service_end_dte,
cardholder_name,
txn_amt_orig,
--approved_amt
denied_amt,
merchant_name,
MTC,
notes,
is_dup
)
SELECT TOP 20 -- TODO latest entered @batch_count value duplicate records
FT.tpa_id,
FT.empr_id,
FT.empe_key,
FT.service_start_dte,
FT.service_end_dte,
(e.first_name+ ', '+ e.last_name ) AS cardholder_name, -- TODO: construct name with
firstname,lastname with joining with employee/dep tables if needed should decrypt the data
--E.first_name if cardholder_name is accessed by employee then these two column can be ignored,
--E.last_name,
FT.txn_amt_orig,
--approved_amt, -- --Need to to put condition to how to get approved amt,
FT.denied_fee, -- This column considered for denied_amt as this column doesnot exists
FT.merch_name,
FT.merch_id, -- MTC column on UI
FT.notes,
is_dup = '1'
FROM dbo.[vw_PDB_FLEX_TXN] FT (NOLOCK) INNER JOIN
dbo.[EMPLOYEE] E ON (E.[tpa_id] = FT.[tpa_id] AND E.[empr_id] = FT.[empr_id] AND E.[empe_key] =
FT.[empe_key])
inner join dbo.[TPA] T ON (E.[tpa_id] = T.[tpa_id]) INNER JOIN
dbo.[EMPLOYER] ER on (E.[tpa_id] = ER.[tpa_id] and E.[empr_id] = ER.[empr_id])
WHERE -- Duplicate records
FT.origin_cde >= 50 -- manual transactions
AND FT.txn_adjud_cde = 1 -- approved transactions
AND FT.txn_cde in ('10')
AND FT.txn_process_cde = @TXN_PROCESS_CDE_VALID -- valid
AND FT.[tpa_id] = @tpa_id
AND FT.[service_start_dte] = @service_start_dte
ANDFT.[etxn_seq_num] = 1
AND ((@acct_type_cde IS NULL) OR (@acct_type_cde IS NOT NULL AND FT.[acct_type_cde] =
@acct_type_cde))
AND (FT.txn_options & @DuplicateFlag = @DuplicateFlag)
AND FT.reimb_key is null -- not reimbused yet
-- Employer Id optional
AND ((@empr_id IS NULL) OR (@empr_id IS NOT NULL AND T.[empr_id] = @empr_id))
-- User has access to employer
AND(@user_type_cde IN (@USER_TYPE_MBI, @USER_TYPE_SYSTEM)
OR (@user_type_cde NOT IN (@USER_TYPE_MBI, @USER_TYPE_SYSTEM)
AND T.[empr_id] IN (SELECT[empr_id]
FROMdbo.[USER_EMPLOYER]
WHERE[tpa_id] = @tpa_id
ANDuser_id_key = @user_id_key)))
AND ((@empe_key IS NULL) OR (@empe_key IS NOT NULL AND FT.empe_key = @empe_key))
-- TPA is not active (All Status Except Perm Inactive)
AND T.[tpa_status_cde] < 4
-- Employer is active (All Status Except Perm Inactive)
AND ER.[empr_status_cde] < 4
ORDER BY FT.txn_dte DESC
--UNION ALL
-- join @TEMP_DUPLICATES table with dbo.[vw_PDB_FLEX_TXN]
-- to find out for each of above 20 records, possible duplicate claims
-- investigate more to make join/union/insert into -- the final goal is this SP should return all 'y' and 'n' data
EFFICIENTLY (NO CURSORS IN SP)
INSERT INTO @TEMP_DUPLICATES
(
tpa_id,
empr_id,
empe_key,
service_start_dte,
service_end_dte,
cardholder_name,
txn_amt_orig,
--approved_amt,
denied_amt,
merchant_name,
MTC,
notes,
is_dup
)
SELECT t.tpa_id,
t.empr_id,
t.empe_key,
t.service_start_dte,
t.service_end_dte,
(e.first_name+ ', '+ e.last_name ) AS cardholder_name, -- TODO: construct name with firstname,
lastname with joining with employee/dep tables
t.txn_amt_orig,
--t.approved_amt,
t.denied_fee,-- This column considered for denied_amt as this column doesnot exists
t.merch_name,
t.MTC,
t.notes ,
is_dup = '0'
FROM dbo.[vw_PDB_FLEX_TXN] T (NOLOCK) INNER JOIN @TEMP_DUPLICATES TP ON
(TP.tpa_id = T.tpa_id
AND TP.empr_id = T.empr_id
AND TP.empe_key = T.empe_key
AND TP.service_start_dte = T.service_start_dte
AND TP.[txn_amt_orig] = T.[txn_amt_orig]
)
INNER JOIN dbo.[EMPLOYEE] E ON E.empr_id = T.empr_id
WHERE (T.txn_options & @DuplicateFlag != @DuplicateFlag)
AND T.[tpa_id] = @tpa_id
AND T.[service_start_dte] = @service_start_dte
AND T.txn_cde in ('10','11','12')
ANDT.[etxn_seq_num] = 1
AND T.txn_process_cde = @TXN_PROCESS_CDE_VALID -- valid
-- NEED TO RETURN @TEMP_DUPLICATES ROWS
RETURN(0)
EXITSP:
IF @total_errors > 0
BEGIN
EXECUTE dbo.usp_ERR_GetUserErrors
END
RETURN (@total_errors)
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
error:
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'is_dup'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'empr_id'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'empr_id'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 139
Invalid column name 'is_dup'.
krmm
Unable To Take Backup
Jun 19, 2007Hi
I have Database in SQL-Server2000 size is 1.37 GB i am tryn to take backup followin are the problems:-
1. Maintainence Plan for Backup Fails for DB
2. Jobs fails for Backup
--> I goto SQL Server Logs Error message is Operating system error 23(Data error (cyclic redundancy check).)
--> Now i am tryin Backup using command :-
Backup Database 'DB1' To Disk ='Path' followin error occurs:-
"Nonrecoverable I/O error occurred on file"
--> Now i am doing back-up directly from Enterprise Manager following error message occurs same error comes
Whats surprising Jobs, maintainence plan, Backup for other database is working perfectly, i checked HDD doesnt have any bad blocks etc. i have even changed path for Backups but still only for these database it gives problem
With Regards
Unable To Remove SQL
Mar 10, 2008I'm stuck. I'm a noob when it comes to SQL (learning as I go, reading books, etc). I've been trying to setup SQL on a Windows 2003 server, and there is a bit of an issue.
There is already an instance of SQL on the server. Someone before me tried to install SQL, and for some reason removed it. However, the default instance still exists on the machine, and I am unable to install SQL 2005 on it now. Setup keeps throwing back errors. There is nothing listed in the Add/Remove programs to remove the old Default Instance. Is there some way I can completely strip SQL off this machine so I can do a fresh install?
I googled a few articles about using the SQL tools to do a forced remove, but it did not work in this situation.
MS SQL 6.5 Unable To Connect.
Jul 23, 2005Let me start by saying that, yes we know v6.5 is no longer supported byMicrosoft and that moving to SQL2000 might resolve our problem.Actually the migration to SQL2000 is 1 to 2 months out and in the QAphase now. Unfortunately we need to resolve the current 6.5 issue nowas it heavily impacts a major revenue stream for the company with everyoutage we encounter.The Problem:At least once every 24 hours the SQL Server begins disallowing new userconnections. When this happens the 2 CPUs begin to thrash. About 5minutes later the error log begins to print out the following errormessage: "Unable to connect. The maximum number of '500' configured userconnections are already connected. System Administrator can configure toa higher value with sp_configure." No new connections can be made to theserver; however, the existing connections continue to function normally.We never see anywhere near 500 user connections in the system (it tendsto average around 350 connections). If we begin to disconnect users theserver continues reporting that the maximum number of users isconnected. Eventually running queries thru an open connection will hangand we have to resort to a hard reboot of the server as neither SQLServer will not shutdown nor will the operating system.The Server:Compaq Proliant DL380 with dual 863 MHz. processors (x86 Family 6 Model8 Stepping 3 GenuineIntel), 917,020 KB of physical memory, MicrosoftWindows 2000 Server (Version 5.0.2195 Service Pack 4 Build 2195), TotalVirtual Memory 3,138,688 KB, Page File Space 2,221,668 KBSQL Server:Microsoft SQL Server 6.50 - 6.50.479 (Intel X86). Some pertinentconfiguration settings: memory - 244100 (in 2K units), user connections– 500, RA worker threads – 3, max worker threads – 255We found one reference to the above error message in the MicrosoftKnowledge Base and that refers to a condition where the server has 2GBor more of physical memory with 1.5GB assigned to SQL Server. This doesnot pertain to our situation. Have any of you ever encountered thisproblem?I appreciate your insights.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 12 Replies View RelatedUnable To Schedule DTS
Jun 7, 2007Unable to schedule DTS for picking up file in shared drive. It createstable but fails to copy. But if run in em it will execute fine (sqlserver 2000)
View 3 Replies View RelatedUnable To Set Identity_Insert Off?
Jan 24, 2007Hi i am unable to set Identity_insert off in sql server compact? Can you please tell me if sqlce supports or not?
If it does not support what is the work around that can be done?
Please tell the workaround in detail i mean altering table for identity key e.g. Because i have seen some posts that talk about alter table but i am unable to understand how that can done?
Thanks
Unable To Configure Add-in
Feb 22, 2007I have installed SP2 on my SQL 2005 instance which also houses RS of course. Additionally I installed WSS3.0 without configuring it so it has the Object Model installed (should be enough?)
I am running WSS 3.0 on a seperate Server and have the Add-in installed on there.
Following the installation instructions I am going to Application Management to configure WSS, but there is no section called "Reporting Services". Looking on the Report Server, in the Configuration I see the following error under the SharePoint Integration Setting:
The report server cannot access settings in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model is not installed or the Report Server Web Service and Windows service accounts do not have access to SharePoint databases. To configure service account access, use SharePoint Central Administration.
In my SharePoint Site I do see a SharePoint section under the "Site Settings" for managing shared schedules but I think the main issue is, that I don't see that section in Central Administration.
Any help is greatly appreciated.
Unable To Get Field Value
May 8, 2008
hi all I am using Local reports(.rdlc files).
I have created one Dataset with following Query.
SELECT COUNT(O.ORDERNO),D.DEPARTMENTNAME FROM TFMS_ORDER_REQUESTS O LEFT JOIN TFMS_DEPARTMENT_MASTER D ON D.DEPARTMENTID=O.DEPARTMENTID
GROUP BY D.DEPARTMENTNAME
I have two fields one is COUNT(O.ORDERNO) AND other one is Department name.
I have placed these two fields in Report(.rdlc file).
When i preview this report i am able to see only Departmentname fields value.
But at Count column no data is displaying.
I am getting 2 records when i execute this query in Toad.
What is the problem.
Pls help me.
Unable To Connect To SQL DB From VB
Oct 1, 2006I am using MS VB 2005 Express to connect to a DB created in SQL 2005 Express and have not been able to make a connection. I am including answers to questions along with screen shots where it would make it clear, hope they come through. I f anyone has any ideas on what I have not done, or what I have incorrectly done, please let me know. I notice in the log that the database I am trying to connecto to does not show up as started. I don't understand why is doesn't show up, and I don't understand what I would need to do to start it.
[1] Client side:
What is the connection string in you app or DSN? (please specify)
Data Source=.MSSQLSERVER;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMusuemInventory.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True
If client fails to connect, what is the client error messages? (please specify)
SQL Network Interface, error 25, Connection string is not valid
Is the client remote or local to the SQL server machine? [Remote | Local]
Local
Can you ping your server? [YES | NO ]
In cmd.exe console, type €œping -a <server_name>€?.
Yes can ping server
Can you telnet to your SQL Server? [YES | NO, please specify the error message
In cmd.exe console, type €œtelnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+€™[€˜ to bring up telnet prompt and type €œquit€? <enter>.
YES telnet connects on port 135
What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify).
Using
.NET Framework Data Provider for SQL Server
Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
Yes
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
Shared Memory
Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct.
No aliases
[2] Server side:
What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
Miscrsoft SQL Server Express
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
Express
What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
Shared Memory
Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
Yes
If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
Yes Browser is running
What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
Local System
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
Not applicable
Do you make firewall exception for SQL Browser UDP port 1434? [YES | NO | not applicable ]
No
[3] Platform:
What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
Microsoft Windows XP
Professional
Version 2002
Service Pack 2
Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)].
McAfee
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
[5] Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
Today entries in Log File
2006-10-01 03:07:35.14 spid51 Starting up database 'ReportServer'.
2006-10-01 03:07:35.28 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:07:35.28 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:07:40.50 spid51 Starting up database 'ReportServer'.
2006-10-01 03:07:40.62 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:07:40.62 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:08:45.62 spid51 Starting up database 'ReportServer'.
2006-10-01 03:08:45.75 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:08:45.75 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:10:50.75 spid51 Starting up database 'ReportServer'.
2006-10-01 03:10:50.85 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:10:50.85 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:14:55.85 spid51 Starting up database 'ReportServer'.
2006-10-01 03:14:55.98 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:14:55.98 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:23:00.98 spid51 Starting up database 'ReportServer'.
2006-10-01 03:23:01.17 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:23:01.17 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 03:39:01.20 Server Server resumed execution after being idle 47 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 03:39:01.20 spid51 Starting up database 'ReportServer'.
2006-10-01 03:39:01.31 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 03:39:01.31 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 04:11:01.31 Server Server resumed execution after being idle 1006 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 04:11:01.32 spid51 Starting up database 'ReportServer'.
2006-10-01 04:11:01.43 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 04:11:01.43 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 05:15:01.50 Server Server resumed execution after being idle 2926 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 05:15:01.50 spid51 Starting up database 'ReportServer'.
2006-10-01 05:15:01.59 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 05:15:01.59 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 07:23:01.76 spid51 Starting up database 'ReportServer'.
2006-10-01 07:23:01.87 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 07:23:01.87 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 08:18:02.20 Server Server resumed execution after being idle 1968 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 08:18:04.75 spid52 Using 'xpstar90.dll' version '2005.90.2047' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2006-10-01 08:20:02.13 spid52 Using 'xplog70.dll' version '2005.90.2047' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2006-10-01 08:33:25.51 spid54 Starting up database 'aspnetdb'.
2006-10-01 08:33:26.00 spid54 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'.
2006-10-01 08:33:26.92 spid54 Starting up database 'MyCompany'.
2006-10-01 08:33:27.21 spid54 Starting up database 'ReportServer'.
2006-10-01 08:33:27.40 spid54 Starting up database 'ReportServerTempDB'.
2006-10-01 08:33:27.88 spid54 Starting up database 'aspnetdb'.
2006-10-01 10:50:18.71 Server Server resumed execution after being idle 4523 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 10:50:18.73 Logon Error: 17828, Severity: 20, State: 3.
2006-10-01 10:50:18.73 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]
2006-10-01 11:19:40.78 Server Server resumed execution after being idle 672 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 11:36:52.20 spid52 Starting up database 'aspnetdb'.
2006-10-01 11:36:52.45 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'.
2006-10-01 11:36:52.98 spid52 Starting up database 'MyCompany'.
2006-10-01 11:36:53.29 spid52 Starting up database 'ReportServer'.
2006-10-01 11:36:53.56 spid52 Starting up database 'ReportServerTempDB'.
2006-10-01 11:36:53.96 spid52 Starting up database 'aspnetdb'.
2006-10-01 11:37:27.62 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'.
2006-10-01 11:37:28.21 spid52 Starting up database 'MyCompany'.
2006-10-01 11:37:28.48 spid52 Starting up database 'ReportServer'.
2006-10-01 11:37:28.71 spid52 Starting up database 'ReportServerTempDB'.
2006-10-01 11:39:02.56 spid52 Starting up database 'ReportServer'.
2006-10-01 11:39:02.67 Logon Error: 18456, Severity: 14, State: 16.
2006-10-01 11:39:02.67 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]
2006-10-01 12:39:22.70 Server Server resumed execution after being idle 2709 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 14:02:22.34 Server Server resumed execution after being idle 1287 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2006-10-01 14:02:22.34 Logon Error: 17828, Severity: 20, State: 3.
2006-10-01 14:02:22.34 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]
Last but not least:
There is a wealth of information already available to help you answer your questions.
(1) SQL Server 2005 Books Online: http://msdn2.microsoft.com
(2) Microsoft Support Knowledge Base: http://support.microsoft.com
(3) SQL Protocol Team Blog: http://blogs.msdn.com/sql_protocols
(4) MSN Search: http://search.msn.com/ or use your favorite search engine.
Unable To Connect
Jul 16, 2006I am unable to connect SQL Server Management Studio to any of the databases on my computer. At this stage I am simply starting the Management Studio and asking it to connect to a database I made a few months ago before this connection trouble arose. I'm specifying the server name "BENCHLAP" which is the name of My Computer, using Windows Authentication.
The error I get is:
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. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
The client is local. At least, it is if I understand correctly - the instance of SQL Server is installed on the same machine as the instance of IIS that I intend to use to test my web applications after we have resolved this issue, and the same machine as the one I shall use to view the application on.
I can ping the server if i type "ping -a BENCHLAP". It is successful
I think it also connects via telnet ok as well, by typing "telnet BENCHLAP 135"
All client protocols are enabled, as are the server protocols. Don't know if this is a security risk but I did it to try and solve the problem, to no avail. There are no aliases, according to the Configuration Manager.
The server itself is SQL Server Express 2005, runnning on Windows XP Professional. My anti virus software is AVG.
I'm afraid I don't know anything more, and have been researching this error for quite some time now.
Is anybody able to help me please?
Ben
Unable To Add New Publication
Jun 2, 2006I have been wrestling with this one all day and cannot find anything on MSDN, google, etc.... I have configured replication, but cannot create a new publication either programmatically or using the wizard.
I programmatically did the following:
1. I set up my local server as a distributor, and created a distribution database (@distributor set to server sysname)
execute sp_adddistributor @distributor = @distributor
execute sp_adddistributiondb @database = @distributionDB, @security_mode=1;
2. I registered my local server also as a Publisher (@publisher set to server sysname, @distribution = 'distributor')
SELECT @sql = 'sp_adddistpublisher @publisher = ''' + @publisher +
''', @distribution_db = ''' + @distributionDB +
''', @working_directory = ''' + @directory + ''', @security_mode = 1'
SELECT @sp_executesql = quotename(@distributionDB) + '..sp_executesql '
EXEC @sp_executesql @sql
3. I enabled my local database for transactional replication (@replicationDB)
exec sp_replicationdboption
@dbname = @replicationDB,
@optname = 'publish', @value = 'true
4. I added a logReaderAgent on the ReplicationDB
SELECT @sql = 'sp_addlogreader_agent @publisher_security_mode = 1'
SELECT @sp_executesql = quotename(@replicationDB) + '..sp_executesql
EXEC @sp_executesql @sql
All is well up to this point, no problems, all looks great. When I check the status of things using sp_help repl stored procedures to check on publisher, distributor all looks healthy. Also looks good when I use the SSMS replication interface to check on distributor, publisher, etc. . HOWEVER...... I cannot create any publications.
I tried programmatically, and also by using the wizard.
I keep getting the same error :'Cannot insert the value NULL into column 'pubid', table'.
This is the sql I try to run:
EXEC sp_addpublication
@publication = 'test3333',
@status = N'active',
@allow_push = N'true',
@allow_pull = N'true'
This is the error:
Msg 515, Level 16, State 2, Procedure sp_MSrepl_addpublication, Line 1320
Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14018, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1348
Could not create the publication.
If I use the wizard instead of trying to create the publication programmatically, I get this error (just about the same content, but a little different wording):
Creating Publication
- Creating Publication 'NewPublication' (Error)
Messages
* SQL Server could not create publication 'NewPublication'. (New Publication Wizard)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.
Could not create the publication.
Object 'NewPublication' does not exist or is not a valid object for this operation.
Changed database context to 'CypressMaster'.
The statement has been terminated. (Microsoft SQL Server, Error: 515)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476
- Adding articles (Stopped)
- Starting the Snapshot Agent (Stopped)
- Generating a script file (Stopped)
Unable To Install SP1
Jan 18, 2007Microsoft Update tells me it is unable to install SQL Server 2005 Service Pack 1 (several times). When I check the Update History, I see that Error Code: 0x2B18 is returned. However, I can't find out anything about this error code and it just tells me to retry installing the update.
I also tried downloading an update from MS Downloads to attempt a manual installation, but that failed as well.
I'm dealing with a newly migrated instance of Windows Small Business Server 2003 Premium R2 on a new HP ML350 G5 Server.
Any helpful suggestions would be appreciated.
Unable To Create Database
Jun 17, 2006Hi, I need urgent help with this problem because I am unable to do any database development due to it. I am using visual web developer express edition with sql server 2005 express edition. The problem is that when I try to create a database in the app_data folder I get the following error message: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed".
Regards, sandy
Unable To Remote Access
Nov 22, 2006Hi all,
I encounter a problem of unable to access Remote Server after i placed my web application into the web server.
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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
So I googled and tried lot of different ways of connecting.By piped name, IP, trying instance which that server don't even have one :X.I also tried typing in cmd > telnet localhost 1433It appeared that the telnet fail, i tried it on other machine, it works. So is it cause by denied of access through that port?I checked at the sql client network, it show 1433, i check the server too, it show 1433.I also checked if there's any firewall, it appear there is no firewall at all.The sql server i trying to connect is SQL 2000, it run by Windows Server 2003
Any advise or more information you needed to help me solve this problem?Thanks
Unable To Grant For SqlQueryNotificationService
Feb 26, 2007GRANT SEND ON SERVICE::SqlQueryNotificationService TO guestI need to run that T-SQL command to allow Query Notifications and I keep getting this error.Cannot find the service 'QueryNotificationService', because it does not exist or you do not have permission.I am logged in with my user account with Administrator rights along with just about every permission I can think of for the SQL Server account. I even logged in as SA and it also fails when trying to run this command. This is being done on SQL Express. So I also logged into my Windows 2003 Server with a fresh install of SQL Server 2005 Dev Edition and this also fails with the same error.Clearly I need some permission correction or something else is missing from both installations.Please help!
View 1 Replies View RelatedUnable To Access SQL Databse
Mar 2, 2007Hi,
I have a SQL Server 2005 Express database dbase.mdf which I cannot access. It works fine in VWD and the development server using the following connection string: String connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbase.mdf;Integrated Security=True;User Instance=True"But when the site is not on the development server but on IIS, I get a SqlException saying "User does not have permission to perform this action." when I execute the connection.Open() command. I find it extremely frustrating that something which works in the development server fails on the real server. Can anyone help me with this? Do I have to change my connection string, or perhaps set some permissions...I have already given the IUSR_MACHINENAME account and the ASPNET account full access to dbase.mdf. Surely this must be an issue that lots of people deal with... How do other people manage to log to access databases? Any help would be much appreciated. Thanks,P1000
Unable To Update SQL Database
May 11, 2007I'm using a formview to display, insert and update records and it appears to be working fine except when I try to update anything. It takes the update and goes back to diaply mode but the changes aren't reflected in the data for some reason. It's like I didn't change anything at all.
Here's the SQL statement and parameters (I put elipses in to shorten it of course):...
<body>
<% 'Response.Write(Request.UserHostName)%>
<form id="form1" runat="server">
<div align=center>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BGHelpdeskConnectionString %>"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT RequestID, ReqDate, ReqGSN, ReqName ... FROM tblRequests ORDER BY RequestID DESC" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [tblRequests] WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND [ReqGSN] = @original_ReqGSN AND ... [Other] = @original_Other AND [Comments] = @original_Comments" InsertCommand="INSERT INTO [tblRequests] ([ReqDate], [ReqGSN], [ReqName], ... [Other], [Comments]) VALUES (@ReqDate, @ReqGSN, @ReqName, ... @Other, @Comments)" UpdateCommand="UPDATE [tblRequests] SET [ReqDate] = @ReqDate, [ReqGSN] = @ReqGSN, [ReqName] = @ReqName, ... [Other] = @Other, [Comments] = @Comments WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND ... [Other] = @original_Other AND [Comments] = @original_Comments">
<DeleteParameters>
<asp:Parameter Name="original_RequestID" Type="Int32" />
<asp:Parameter Name="original_ReqDate" Type="DateTime" />
<asp:Parameter Name="original_ReqGSN" Type="String" />
...
<asp:Parameter Name="original_Other" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ReqDate" Type="DateTime" />
<asp:Parameter Name="ReqGSN" Type="String" />
<asp:Parameter Name="ReqName" Type="String" />
...
<asp:Parameter Name="Other" Type="String" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="original_RequestID" Type="Int32" />
<asp:Parameter Name="original_ReqDate" Type="DateTime" />
<asp:Parameter Name="original_ReqGSN" Type="String" />
<asp:Parameter Name="original_ReqName" Type="String" />
...
<asp:Parameter Name="original_Other" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ReqDate" Type="DateTime" />
<asp:Parameter Name="ReqGSN" Type="String" />
<asp:Parameter Name="ReqName" Type="String" />
<asp:Parameter Name="ReqPhone" Type="String" />
... etc
And here's my formview:1 <asp:FormView ID="FormView1" runat="server" DataKeyNames="RequestID"
2 DataSourceID="SqlDataSource1" Width="800px" BackColor="Transparent" BorderStyle="None" OnItemInserting="FormView1_ItemInserting">
3 <EditItemTemplate>
4 <table id="Table4" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
5 onclick="return TABLE1_onclick()" width="800">
6 <tr>
7 <td bgcolor="#93bde7" colspan="3" style="height: 20px; text-align: right">
8 <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif"
9 ToolTip="Submit Form" />
10 <asp:ImageButton ID="ImageButton2" runat="server" CausesValidation="False"
11 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" ToolTip="Cancel Request" /></td>
12 </tr>
13 <tr style="color: #000000">
14 <td rowspan="2" style="width: 400px; text-align: right" valign="top">
15 </td>
16 <td rowspan="2" style="width: 135px" valign="top">
17 Request Type:
18 <br />
19 <asp:RadioButtonList ID="RadioButtonList1" runat="server" SelectedValue='<%# Bind("ReqType", "{0}") %>'>
20 <asp:ListItem>Starter</asp:ListItem>
21 <asp:ListItem>Leaver</asp:ListItem>
22 <asp:ListItem>Mover</asp:ListItem>
23 <asp:ListItem>Ad Hoc</asp:ListItem>
24 </asp:RadioButtonList>
25 </td>
26 <td rowspan="2" style="text-align: right">
27 <img height="77" src="../img/CSBGLogoMed.jpg" width="226" /></td>
28 </tr>
29 <tr>
30 </tr>
31 </table>
32 <br />
33 <table id="Table5" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
34 onclick="return TABLE1_onclick()" width="800">
35 <tr>
36 <td bgcolor="#93bde7" colspan="3" style="height: 20px">
37 </td>
38 </tr>
39 <tr>
40 <td rowspan="2" style="text-align: right; width: 264px;">
41 <asp:Label ID="Label6" runat="server" Text="Legal First Name:"></asp:Label>
42 <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>' Width="120px"></asp:TextBox>
43 <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="FirstNameTextBox">*</asp:RequiredFieldValidator><br />
44 <asp:Label ID="Label8" runat="server" Text="Known As:"></asp:Label>
45 <asp:TextBox ID="KnownAsTextBox" runat="server" Text='<%# Bind("KnownAs") %>' Width="120px"></asp:TextBox>
46 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="KnownAsTextBox">*</asp:RequiredFieldValidator>
47 <br />
48 <asp:Label ID="Label10" runat="server" Text="Middle Name"></asp:Label>
49 <asp:TextBox ID="MiddleNameTextBox" runat="server" Text='<%# Bind("MiddleName") %>' Width="120px"></asp:TextBox>
50 <br />
51 <asp:Label ID="Label12" runat="server" Text="Last Name:"></asp:Label>
52 <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>' Width="120px"></asp:TextBox>
53 <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="LastNameTextBox">*</asp:RequiredFieldValidator>
54 <br />
55 <br />
56 <asp:Label ID="Label14" runat="server" Text="Global Short Name:"></asp:Label>
57 <asp:TextBox ID="GlobalShortNameTextBox" runat="server" Text='<%# Bind("GlobalShortName") %>' Width="120px"></asp:TextBox> <br />
58 <br />
59 <asp:Label ID="Label16" runat="server" Text="Employment Type:"></asp:Label>
60 <asp:DropDownList ID="DropDown1" runat="server" SelectedValue='<%# Bind("EmpType") %>' Width=120>
61 <asp:ListItem Value="Employee ">Employee </asp:ListItem>
62 <asp:ListItem Value="Contractor">Contractor</asp:ListItem>
63 </asp:DropDownList><br />
64 <br />
65 <asp:Label ID="Label18" runat="server" Text="Contract Type:"></asp:Label>
66 <asp:TextBox ID="ContractTypeTextBox" runat="server" Text='<%# Bind("ContractType") %>' Width="120px"></asp:TextBox>
67 <br />
68 <asp:Label ID="Label20" runat="server" Text="Agency:"></asp:Label>
69 <asp:TextBox ID="AgencyTextBox" runat="server" Text='<%# Bind("Agency") %>' Width="120px"></asp:TextBox>
70 <br />
71 <br />
72 <asp:Label ID="Label22" runat="server" Text="Hire Date:"></asp:Label>
73 <asp:TextBox ID="StartDateTextBox" runat="server" Text='<%# Bind("StartDate") %>' Width="120px"></asp:TextBox>
74 <br />
75 EndDate:<asp:TextBox ID="EndDateTextBox" runat="server" Text='<%# Bind("EndDate") %>' Width="120px"></asp:TextBox>
76 </td>
77 <td rowspan="2" style="text-align: right; width: 222px;">
78 Existing Position
79 <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("ExistingPosition") %>' Width="120px" /><br />
80 Job Title:
81 <asp:TextBox ID="JobTitleTextBox" runat="server" Text='<%# Bind("JobTitle") %>' Width="120px"></asp:TextBox><br />
82 Department:
83 <asp:TextBox ID="DepartmentTextBox" runat="server" Text='<%# Bind("Department") %>' Width="120px"></asp:TextBox><br />
84 Site Location:
85 <asp:TextBox ID="SiteLocationTextBox" runat="server" Text='<%# Bind("SiteLocation") %>' Width="120px"></asp:TextBox><br />
86 <br />
87 Company Code:
88 <asp:TextBox ID="CompanyCodeTextBox" runat="server" Text='<%# Bind("CompanyCode") %>' Width="120px"></asp:TextBox><br />
89 Cost Center:
90 <asp:TextBox ID="CostCenterTextBox" runat="server" Text='<%# Bind("CostCenter") %>' Width="120px"></asp:TextBox><br />
91 <br />
92 Function Code:<br />
93 <asp:DropDownList ID="DropDown3" runat="server" SelectedValue='<%# Bind("FunctionCode") %>'>
94 <asp:ListItem Selected="True">Select one...</asp:ListItem>
95 <asp:ListItem>Commercial - Brand/Consumer Marketing</asp:ListItem>
96 <asp:ListItem>Commercial - Trade/Customer Marketing</asp:ListItem>
97 <asp:ListItem>Commercial - Marketing - Misc</asp:ListItem>
98 <asp:ListItem>Commercial - Sales - Account Mgmt</asp:ListItem>
99 <asp:ListItem>Commercial - Sales - Field Sales</asp:ListItem>
100 <asp:ListItem>Commerical - Sales - Misc</asp:ListItem>
101 <asp:ListItem>Commercial - Innovation/Activity Mgmt</asp:ListItem>
102 <asp:ListItem>Commercial - Licensing</asp:ListItem>
103 <asp:ListItem>Commerical - Franchise & Export</asp:ListItem>
104 <asp:ListItem>Commercial - Consumer Insight & Resch</asp:ListItem>
105 <asp:ListItem>Supply Chain - General</asp:ListItem>
106 <asp:ListItem>Supply Chain - QEHS (formerly Compliance)</asp:ListItem>
107 <asp:ListItem>Supply Chain - Manufacturing Indirect</asp:ListItem>
108 <asp:ListItem>Supply Chain - Distribution Indirect</asp:ListItem>
109 <asp:ListItem>Supply Chain - Procurement</asp:ListItem>
110 <asp:ListItem>Supply Chain - Manufacturing Direct</asp:ListItem>
111 <asp:ListItem>Supply Chain - Distribution Direct</asp:ListItem>
112 <asp:ListItem>Finance - Strategy</asp:ListItem>
113 <asp:ListItem>Finance - Finance</asp:ListItem>
114 <asp:ListItem>Finance - Business Process Support</asp:ListItem>
115 <asp:ListItem>Finance - Information Technology/RICS</asp:ListItem>
116 <asp:ListItem>Finance - SBS - General</asp:ListItem>
117 <asp:ListItem>Finance - SBS - HR</asp:ListItem>
118 <asp:ListItem>Finance - SBS - Finance</asp:ListItem>
119 <asp:ListItem>Finance - SBS - Customer to Cash</asp:ListItem>
120 <asp:ListItem>Finance - SBS - Corporate Services</asp:ListItem>
121 <asp:ListItem>Human Resources - Human Resources</asp:ListItem>
122 <asp:ListItem>Human Resources - Communications</asp:ListItem>
123 <asp:ListItem>Human Resources - External Affairs</asp:ListItem>
124 <asp:ListItem>Legal</asp:ListItem>
125 <asp:ListItem>Chief Executive's Committee</asp:ListItem>
126 <asp:ListItem>General Management</asp:ListItem>
127 <asp:ListItem>Science & Technology</asp:ListItem>
128 </asp:DropDownList>
129 </td>
130 <td rowspan="2" style="text-align: right">
131 <asp:Panel ID="Panel2" runat="server" Width="100%">
132 Manager:</asp:Panel>
133 <br />
134 <asp:Panel ID="Panel1" runat="server" DefaultButton="MgrNameButton" Width="100%">
135 <asp:TextBox ID="MgrNameTextBox" runat="server" Text='<%# Bind("MgrName") %>' Width="104px"></asp:TextBox>
136 <asp:Button ID="MgrNameButton" runat="server" Text="Check Name" OnClick="ValidateManager" CausesValidation="False" Font-Size="8pt" Width="72px" />
137 <asp:Label ID="MgrNameLabel" runat="server" Text="Label" Visible="False" Width="184px" Font-Size="8pt"></asp:Label></asp:Panel>
138 <br />
139 Phone:
140 <asp:TextBox ID="MgrPhoneTextBox" runat="server" Text='<%# Bind("MgrPhone") %>' Width="120px"></asp:TextBox><br />
141 Email:
142 <asp:TextBox ID="MgrEmailTextBox" runat="server" Text='<%# Bind("MgrEmail") %>' Width="120px"></asp:TextBox><br />
143 <br />
144 Alternate Manager Information:
145 <br />
146 Name:
147 <asp:TextBox ID="AltMgrNameTextBox" runat="server" Text='<%# Bind("AltMgrName") %>' Width="120px"></asp:TextBox><br />
148 Phone:
149 <asp:TextBox ID="AltMgrPhoneTextBox" runat="server" Text='<%# Bind("AltMgrPhone") %>' Width="120px"></asp:TextBox><br />
150 Email:
151 <asp:TextBox ID="AltMgrEmailTextBox" runat="server" Text='<%# Bind("AltMgrEmail") %>' Width="120px"></asp:TextBox><br />
152 <br />
153 HRAdmin:
154 <asp:TextBox ID="HRAdminTextBox" runat="server" Text='<%# Bind("HRAdmin") %>' Width="120px"></asp:TextBox></td>
155 </tr>
156 <tr>
157 </tr>
158 </table>
159 <br />
160 <table id="Table6" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
161 onclick="return TABLE1_onclick()" width="800">
162 <tr>
163 <td bgcolor="#93bde7" colspan="2" style="height: 20px">
164 </td>
165 </tr>
166 <tr>
167 <td rowspan="2" style="width: 246px; text-align: right" valign="top">
168 ComputerType:
169 <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind("ComputerType") %>' Width=120>
170 <asp:ListItem Selected="True">Use Existing Computer</asp:ListItem>
171 <asp:ListItem>New Desktop Required</asp:ListItem>
172 <asp:ListItem>New Laptop Required</asp:ListItem>
173 </asp:DropDownList><br /> Laptop Bag:
174 <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("LaptopBag") %>' Width="120px" /><br />
175 Laptop Dock:
176 <asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("LaptopDock") %>' Width="120px" /><br />
177 Monitor:
178 <asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Bind("Monitor") %>' Width="120px" /><br />
179 Printer Type:
180 <asp:TextBox ID="PrinterTypeTextBox" runat="server" Text='<%# Bind("PrinterType") %>' Width="120px"></asp:TextBox><br />
181 Long Distance:
182 <asp:CheckBox ID="CheckBox5" runat="server" Checked='<%# Bind("LongDistance") %>' Width="120px" /><br />
183 SSN5:
184 <asp:TextBox ID="SSN5TextBox" runat="server" Text='<%# Bind("SSN5") %>' Width="120px"></asp:TextBox><br />
185 SAP Midwest:
186 <asp:CheckBox ID="CheckBox6" runat="server" Checked='<%# Bind("SAPMidwest") %>' Width="120px" /><br />
187 SAP Southwest:
188 <asp:CheckBox ID="CheckBox7" runat="server" Checked='<%# Bind("SAPSouthwest") %>' Width="120px" /><br />
189 SAP Mirror:
190 <asp:TextBox ID="SAPMirrorTextBox" runat="server" Text='<%# Bind("SAPMirror") %>' Width="120px"></asp:TextBox><br />
191 SAP Approve:
192 <asp:CheckBox ID="CheckBox8" runat="server" Checked='<%# Bind("SAPApprove") %>' Width="120px" /><br />
193 Margin Minder:
194 <asp:TextBox ID="MarginMinderTextBox" runat="server" Text='<%# Bind("MarginMinder") %>' Width="120px"></asp:TextBox><br />
195 Nextel Type:
196 <asp:TextBox ID="NextelTypeTextBox" runat="server" Text='<%# Bind("NextelType") %>' Width="120px"></asp:TextBox><br />
197 MyCS:
198 <asp:CheckBox ID="CheckBox9" runat="server" Checked='<%# Bind("MyCS") %>' Width="120px" /><br />
199 Notes DB:
200 <asp:TextBox ID="NotesDBTextBox" runat="server" Text='<%# Bind("NotesDB") %>' Width="120px"></asp:TextBox><br />
201 Outlook Email:
202 <asp:CheckBox ID="CheckBox10" runat="server" Checked='<%# Bind("OutlookEmail") %>' Width="120px" /><br />
203 Dept Share:
204 <asp:TextBox ID="DeptShareTextBox" runat="server" Text='<%# Bind("DeptShare") %>' Width="120px"></asp:TextBox><br />
205 Share Point:
206 <asp:CheckBox ID="CheckBox11" runat="server" Checked='<%# Bind("SharePoint") %>' Width="120px" /><br />
207 EPM:
208 <asp:CheckBox ID="CheckBox12" runat="server" Checked='<%# Bind("EPM") %>' Width="120px" /><br />
209 CliqBook:
210 <asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Bind("CliqBook") %>' Width="120px" /><br />
211 VPN:
212 <asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Bind("VPN") %>' Width="120px" /><br />
213 Other:
214 <asp:TextBox ID="OtherTextBox" runat="server" Text='<%# Bind("Other") %>' Width="120px"></asp:TextBox><br />
215 </td>
216 <td colspan="1" rowspan="2" style="text-align: right" valign="top">
217 Comments:
218 <br />
219 <asp:TextBox ID="CommentsTextBox" runat="server" Height="367px" Text='<%# Bind("Comments") %>'
220 Width="486px" TextMode="MultiLine" BorderStyle="Solid" BorderWidth="1px"></asp:TextBox><br />
221 <br />
222 </td>
223 </tr>
224 <tr>
225 </tr>
226 <tr>
227 <td background="../img/csbanner.jpg" bgcolor="#93bde7" colspan="2" rowspan="1" style="text-align: left">
228 <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif"
229 ToolTip="Submit Form" /> <asp:ImageButton ID="ImageButton4" runat="server" CausesValidation="False"
230 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" />
231 </td>
232 </tr>
233 </table>
234 <asp:ValidationSummary ID="ValidationSummary1" runat="server" BackColor="Yellow"
235 DisplayMode="SingleParagraph" Font-Bold="True" HeaderText="Please fill in the fields indicated with a red asterisk (*)"
236 Width="800px" />
237 </EditItemTemplate>
238 <InsertItemTemplate>
239 ...
240 </InsertItemTemplate>
241 <ItemTemplate>
242 ...
243 </ItemTemplate>
244 </asp:FormView>
Unable To Connect .NET To SQL Express 5!!!!
Feb 10, 2008Cannot someone please help me with following problem. I am trying to create a program to update a sql datbase from.NET 2003. I am doing this by using SQL Server Express 5. The problem is, is that when I run the program and click the button to view the table in SQL Express 5 I keep getting an 'System.NullReferenceException' and the table is not shown. When I look at the debug details it says that 'object reference not set to an instance of an object'.
Am not sure where am goin wrong as the connection is opened to the local server in SQL Express and I have created a connection object and initialised it to the address fo the datatable in SQL.
Please find below the code I am working on which shows the connection string in question and the table being called in button 6 which causes the exception.
Any help would be greatly appreciated....thanks
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;namespace MovieBase
{
/// <summary>
/// Summary description for Form1.
/// </summary>public class Form1 : System.Windows.Forms.Form
{private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;private System.Windows.Forms.Button button3;
private System.Windows.Forms.Label label1;private System.Windows.Forms.Button button4;
private System.Windows.Forms.Button button5;private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Windows.Forms.ComboBox GengreList;private System.Windows.Forms.Button button6;
private System.Windows.Forms.Button button7;private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
private System.Windows.Forms.Label label2;public DataSet MDSet = new DataSet();
SqlDataAdapter MyAdapt;private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
private System.Data.SqlClient.SqlCommand sqlInsertCommand2;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;public SqlConnection MovCon = new SqlConnection("Data Source = SHERMAN/SQLEXPRESS;Initial Catalog= MovieDBase;User Id=myUsername;Password=myPassword");
/// <summary>
/// Required designer variable.
/// </summary>private System.ComponentModel.Container components = null;public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>protected override void Dispose( bool disposing )
{if( disposing )
{if (components != null)
{
components.Dispose();
}
}base.Dispose( disposing );
}#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>private void InitializeComponent()
{System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));
this.button1 = new System.Windows.Forms.Button();this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();this.label1 = new System.Windows.Forms.Label();
this.button4 = new System.Windows.Forms.Button();this.button5 = new System.Windows.Forms.Button();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();this.GengreList = new System.Windows.Forms.ComboBox();
this.button6 = new System.Windows.Forms.Button();this.button7 = new System.Windows.Forms.Button();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();this.label2 = new System.Windows.Forms.Label();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();this.SuspendLayout();
//
// button1
// this.button1.Location = new System.Drawing.Point(184, 168);
this.button1.Name = "button1";this.button1.Size = new System.Drawing.Size(96, 23);
this.button1.TabIndex = 0;this.button1.Text = "Add A Movie";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
// this.button2.Location = new System.Drawing.Point(184, 248);
this.button2.Name = "button2";this.button2.Size = new System.Drawing.Size(96, 23);
this.button2.TabIndex = 1;this.button2.Text = "Delete A Movie";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
// this.button3.Location = new System.Drawing.Point(184, 208);
this.button3.Name = "button3";this.button3.Size = new System.Drawing.Size(96, 23);
this.button3.TabIndex = 2;this.button3.Text = "View Movies";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// label1
// this.label1.Font = new System.Drawing.Font("Myriad Web Pro", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label1.Location = new System.Drawing.Point(280, 8);this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(120, 24);this.label1.TabIndex = 3;
this.label1.Text = "MOVIEBASE";
//
// button4
// this.button4.Location = new System.Drawing.Point(448, 344);
this.button4.Name = "button4";this.button4.Size = new System.Drawing.Size(192, 23);
this.button4.TabIndex = 4;this.button4.Text = "Current Movie Count";
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// button5
// this.button5.Location = new System.Drawing.Point(496, 112);
this.button5.Name = "button5";this.button5.Size = new System.Drawing.Size(128, 32);
this.button5.TabIndex = 5;this.button5.Text = "Find Movie";
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// sqlConnection1
// this.sqlConnection1.ConnectionString = "workstation id=SHERMAN;packet size=4096;integrated security=SSPI;data source="SHE" +
"RMAN\SQLEXPRESS";persist security info=False;initial catalog=MovieDBase";this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage);
//
// GengreList
// this.GengreList.BackColor = System.Drawing.SystemColors.InactiveCaptionText;this.GengreList.Items.AddRange(new object[] {
"Horror",
"Comedy",
"Family/Entertainment",
"Drama",
"Boxsets",
"Sci -fi/Fantasy"});this.GengreList.Location = new System.Drawing.Point(184, 344);
this.GengreList.Name = "GengreList";this.GengreList.Size = new System.Drawing.Size(121, 21);
this.GengreList.TabIndex = 6;
//
// button6
// this.button6.Location = new System.Drawing.Point(264, 104);
this.button6.Name = "button6";this.button6.Size = new System.Drawing.Size(160, 40);
this.button6.TabIndex = 7;this.button6.Text = "View Movie List";
this.button6.Click += new System.EventHandler(this.button6_Click);
//
// button7
// this.button7.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button7.Location = new System.Drawing.Point(360, 432);this.button7.Name = "button7";
this.button7.Size = new System.Drawing.Size(104, 40);this.button7.TabIndex = 8;
this.button7.Text = "Exit Movie Base";this.button7.Click += new System.EventHandler(this.button7_Click);
//
// sqlSelectCommand1
// this.sqlSelectCommand1.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" +
"Table 1]";this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlInsertCommand1
// this.sqlInsertCommand1.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," +
" Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" +
"umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director"));
//
// sqlDataAdapter1
// this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"),
new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"),
new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})});
this.sqlDataAdapter1.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDataAdapter1_RowUpdated);
//
// label2
// this.label2.Font = new System.Drawing.Font("Myriad Web Pro", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label2.Location = new System.Drawing.Point(64, 344);this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(120, 23);this.label2.TabIndex = 9;
this.label2.Text = "Genres";
//
// sqlSelectCommand2
// this.sqlSelectCommand2.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" +
"Table 1]";this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlInsertCommand2
// this.sqlInsertCommand2.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," +
" Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" +
"umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director"));
//
// sqlDataAdapter2
// this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"),
new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"),
new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})});
//
// Form1
// this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.SystemColors.InactiveCaption;this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
this.ClientSize = new System.Drawing.Size(704, 502);this.Controls.Add(this.label2);
this.Controls.Add(this.button7);this.Controls.Add(this.button6);
this.Controls.Add(this.GengreList);this.Controls.Add(this.button5);
this.Controls.Add(this.button4);this.Controls.Add(this.label1);
this.Controls.Add(this.button3);this.Controls.Add(this.button2);
this.Controls.Add(this.button1);this.Name = "Form1";
this.Text = "Form1";this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]static void Main()
{Application.Run(new Form1());
}private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}private void button5_Click(object sender, System.EventArgs e)
{
MessageBox.Show("///Under Construction");
}private void button1_Click(object sender, System.EventArgs e)
{
MessageBox.Show("///Under Construction");
}private void button2_Click(object sender, System.EventArgs e)
{
MessageBox.Show("///Under Construction");
}private void button3_Click(object sender, System.EventArgs e)
{
MessageBox.Show("///Under Construction");
}private void button4_Click(object sender, System.EventArgs e)
{
MessageBox.Show("There is currently no movie count available");
}private void button6_Click(object sender, System.EventArgs e)
{
Form2 F2 = new Form2();
sqlConnection1.Open();
MyAdapt.Fill(MDSet, "MovTable 1");
F2.dataGrid1.DataSource = MDSet;
}private void button7_Click(object sender, System.EventArgs e)
{this.Close();
sqlConnection1.Close();
}private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
}
}
}