Having Probs Connecting
Oct 3, 2006
this is my first time using sql server, so i guess i'm def doing something wrong here..
my connection:
Code:
objConn = "Driver={SQL Server};Server=SHEMPCWEBSERVER;Database=aoms;Trusted_Con nection=yes;"
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open objConn
Set rsLogin = Server.CreateObject("ADODB.recordset")
'Select the data from the database using the submitted data.
rsLogin.Open "SELECT * FROM tblUsers", conn
Response.Write rsLogin("fldUsrsName")
my error:
Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SHEMPCIUSR_XBOARDS-VRORER9'.
/aoms/testdb.asp, line 6
can anyone see what i'm doing wrong?
Thanks
Shem
View 2 Replies
ADVERTISEMENT
Jul 20, 2005
Hi Everybody,I am facing another probs. I have created a trigger for table Tab1 forperticular column col1 for checking value ranges.But at time for usinginsert statement it is working fine but when I am importing data fromflat file through DTS the trigger is not working.How to solve this.RegardsArijit Chatterjee
View 1 Replies
View Related
Feb 13, 2008
Hello...
I am stuck with update statement...
I am having 3 tables abc,def and xyz...
i want to update column1 of abc with column2 of def values (here the probs is i dont have any common fields between them)
i am having common values between def(column10) and xyz(column10_new)
so i am using inner join something like below....
but this looks like wrong to me...bcoz when i do this (only select):
select column2 FROM def inner join xyz on def. column10 = xyz. column10_new
i am getting different as compared to the update below....
UPDATE abc
SET column1 = column2 FROM def inner join xyz
on def. column10 = xyz. column10_new
can anyone suggest how to solve this update???
Thanks
View 2 Replies
View Related
Jul 23, 2005
Hi Group,I am trying to display the multiplication through this way----------------------select 1163436036*100----------------------Getting the error============================Server: Msg 8115, Level 16, State 2, Line 1Arithmetic overflow error converting expression to data type int.============================For that reason I was tried to convert that to nvarchar------------------------select convert(numeric(36,2),1163436036*100)------------------------But still getting the error=============================Server: Msg 8115, Level 16, State 2, Line 1Arithmetic overflow error converting expression to data type int.=============================Please help me to solve it out..Thanks and RegardsArijit Chatterjee
View 3 Replies
View Related
Dec 28, 2006
I keep getting errors while trying to install SQL 2000 enterprise edition.....
Internal Error: Contact MS Tech Support
Help !!!
View 3 Replies
View Related
Mar 1, 2007
Hi All,
I have this sql syntax which displays the records within the xml but instead of displaying 4 records (3 records relating to the last question ID) but instead resulting in only two records picking only the first options 'Unhelpful'.
Definitely doing something wrong here, please advise!
DECLARE @doc xml
SET @doc =
'<DivisionName>
<QuestInfo Custref="18759" SubDate="2006-01-01T00:00:00"
Polref="30018759" AgentID="4189" ClaimRef="14024-5647-890"/>
<DVName>Ho</DVName>
<DvcodeNo>1</DvcodeNo>
<ClaimGroup>
<CustSurveyNo>4</CustSurveyNo>
<ClaimGroupType>Water</ClaimGroupType>
<Questions>
<QuestionID>45</QuestionID>
<Answer>
<AnswerID>43</AnswerID>
<Ansoption />
</Answer>
</Questions>
<Questions>
<QuestionID>34</QuestionID>
<Answer>
<AnswerID>13</AnswerID>
<Ansoption>
<Options>Unhelpful</Options>
</Ansoption>
</Answer>
</Questions>
</ClaimGroup>
</DivisionName>'
DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT, @doc
SELECT *
FROM
OPENXML(@docHandle, '/DivisionName/ClaimGroup/Questions/Answer/
Ansoption', 2)
WITH
(DVName varchar (20) '../../../../DVName',
DvcodeNo int '../../../../DvcodeNo',
CustSurveyNo int '../../../CustSurveyNo',
ClaimGroupType varchar (20) '../../../ClaimGroupType',
QuestionID int '../../QuestionID',
AnswerID int '../AnswerID',
Ansoption varchar (30)'Options')
EXEC sp_xml_removedocument @docHandle
View 1 Replies
View Related
Apr 19, 2004
Hi folks,
I got a strange Problem with this statement:
select * from [db1].[dbo].[table1] AS db1
INNER JOIN [db2].[dbo].[table1] AS db2
ON (db1.Text = db2.Text)
Text fields are both nvarchar(50)
I think this should work, but it doesnt?
I got a SQL Server Error 446
I know, text compares are not that good, but it exists no other way....
Thanks for any advice!!!
View 10 Replies
View Related
Nov 9, 2007
I have production server 2000. The server gets disconnected sometime by itself and sometime it is working fine.Sometimes it even doesn't get restarted. Is there any problem with service packs and some performance issues.
Can you SQL guru give me best suggestion and how should i proceed.
View 3 Replies
View Related
Jan 30, 2008
when i update i want only date portion tp be displayed from datetime datatype...
create table temp11 (datecolumn datetime)
insert into temp11 values (getdate ())
insert into temp11 values (getdate ())
insert into temp11 values (getdate ())
insert into temp11 values (getdate ())
now when i am running this query,i am getting what i want...
select convert (varchar, datecolumn,111) from temp11
but when i am tyring to update in the temp11 table using the below query...
update temp11
set datecolumn = convert (varchar, datecolumn,111)
i am getting date and time as well like...
2008-01-14 00:00:00.000
2008-01-14 00:00:00.000
2008-01-14 00:00:00.000
2008-01-14 00:00:00.000
i only want the date portion in my updated new table.....
any suggestions plzzzzzzzzz
is it poss thru any sql query???or shud be done in the front end only???
View 5 Replies
View Related
Jun 11, 2007
Hi All,
I've designed a simple sales report , first grouped by Transport type and then by item.
Example
Category Item Sales
DHL A 2000
DHL C 1500
DHL E -1700
AmEx A 200
Amex E 20
-------------------------------
when click on sales under group DHL it shouild sort -say descending-
so result should be
DHL A 2000
DHL C 1500
DHL E -1700
instead I get results
DHL A 2000
DHL E -1700
DHL C 1500
this is just an example but this is the sort of results I get when I try to use interactive sorting.
Any Ideas?
thanks
Sonny
View 5 Replies
View Related
Oct 20, 2007
You notice after installing SQL Server 2005 that there is a warning message in the SQL Server log that SQL Server cannot lock pages in memory. What must you do to allow SQL Server to lock memory pages in memory?
After installing SQL Server, your customer complains that transactions are slow. You notice that there is excessive I/O in the TempDb. You want to move TempDb to another set of disks, so you have the sytem administrator configure two more logical disks on the server. What must you do to configure the SQL Server TempDb on this new set of disks?
You are instructed to install SQL Server in an Active / Active cluster environment. What two network related pieces of information must you have prior to performing the installation?
View 3 Replies
View Related
Mar 22, 2001
Has anyone faced problems in calling one stored procedure from within another stored procedure ? I am considering using nested SPs, and would appreciate any inputs on it.
Thks,
SC
View 2 Replies
View Related
Jun 30, 2006
Hi All,
It would be great if anybody could help me how to write a T-SQL script to generate a report in spreadSheet from a table in SQLserver 2000 database.
And this report should be generated as per the following timings(Sheduled timings only).<script></script>
As well it should be able to send a mail regarding the availability of the report to user groups.
Incase if the generation of report fails then we need to send a mail reg the failure.
Any HELP is greatly appreciated!!!
Thanks in Advance!!!
Regards,
Sashi
View 1 Replies
View Related
Mar 28, 2007
Hi:
Am trying to import XLS data into SQL 2005 SP2 thro a SSIS Data Flow task. My Excel Connection string has IMEX=1, ImportMixedTypes is set to Text and the typeguessrows is set to 0.
Import works fine for cells of Format Text, but when I have a large number (in a general Format cell) it gets converted into scientific notation(e.g. 3.234175e+7) in the table.
What am I doing wrong?
TIA
Kar
View 2 Replies
View Related
Jun 26, 2006
Hi. I am trying to figure out the code for sorting a manual (non-identity) number column in my table. the purpose is to
show the user's pictures in perfect order (1,2,3,4,5,6...).
The Jist of my problem... When a user first inserts six pictures, he gets:
|1|
|2|
|3|
|4|
|5|
|6|
All is good. But, say he deletes picture |3|. Now the list order looks like this:
|1|
|2|
<- |3| is removed
|4|
|5|
|6|
And, then he inserts two more pictures, now he his this:
|1|
|2|
|4|
|5|
|6|
|7| <- |7| & |8| are added
|8|
What i want to acheive is a "reshuffling" of the number order every time a picture is removed. So, when |3| is removed, |4| becomes |3|, |5| becomes |4| and so on. There should never be a gap in the order.
I am new to stored procedures, and have been trying to figure this out. Below is my guesswork:
Code:
ALTER PROCEDURE dbo.sp_NewPersonalPic
(
@photo_name VARCHAR(50) = NULL,
@photo_location VARCHAR(100) = NULL,
@photo_size VARCHAR(50) = NULL,
@user_name VARCHAR(50) = NULL,
@photo_caption VARCHAR(150) = NULL,
@photo_default BIT = NULL,
@photo_private BIT = NULL,
@photo_number INTEGER = NULL,
@photo_date DATETIME = NULL
)
AS
BEGIN
SELECT @photo_date = CONVERT(DATETIME,convert(char(26), getdate(), 109))
END
BEGIN
SET @photo_number = 1
SELECT
@photo_number = (
SELECT COUNT(*)
FROM dbo.PersonalPhotos b
WHERE
a.photo_date < b.photo_date
)
FROM
dbo.PersonalPhotos a
ORDER BY
a.photo_date
END
BEGIN
My thinking is that it would be a safe bet to use the "photo_date" column as a litmus for my "photo_number" column (ie, the most recent record inserted by the user will always be at a later date than the previously inserted record). So:
photo_number photo_date
|1| 2006-06-26 21:43:36.653
|2| 2006-06-26 21:43:50.000
|3| 2006-06-26 21:45:25.217
|4| 2006-06-26 21:45:33.763
|5| 2006-06-26 22:39:42.670
|6| 2006-06-26 22:39:49.200
If |3| is removed above, the numbers are reordered based on the time of entry sequence.
Any suggestions on how to acheive this in my stored procedure? Currenly, i get the correct order, but it goes crazy when i delete and add.
Thanks and sorry for the verbose post.
View 5 Replies
View Related
Aug 6, 2006
I have a database that is currently connected and working properly in My SQL Server Management Studio. The problem I am havings is when I open My ASP.net 20 and Look in my Server Solutions I can not find the database to connect to it . It seems to be trying to use SLQ Express and not my SLQ Server Management Studio. How do I get my database to connect in my application? All I can see from within the Server solutions in ASP is the database .bak file which is the backup of the database. I thank you in advance.
View 5 Replies
View Related
Apr 5, 2004
Hi,
I am trying to connect to a SQL 6.5 database with VB.NET.
Is this possible, and if so, what kind of connection string is used and what mode of data access (OleDB, ODBC, etc.)
I have had several problems doing this and I am starting to wonder if there is anything special that needs to be done or if it is even possible. Thanks in advance!
View 3 Replies
View Related
Oct 28, 1999
Has anybody experienced SQL 6.5 to stop responding to new connections to the server but still letting the existing connections run?
View 1 Replies
View Related
Sep 21, 2004
is ther a system stored procedure to connect to a database passing the username and password as parameters.. ??
View 6 Replies
View Related
Dec 8, 1999
I am trying to connect through a wan over TCP/IP to a SQL Server v.6.5 sp5a.
I am not logging into the domain, I am just trying to connect via ODBC. I keep getting an error 1326
which when I look in TechNet or MSDN refers to problems with Named Pipes. I have
TCP/IP configured for port 1433, Named Pipes, and Multiprotocol support all configured on the server.
Should I remove the Named Pipes support, or is that not the problem?
View 1 Replies
View Related
Jan 13, 2005
Hi,
I have a server (Server A) and would like to retrieve a query from a SQL DB which is held on another server (Server B), if I created a VPN or opened a port from one server to another could I acheive this?
BTW I do not have SQL running on the Server A
Am I asking for trouble?
Thanks,
Sanj
View 1 Replies
View Related
Mar 2, 2004
Hey everyone. I'm having some serious problems connecting to my database. I've pretty much bugged my server admin to death and I still can't connect to it. I've tried almost all the programs out there as well as http://www.aspenterprisemanager.com. I've probably spent a good 12 hours on this task (im trying to put MaxWebPortal on my site) and I'm going to ask for help. This is what my admin gave me for the SQL db:
Database Name: S5464_sehs
SQL Server: mssql4.uplinkearth.com
ODBC DSN: S5464_sehs
Username: sehs.us
Password: **********
Would anyone be able to help me to connect to this?
View 4 Replies
View Related
May 17, 2004
Can I connect to SQL server using sql 7 EM? currently it is not allowing me
to connect, but some one told me that there is a work around.Anyone heard/aware of it?
Regards,
Harshal.
View 3 Replies
View Related
Aug 21, 2006
Hi,
I am having trouble connecting to a dbf file inside an SSIS package. How do I connect to a dbf file in SSIS.
Thanks
Brian
View 1 Replies
View Related
Jan 16, 2008
Hey all! I am new in this form and also new with the SQL serve. I have installed that free express edition of SQL server 2005 and when i am trying to connect to server from my C#.net application i am not able to do it and the error i am getting is the user is not SQL thrusted user. I am able to connect directly thru SQL server using this userid and password but not thru C#.net application.
I have read online that so many people are having that problem. so is it the problem of swl server Express edition or do i have to make some setting to connect to the application.
Please please please please someone guide me . I am stuck here in the beginning only. I would really appreciate it.
the code that i wrote is here:----
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
}
protected void Submit_Click(object sender, EventArgs e)
{
String querry;
SqlDataReader dbread;
try
{
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["Conn1"]);
SqlCommand comm = new SqlCommand();
conn.Open();
querry = " Select password from login where userId='" + TxtUser.Text + "'";
comm.CommandText = querry;
comm.Connection = conn;
dbread = comm.ExecuteReader();
dbread = null;
if (dbread.HasRows)
{
while (dbread.Read())
{
if (dbread["password"].ToString() == Txtpwd.Text)
{
Response.Redirect("home.aspx");
}
}
Response.Write("Your Password Doesn't Match");
}
else
{
Response.Write("Your User Name Is Wrong");
}
conn.Close();
}
catch (Exception ex)
{
Response.Write(" This is an Error - " + ex.Message );
Response.End();
}
Thanks,
Komal
View 3 Replies
View Related
Jul 18, 2007
We need to connect to an DB2 server using ODBC provider, so we tried witht he folowing:
Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;
But when we try to connect using the above connection string we get teh following error:
"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.
Thanks in advance.
View 1 Replies
View Related
Jan 23, 2007
When I look at the connection string it's:
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ProcBuilder.mdf;Integrated Security=True;User Instance=True
This works fine on my machine, but when I try to run it on another computer it tells me:
"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."
It should not be trying to connect remotely, it's a local DB. Do I
have to install SQL Express on the machine I'm installing this on for
it to work?
View 1 Replies
View Related
Feb 8, 2008
Dear All,
We have Database in local system and another database in remote system.
We have to connect to the database in the remote system through RDA.
How can we achieve this?
Kindly help.
Thanks in advance.
Regards,
Sasi.
View 6 Replies
View Related
Jul 15, 2006
hi , I want to connect to sqlserver2000 with VS.Net2003 in Asp.net I
've added a new user in security section in enterprise manager and
wrote my code , but there is no output from database , codes are
correct and I think there is something wrong with sqlserver or IIS or
sqlconnectin setting , plz help me to fix my problem , tnx .
View 2 Replies
View Related
Aug 2, 2006
I have a mdf file and log file from msde. I have successfully connected to it in my Visual Studios ASP.net 2.0 Desktop. I am having a problem where it connects. fine but it does not list the tables , diagrams etc. I am trying to build the intake screen with this data but have no tables. Can some one give me a couple of suggestions of why? I am very new to ASP.net and would appreciate any help .
View 4 Replies
View Related
Sep 18, 2006
Hey all,I am new to ASP.NET. While executing a simple code , i got the error: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Whats wrong? RegardsYasir
View 1 Replies
View Related
Dec 19, 2006
My host sent these instructions, think they will work?
To access your SQL Server you can use your choice of database management software, including Microsoft Access, Visual InterDev, or the SQL Enterprise Manager.
If you are using Microsoft Access or Visual InterDev you will be connecting to the SQL Server via an ODBC connection, which requires you to make a Data Source Name (DSN) on your local computer.
If you have a Microsoft Access database, and you use the Microsoft SQL Upsizing Wizard to export your database into SQL, the Upsizing Wizard will assist you in the process of creating your ODBC connection.
To create a SQL DSN:
1. Log on to your hosting account's control panel at http://sahcinfo.org/admin 2. Click "Database Connectivity."
3. Choose "Create DSN."
4. Choose "Microsoft SQL Driver" from the Type drop-down list.
5. Enter a name for your DSN in the DSN field. It can be anything you want it to be, such as "Orders" or "MyDatabase." The Filename field is not required for SQL.
6. In the SQL IP Address field, enter the SQL Server name.
7. Enter your SQL user name in the SQL User Name field.
8. Click Submit.
To access the SQL Server using the SQL Enterprise Manager:
1. Open your SQL Enterprise Manager software. This is not supplied by Web.com.
2. Right-click on "SQL Server Group", then select "New SQL Server Registration"
3. Once the dialog box is open, fill in the fields. In the server field, type in your SQL Server name.
4. Type in the login information with your username and password.
5. Once all the information is entered click "Register." This will make contact with our SQL Server, and you will be able to add tables, manipulate your information and work on your database as you wish.
Please note that Web.com Technical Support will only troubleshoot connectivity to the SQL database, and cannot support issues with third-party software.
Web.com has also created a SQL 2000 User Guide to walk you through the process of setting up your account and database connections. To view or print it, go to http://64.226.3.32/article.asp?article=14689&p=1001
View 2 Replies
View Related
Jan 9, 2007
This is kind of the wrong place to ask VBA questions, but I've been poking around for a day and haven't got the answer, so I am hoping I can get some help here.
I am wondering if I can connect to MSSQL in MS Word Macro. If so, can I have some sample code please?
Thanks
View 3 Replies
View Related
