Re: Database Connection problem in sql server 2005 - Database Discussion Boards

First Prev Next

Re: Database Security

kubben10-May-07 3:51

kubben

10-May-07 3:51

If you are talking about a web application your web app would have to be internal only NOT on the internet if you wanted it to use windows authentication. I would still choose to use a forms base authentication which means your web app has one identity for all. If you have one identity you don't have the issues you are talking about above since you can very clearly control what access that web app identity has.

If you are talking about a windows app, sure things can be different, but you should approach windows and web app differently.

Ben

Re: Database Security

Tristan Rhodes10-May-07 4:46

Tristan Rhodes

10-May-07 4:46

I think we are talking about 2 different things mate. Smile | :)

I use forms authentication for my web apps, with a user specific connection string to the application DB. It's not a problem with the web app identity, but with authenticated users being restricted on specific records dynamicaly according to a set of dynamic rules and asp.net authorisation roles.

T

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

Update a table from a data set

G_Sankar9-May-07 3:02

G_Sankar

9-May-07 3:02

I want to update a table directly with the help of dataset. I want to pass a dataset as a parameter to sql server.I dont want to iterate a dataset in the front end. Because i have to update a nearly 1 lac rows in a single data base operation. I am using Sql server 2005 as a back end and C# language for development. If is there any solution please update me.

sankargmca

Can anyone reccomend a data access layer tool

Andrew Torrance9-May-07 2:39

Andrew Torrance

9-May-07 2:39

There are many data access layer tools , so I do not know where to start . I just want to get out of repetitive boiler plate coding . But I have a few requirments:-
1) Works with MsSQL . ( Virtually all should)
2) Produce C# code (Again - all should)
3) Must produce a data object that maps onto a row of a table .( This has been the stumbling block)
4) The data object must have no references to any DB/connection . I.e pure data . Maybe a few Ctors , ideally a struct , but if a class must support ICloneable .
5) Icing on the cake is if the data object overrides = in order to make a value comparison ( I know MS advise against it but its useful).
6) Collections of the data objects would be nice

Why the 1:1 row to object ? Well I found over the years that if I put all my effort into a normalised DB then the code almost falls into place if I produce a 1:1 row - > object . Then I use an object that maps to a table or stored procs in order to communicate with the underlying tables . Not haveing any reference to the DB in the data object means it is as light as possible in the GUI

Re: Can anyone reccomend a data access layer tool

LongRange.Shooter16-May-07 7:48

LongRange.Shooter

16-May-07 7:48

Do a search for LLBLGen and download the free version. You'll have to do some coding changes to take advantage of technology advances, but I believe it will give you most if not all that you need. I added a generated method of my own to the code PopulateBy(DataRow row) since all of the selects it generates returns a DataTable. This keeps the use of the data at the row level.

Calling stored procedures within MFC code

Ahmed Charfeddine9-May-07 2:29

Ahmed Charfeddine

9-May-07 2:29

Please how can I pass input/output params and execute an stored procedure from within an C++ code ? Is it doable with CDatabase and CRecordset MFC classes and a random database source already configured with ODBC ?
Thank you all.

Database Connection problem in sql server 2005

hbk_leo9-May-07 2:06

hbk_leo

9-May-07 2:06

Hi to all
I have a problem with database in vb.net using sqlexpress.

My problem is:

I have created a .mdf database file and tables in it, and written code for inserting data to this table through command object. But my real prob is when i supply the connection string which is created by the "data configuration wizard" to this cmd object then on runtime insert executes and also data is visible in datagridview but when i check the data in the table it is not there and all fields are NULL.
given connection string.
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\LIB.mdf;Integrated Security=True;User Instance=True")

But on the otherhand if i give connection string as ::
"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\LIB\LIB\LIB.mdf;Integrated Security=True;User Instance=True"

then data is successfully inserted in the database and i m also able to view it in my database table.

So if Any one can help me it will be highly appreciable.

Thanks.

Re: Database Connection problem in sql server 2005

Ahmed Charfeddine9-May-07 2:35

Ahmed Charfeddine

9-May-07 2:35

Is'nt this a problem of relative Vs global paths ?
I give you an example I know: if you call GetCurrentDir within a code that you execute through Debug-->Start Without Debugging command then you'll have something different as when you go to the Debug directory of your executable and run it from there.
Thus this may lead to different behaviours as when we have relative entries, such that things will work fine, in one case, and fail in the other.
Ahmed. Tunisia.

Connect Directly to SQL Server File

Brady Kelly9-May-07 0:55

Brady Kelly

9-May-07 0:55

I remember this being much shouted about way back, but can't remember the correct term for doing this to search on. Can anyone remind me please?

Re: Connect Directly to SQL Server File

andyharman9-May-07 1:57

andyharman

9-May-07 1:57

Do you mean "Using a Dedicated Administrator Connection[^]"?

Accessing database file (.sdf) after changing extension (say .abc) causes error in connection string.

ManishJape9-May-07 0:51

ManishJape

9-May-07 0:51

Accessing database file (.sdf) after changing extension (say .abc) causes error in connection string.

Hi,
I have requirement of creating database .sdf file with some different extension say .abc.
If I do so and in connection string if I try to give the string as
Dim strConnectionString As String = "C:\SQLCEDatabases\DBFileName.abc; Password ="ABCD123";"
Then it causes an error/Exception saying
"Unknown connection option in connection string: C:\SQLCEDatabases\DBFileName.abc; password."

Can I get the solution by which I can access the database file after changing its extension and accessing it through code (C# or VB.NET)

Thanks & Regards
Manish Jape

get the table name in a .mdb file

hero19958-May-07 23:41

hero1995

8-May-07 23:41

CListCtrl m_table;
CDaoDatabase db;
db.Open("D:\\ktt.mdb");
short n_table=db.GetTableDefCount( );

CDaoTableDefInfo TableInfo;
for( int i=0; i

Re: get the table name in a .mdb file

hero19959-May-07 21:37

hero1995

9-May-07 21:37

how can i remove the system objects such as MSystemQueries,... in the list

need query(urgent)

Revathi Raj8-May-07 23:30

Revathi Raj

8-May-07 23:30

Hi..
i need sql query for the ollowing requierment
input -anydate (9/05/2007)
output-given dtae presents which quater(2 quater)

Revathi Raj

Re: need query(urgent)

Colin Angus Mackay8-May-07 23:36

Colin Angus Mackay

8-May-07 23:36

Use DATEPART[^]

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

How to diplay reports in reportview control?Pls help its URGENT!!

sha_shivani8-May-07 13:34

sha_shivani

8-May-07 13:34

I have created reports using reporting services and also created reportview control in my web applicaion.When i select the report from the dropdown it displays correct report but why it still shows the report paramter of the report even if i slelect some other report from drop down.Pls let me know how i can implement this that when user select some other report before clicking on the report button it should diplay blank page.It should not show the parameters of some other report.

Search Routine

Brady Kelly8-May-07 4:55

Brady Kelly

8-May-07 4:55

I have a small search function that searches a telephone database on e.g. surname, suburb, and tel no. The data source is two tables, TelPerson and TelNumber, with one TelPerson record to many TelNumber records. I'm battling a bit with my search SQL, which joins the two tables to allow a search on person details as well as on phone number, but I only want one record returned if the search is on person details only.

For example, Investec Bank have 419 telephone numbers, but if the user searches for 'Investec', I only want to return one record, but if the user also includes a telephone number search criterion, I want to show all the records for Investec where the number matches.

Re: Search Routine

andyharman8-May-07 6:13

andyharman

8-May-07 6:13

Its a bit ugly, but I think the following should do the trick:

select P.Name, T.PhoneNumber
from TelPerson as P
inner join TelNumber as N
on N.PersonId = P.PersonId
where (@SearchName = '' or P.Name LIKE '%' + @SearchName + '%')
and (N.PhoneNumber = @SearchPhone or (
   @SearchPhone = '' and 
   N.PhoneNumber in (
      select min(PhoneNumber) from TelNumber where PersonId = P.PersonId)
   ))
order by P.Name, P.PersonId, T.PhoneNumber

This assumes that a blank-string equals no criteria. If possible then I would recommend using a stored procedure to make the code more logical.

Regards
Andy

Re: Search Routine

Brady Kelly9-May-07 0:44

Brady Kelly

9-May-07 0:44

Thanks Andy, a close variant seems to work just fine.

Re: Search Routine

Michael Potter8-May-07 8:22

Michael Potter

8-May-07 8:22

Sometimes a UNION can run pretty quick. A simple GROUP BY will eliminate duplicates.

SELECT 
    TelPersonId
FROM
    TelPerson
WHERE
    @criteria1 IS NOT NULL AND
    Investec LIKE '%' + @criteria1 + '%'
    
UNION
    
SELECT
    TelPersonId
FROM
    TelPerson
INNER JOIN 
    TelNumber 
    ON (TelPerson.TelPersonId = TelNumber.TelPersonId)
WHERE
    @criteria2 IS NOT NULL AND
    TelNumberText LIKE '%' + @criteria2 + '%'
    
GROUP BY TelPersonId

need help for sqlserver2005 reporting service

Doshi Divyesh8-May-07 3:49

Doshi Divyesh

8-May-07 3:49

i am working on one application where i used sqlserver2005 reporting service.
i used oracle 10g as my datasource for the report.
i deployed report on server successfully.

but what my problem is , on server , where i deployed my report, oracle is not there. so it gives me error when i run report on server.

i want to set connectionstring for the report at runtime so that i can give reference to another server and deploy report on current server where oracle is not there.

i have need to set connectionsting at runtime bcz of when i generate report through report wizard in business intellegence. it takes service name as servername.

now what exactly i want to do is:

i want to deploy report on server having connectionstring Cool | :cool:

to another server.
e.g. On server 'A' , i want to deploy report but connectionstring for the datasource includes server 'B'.

i want to include both servername and servicename in the connectionstring

software developer

Oracle buffer.. not sure

Muammar©

8-May-07 1:35

Sorry but im not sure if it's called buffer, but im having a problem pasting all my create table statements in oracle sql*plus..
Not sure how to enlarge that "buffer"

Many thanks Rose | [Rose]