Database

Re: sql server user authentication

4-Mar-07 21:42

Pls set per seat

for any errors pls give full error message displayed. with would help in solving the same.

Regards
KP

rrrriiizz4-Mar-07 21:55

rrrriiizz

4-Mar-07 21:55

Please tell me the full details how to set per page connections?

How to configure SQL Server 2000 to allow remote connections ?

hdv2122-Mar-07 13:02

hdv212

2-Mar-07 13:02

hi i have sql server 2000 personal in server, and i want connect to it from client by vc#2005, but the following error shown 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

how to solve my problem ??
thanks

Re: remote server insert update delete

Krish - KP2-Mar-07 19:55

Re: remote server insert update delete

2-Mar-07 19:55

Your query is not clear.
is that you are trying to access from an application
if so, which one.
or from Query analyzer directly use the sql statements.
of from enterprise manager is a graphical interface.

Regards
KP

alexrad2-Mar-07 22:08

alexrad

2-Mar-07 22:08

from Query analyzer.
task description is:
I have central sql2000(general office) db and several(5) sql2000 db as 5 point of sales.
GeneralOffice need fresh data about realizaton in stores as they need fresh data about new articles and price modification etc.
Connecton is by dial-up(modem connection).
I have one solution: create an xml file wich is transfer over network, but it is slowly and complicated for employees in stores.
My second idea is creating linked server but i have no experience in subject.

Any idea about this task is very helpful.

Deadline is monday!

Re: remote server insert update delete

Krish - KP4-Mar-07 22:19

I need help Data Access Application Block and MS Access

4-Mar-07 22:19

one option is use DTS, get db to local instance. which would be faster.
(if is a offline transaction)

for accessing a different instance need to link using sp_addserver / sp_addlinkedserver

Regards
KP

Sendilkumar.M2-Mar-07 2:44

Sendilkumar.M

2-Mar-07 2:44

I want to use Data Access Application Block for accessing my MS Access database.
Is it possible with out making changes in Enterprise Library 2.0?

M.Sendilkumar

Re: I need help Data Access Application Block and MS Access

Frank Kerrigan2-Mar-07 5:49

Frank Kerrigan

2-Mar-07 5:49

Yes that is what it is designed for.

Use the configurator to attach to the backend Access db then try and run some code againist it.

You might be better of with SQL express 2005 if your target server can handle it.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http:\\www.frankkerrigan.com

Re: I need help Data Access Application Block and MS Access

Sendilkumar.M5-Mar-07 16:53

Sendilkumar.M

5-Mar-07 16:53

Can you tell me what exactly I need to do?

M.Sendilkumar

Adding from a table to other

ArielR2-Mar-07 2:25

ArielR

2-Mar-07 2:25

Does exist a command (like insert) to copy all records from a table to other with a condition? Let's assume than both have axactly record configuration... thanks

Re: Adding from a table to other

Colin Angus Mackay2-Mar-07 2:39

Colin Angus Mackay

2-Mar-07 2:39

INSERT INTO DestinationTable<br />
SELECT Columns<br />
FROM SourceTable<br />
WHERE condition = whatever

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Re: Adding from a table to other

Frank Kerrigan2-Mar-07 5:49

Frank Kerrigan

2-Mar-07 5:49

select * from tableA
insert tableB

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http:\\www.frankkerrigan.com

Joining tables from different databases

Alex Feature2-Mar-07 0:50

Alex Feature

2-Mar-07 0:50

Hey guys.

I was wondering if it is possible to join two tables from different databases together.

Here is what I want to do:

TableAdapter1 would get data from file AccessDB1, from Table1.
TableAdapter2 would get data from file AccessDB2, from Table2.

Once this is done, I want to join/merge/connect the two tables together in a new DataTable in memory and be able to query this new table.

An example of what I want to do is this:

I have two Access files. The first contains Table1 that has a date column and a value column. The second Access file contains Table2 that has a date column and an exchange rate column.
What I want to do is to produce a new table in memory (i.e. Datatable) that will contain a date column, a value column, and exchange rate column, AND a new column ExchangedValue that will contain the results of value column * exchange rate column.

Can this be done? The concern here is the fact that the two tables where taken from different database files.

Thanks and regards..

The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!

Re: Joining tables from different databases

Frank Kerrigan2-Mar-07 5:53

Frank Kerrigan

2-Mar-07 5:53

you can do this in SQL Server, even on differet db servers if you setup a linked server.

select * from
salesdb.dbo.customers inner join customer.dbo.customer
on salesdb.dbo.customers.id inner join customer.dbo.customers.id

Hope this helps

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http:\\www.frankkerrigan.com

sql database

taherjaorawala1-Mar-07 23:33

taherjaorawala

1-Mar-07 23:33

how to create sql database wit userdefined name at run time.

please help

thanx

taher

Colin Angus Mackay1-Mar-07 23:49

Colin Angus Mackay

1-Mar-07 23:49

taherjaorawala wrote:
how to create sql database wit userdefined name at run time

Like anything else - you issue a SQL command, in this case to CREATE DATABASE.

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

taherjaorawala2-Mar-07 0:01

taherjaorawala

2-Mar-07 0:01

I am using vb.net as front end I want to make database at runtime and name the database whatever user wants

plase help

Krish - KP2-Mar-07 0:12

2-Mar-07 0:12

create connection object
create command object
execute sql statement "CREATE DATABASE ...."

Regards
KP

copy sql data base to some other machine

Colin Angus Mackay2-Mar-07 0:20

Colin Angus Mackay

2-Mar-07 0:20

taherjaorawala wrote:
I am using vb.net as front end I want to make database at runtime and name the database whatever user wants

I explained this to you in your cross posted message in the VB.NET forum here[^]

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

chandru701-Mar-07 20:38

1-Mar-07 20:38

I have database present in one m/c sql server and i have taken backup of the database.
I want to restore the backup file into another m/c which has sql server
how to go about

Pls help me..

regards

chandru

chandru701-Mar-07 20:42

1-Mar-07 20:42

i forgot to say i am using sql server 2000

Krish - KP1-Mar-07 22:42

1-Mar-07 22:42

take database offline from the frist machine. copy MDF & LDF files to other machine and attach them (right click on database node select AllTasks->Attach from SQL enterprise manager)

OR

create a new database with same name in another m/c and restore the backup taken from the first m/c

Regards
KP

chandru701-Mar-07 23:12

1-Mar-07 23:12

thank you
i will try the same

chandru

chandru703-Mar-07 20:30

3-Mar-07 20:30

hi
i have taken backup from orginal pc, and created new database in another m/c
but if i try to take backup from the backup file it will not shown in that form. How to go about

please guide me about this.

regards

chandru

Krish - KP4-Mar-07 21:44