Database

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

9-May-07 1:57

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

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

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

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

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

need help for sqlserver2005 reporting service

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

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

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]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Oracle buffer.. not sure

andyharman8-May-07 1:52

Re: Oracle buffer.. not sure

8-May-07 1:52

I normally save my script as a SQL file, then use the SQL*Plus "start" command to run it.

Muammar©8-May-07 20:58

Muammar©

8-May-07 20:58

Doh.. How?? D'Oh! | :doh:

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Oracle buffer.. not sure

andyharman9-May-07 0:10

9-May-07 0:10

Try the Oracle SQL*Plus user guide: Running Scripts[^]

Regards
Andy

Substring Problems help

Vimalsoft(Pty) Ltd8-May-07 0:50

8-May-07 0:50

The Following number is called an Attribute code
"120080200000"
These are 6 pairs. i want to chance the 5th pair to '10' and not tember with the other pairs. here is the query but it gives me undesirable results.

update property
set attrib_code = substring(attrib_code,1,8)+ substring(attrib_code,9,2)+ '10'
and substring(Attrib_code,11,2) + '00'
where property_id = 15985

Please Help

Vuyiswa

Colin Angus Mackay8-May-07 1:04

8-May-07 1:04

Vuyiswamb wrote:
here is the query but it gives me undesirable results.

You should describe the undesirable results. That way we can concentrate on what is likely to be wrong rather than have to waste time reading the whole thing to figure it out.

If you are normalising your database (which is generally a good idea), the first normal form should split this out in to separate columns. If you need it all joined up you can always create a calculated column for that purpose. If you need it joined up and indexable then a trigger can be created to ensure that happens.

Vimalsoft(Pty) Ltd8-May-07 1:19

8-May-07 1:19

I understand, mybe you can explain in detail how the substring is working, there are more than 40 000 records, am a junior, i have used this before and it worked, this code i used for something within the organisation. its true am normalasing the table, can you please tell me

how the substring work , i try to google it, but the explanation were not clear, i know there is a starting position and replce position. in this case
xx xx xx xx xx xx i want to change the 5th pair only, but my query temper with the last pair and change the 5th pair please help

Vuyiswa

Colin Angus Mackay8-May-07 2:58

8-May-07 2:58

Vuyiswamb wrote:
mybe you can explain in detail how the substring is working

See the documentation for SUBSTRING[^].

Vuyiswamb wrote:
its true am normalasing the table, can you please tell me

I don't know anything else about your table. All I can see is you appear to be modifying only part of a column value. That suggests to me that the column breaks the first normal form. i.e. you should split out all values into separate columns.

SUBSTRING(Value, 1, 8) + ReplacementValue + SUBSTRING(Value, 11, 2)

Value is the name of the column, ReplacementValue is the value you want to replace the 5th pair with.

Vimalsoft(Pty) Ltd8-May-07 3:37

8-May-07 3:37

Thank you it worked, infact we were talking abot the same thing, i did not understand you, but now i do. tell let me ask you something. have you ever modify a large number of records by mistake? if yes what did you do, and how did you feel after that?

Vuyiswa

Colin Angus Mackay8-May-07 3:48

Having trouble with Ado control in vb6

8-May-07 3:48

Vuyiswamb wrote:
have you ever modify a large number of records by mistake?

Yes.

Vuyiswamb wrote:
if yes what did you do?

I restored the backup.

Vuyiswamb wrote:
how did you feel after that?

Normal. Why?

mas TCP connection?

D2raghu8-May-07 0:13

D2raghu

8-May-07 0:13

what is the maximum number of clients that can connet to a TCP server ( in .net remoting) and what happens if the number of clients reach beyond the max limit?How can we temper the maximum limit?

mysql

WhiteGirl237-May-07 22:50

WhiteGirl23

7-May-07 22:50

hi I want to make an import from access to mysql on Linux but i have a problem with mysql:the default value of
lower_case_table_names is 0 and i must put the default value of
lower_case_table_names to 1 .

Help please.

thanks

Vimalsoft(Pty) Ltd7-May-07 20:57