Database Discussion Boards

Re: SQL Server does not exists or access denied

Michael P Butler11-Feb-07 22:43

11-Feb-07 22:43

Sushant Duggal wrote:
Hi friends,

I am getting a strange error. I am working on .NET framework 1.1.
When I work on a desktop application(C#.NET) and try to connect to SQL Server 2000 through my application, everything works fine and the connection is successfully established.
But when I use the same database in web project(ASP.NET/C#), I am unable to connect to the database.
I get an error:
"SQL Server does not exists or access denied".

I have carefully checked the connection string and everything in the code if perfect.

Please help me out.

Are you using Windows Authentication or SQL authentication

If you are using Windows auth, ASP.NET runs under an ASP.NET user and so that user needs to have permissions to your database.

Michael

CP Blog [^] Development Blog [^]

Re: SQL Server does not exists or access denied

Sushant Duggal11-Feb-07 22:57

Sushant Duggal

11-Feb-07 22:57

Hi,

I am using SQL authentication.
I am using the same connection string for two projects.
One is desktop application and other is web application.
Desktop application is working fine, database connectivity is fine whereas I am unable to connect in web application.
Still I am writing the connection string for ur reference.

user id=sa;password=XXX;data source=XXX;initial catalog=XXX

Regards,

Sushant Duggal.

Re: SQL Server does not exists or access denied

Pete O'Hanlon12-Feb-07 3:01

Pete O'Hanlon

12-Feb-07 3:01

This is not an answer to your question, but rather a general comment. It is a bad idea to use the sa account as a general purpose access account. This account has special privileges which means that it can access and do things in your database that you really don't want to let outside users get access to.

There is a security principle about reducing the attack surface which applies here. If you only want the login to be able to access stored procedures and perform C RUD functions, then you really should create a dedicated account for it and use this in the connection string instead.

Sorry that I haven't answered your question, but I hope that this can help to remove what could end up being a security hole.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Export data from SQL server 2005

Spaz8011-Feb-07 21:16

Spaz80

11-Feb-07 21:16

Hello

I am writing an application that should export some data from an SQL server 2005 server to an SQL Mobile (sdf file) on an remote PC.
What is the best way of doing this?

I want the user to be abel to choose witch data that should be exportet. So it is not allways the complete database that will be exportet

The user will then modify the data on the remote PC, and the idee is that he/she Smile | :)

then could "import" the data, with some merge (conflict solving) solution. Any idees on how to solve this is appreciated.

Cheers

Spaz

Calculating the Time length

minkinin11-Feb-07 20:14

minkinin

11-Feb-07 20:14

Hi everyone.
pls help,I am busy with the security access system which monitores arrival ,lunch and depature time,so I need to calculate the time length
eg my table looks like this:
Date Name TimeIN TimeOUT Length
12/2/2007 Myself 7:45 12:00 4:55

so how do I calculate that 4:55 which is the difference of TImeIN and TimeOUT,I need a sql statement or any calculation methods to do that.

Thanks in advance.

Re: Calculating the Time length

Blue_Boy11-Feb-07 22:05

Blue_Boy

11-Feb-07 22:05

Hope this helps

DECLARE @dd AS datetime<br />
SET @dd =(SELECT convert(datetime,TimeOUT) - convert(datetime,TimeIN))<br />
<br />
SELECT convert(varchar,@dd,108) AS minutes

Re: Calculating the Time length

minkinin12-Feb-07 0:09

minkinin

12-Feb-07 0:09

thanks,but is still not working because the datatype of TimeIN and TimeOUT is Nvarchar not datetime,I did that because I wanted to insert them as DateTime.Now.ToShortDateString();so how will I manage to get the difference of nvarchar datype fields.
help....

Re: Calculating the Time length

Blue_Boy12-Feb-07 0:23

Blue_Boy

12-Feb-07 0:23

try converting fields TimeOUT and TimeIN in varchar datatype.

DECLARE @dd AS datetime<br />
SET @dd =(SELECT convert(datetime,cast(TimeOUT as varchar)) - convert(datetime,cast(TimeIN as varchar)))<br />
<br />
SELECT convert(varchar,@dd,108) AS minutes

Re: Calculating the Time length

gauthee11-Feb-07 22:07

gauthee

11-Feb-07 22:07

you can use the datediff function to dothis!

first, get the differnce in hrs and then find the difference in minutes....

Gautham

less than 100 query

m.rastgar11-Feb-07 19:18

m.rastgar

11-Feb-07 19:18

Hi every body.
i want to have a query in sql server 2000 which loads the sets of number less than 100. what should i do?
SELECT ? [WHERE]?

Thanks
Rastgar

Re: less than 100 query

Bassam Saoud11-Feb-07 19:59

Bassam Saoud

11-Feb-07 19:59

m.rastgar wrote:
i want to have a query in sql server 2000 which loads the sets of number less than 100. what should i do?
SELECT ? [WHERE]?

If you are storing numbers in a column called "MyNumbers" in a table called
"MyTable" , then to get all numbers less than 100 you can do:

SELECT MyNumbers FROM MyTable WHERE MyNumbers <100

Here is a good place to start leaning SQL[^]

Program can't access the server on the network >> VB.net 2005 [modified]

kindman_nb11-Feb-07 10:48

kindman_nb

11-Feb-07 10:48

Hi ..
I'm using Vb.net 2000 and Sql Server 2000 .. and I'm using the next code to connect with database ..

Public SqlCon As SqlConnection = New SqlConnection("workstation id=DESKTOP;Password=123; packet size=4096;user id=sa;integrated security=SSPI;data source=ComputerName;persist security info=False;initial catalog=Data")

I prepare a server and the network is allready work , and the dotnet framework 2 is installed on all pc on ... and every thing is good , when I run the program on anohter pc on the net work the next message error is appearing...

Could not load file or Assembly ( ADODB, Version=7.0.3300.0, Culture=neutral , Publickey token = bo3f5711d5.a3a) or one of its dependencies . The system can nptfind the file specified

can any one help me Confused | :confused:

jooooo

-- modified at 3:26 Monday 12th February, 2007

Re: Program can't access the server on the network >> VB.net 2005

kindman_nb11-Feb-07 21:31

kindman_nb

11-Feb-07 21:31

Can any one help me >>

jooooo

Re: Program can't access the server on the network >> VB.net 2005

andyharman11-Feb-07 23:43

andyharman

11-Feb-07 23:43

Have you got the correct version of the framework installed? My understanding is that dotnet framework 2 would be for Vb.Net 2005.

Re: Program can't access the server on the network >> VB.net 2005

kindman_nb11-Feb-07 23:50

kindman_nb

11-Feb-07 23:50

andyharman wrote:
My understanding is that dotnet framework 2 would be for Vb.Net 2005.

yes it's it ...
when I make the database local on any pc , it's work as good
but when I make centeralize db on the server .. the program doesn't work
Confused | :confused:

jooooo

Advanced string manipulation - MS Access

alect11-Feb-07 8:52

alect

11-Feb-07 8:52

I want to write an Microsoft Access VBA sql query that allows me to trim text against a table field called template.
For each record the field will contain a string such as:
C:\ProgramFiles\Company\Templates\templatename.xml.

The bit I want is the template name.xml. However because the template name may be diffent for each field and because the directory path could be different for each field I need to use the last '\' as my marker to determine what to extract.

If anyone knows how to do this, any help would be appreciated.

Re: Advanced string manipulation - MS Access

andyharman11-Feb-07 23:37

andyharman

11-Feb-07 23:37

Mid([FilePath],InStrRev([FilePath],'\')+1)

Assign value of one column to other

TrooperIronMan11-Feb-07 7:44

TrooperIronMan

11-Feb-07 7:44

Say I want to put in order details current price of product, but once it's assigned it stay as is (so if it's null copy from product table if not leave as is...).

How to do this?

Re: Assign value of one column to other

Bassam Saoud11-Feb-07 19:51

Bassam Saoud

11-Feb-07 19:51

IF EXISTS(SELECT PRICE FROM ORDER WHERE PRICE IS NULL AND PRODUCT=@YOUR_PRODUCT_ID)
     BEGIN
          --DO YOUR UPDATE HERE
     END
ELSE
     BEGIN
         --PRICE ALREADY ASSIGNED
     END

sql query analyzer

Member 381773811-Feb-07 4:47

Member 3817738

11-Feb-07 4:47

can you please help me out with the login/username and password for the sql query analyzer

jaffar

Re: sql query analyzer

tommyligo11-Feb-07 5:27

tommyligo

11-Feb-07 5:27

you can login with an user of your sql server (e.g. username 'sa' and the password that you set in the setup of sql server)

Re: sql query analyzer

Rob Graham11-Feb-07 5:35

Rob Graham

11-Feb-07 5:35

query analyzer itself does not have a username/password. What it's asking for is the username/password to the SQL Server database you want to log on to. The database may not be set up for SQL authentication (in which case the username/password are not relevant). Try selecting integrated security instead.

Filling a dataset not working

Blekk10-Feb-07 14:03

Blekk

10-Feb-07 14:03

Hi,

I need a little help. I have created an untyped dataset on my form called dataSet1 and am trying to create a parent/child relationship with a datagrid displaying the data. But I am getting a weird exception on the code:

da.Fill(dataSet1);

The exception says: "Incorrect syntax near '*'"

I don't understand this exception atall.

Please help me,

Any reply is appreciated.

P.S. here is the full code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace NorthwindTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string strConnect = @"server = (local)\SQLEXPRESS; integrated security = sspi; database = C:\SQL\NORTHWND.MDF";
            string strQuery1 = @"SELECT * FROM employees";
            string strQuery2 = @"SELECT * FROM orders";
            string strQuery = strQuery1 + strQuery2;


            SqlConnection conn = new SqlConnection(strConnect);
            SqlDataAdapter da = new SqlDataAdapter(strQuery, conn);
            da.TableMappings.Add("Table", "employees");
            da.TableMappings.Add("Table1", "orders");
            da.Fill(dataSet1);
            DataRelation relation = new DataRelation("employeeorders", dataSet1.Tables[0].Columns["employeeid"], dataSet1.Tables[1].Columns["employeeid"]);
            dataSet1.Relations.Add(relation);
            dataGridView1.DataBindings.Add("datasouce", dataSet1, "employees");
        }


    }
}

Re: Filling a dataset not working

Rocky#10-Feb-07 21:02

Rocky#

10-Feb-07 21:02

Well I'd rather use a typed dataset for this. Its makes it alot easier for u
And dont combine both queries in one string. Just makea typed dataset and then just fill both tables with the TableAdapter.Fill method and add the relation to teh DatagridView
hope it helps

Rocky

Re: Filling a dataset not working

Blekk11-Feb-07 2:25

Blekk

11-Feb-07 2:25

Ok thanks, I'll try this, but I'm just a beginner at ADO.NET so I may come back here for help if I have misunderstood what you mean.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.