|
I Want design a database in sql server that used this database with Remote Machine from of LAN (Application installed in Remote Machine). please send answer, in way step by step.
 Thanks. Have A Good Time.
modified on Wednesday, March 5, 2008 2:21 AM
|
|
|
|
|
Take your time and Explain your Problem and what you want to achieve
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Thanks for your answer. I design my database in sqlserver2005 and application in delphi and create a udl file then i try to connect to remote machine that sqlserver2005 installed . but i could not connect.
|
|
|
|
|
hi M.Nouri
What is the Error when you try to Connect?
i was gonna Say post your code so i see if there is something wrong, am not into Delphi and i don't know how the syntax looks like, am into .NET C# or Vb then it would be easy for me to help you. Why do you still use Delphi if i may ask, what is it there is there and that is not in .NET?
i have done some small googling and i found this hope it will help.
http://www.delphi3000.com/articles/article_1725.asp?SK=[^]
Hope it Helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hi Vuyiswa
I run sql server 2005 management studio and then select network server, i see my remote machine name , then i select remote machine name and select windows authenitication tnen click connect but sql server give login fail the user ... .
|
|
|
|
|
Do you have Permissions to Access that server?
Check you login if its Correct.
Do you have SQl installed in your system?
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
I installed sql server2005 on two computer and in start->run->ip address(or name) i could connect to another computer ; but in sql server configuration and service when i want to change local server to network server ;sql server message could not logon to ip address.
thanks very much.
|
|
|
|
|
|
M.Nouri wrote: please send answer, in way step by step.
No one is going to to your (home)work for you.
Read the forum rules. Ask a specific question, and maybe someone will help you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks for your guidance.  
|
|
|
|
|
The pleasure was all mine
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Design and create your database. then use the connection string having the datasource name equal to your server name.
Do good and have good.
|
|
|
|
|
|
Thanks Very Much . Good Luck
|
|
|
|
|
Hi,
Need to insert only specific columns from a .csv file while importing to SQL Server2005 using bulk import.
My problem is i have 4 columns a,b,c,d in my .csv file,but i need only two columns a and b only to be imported using bulk import.
I was working after seeing this link http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
Any help is welcome
Thanking you
|
|
|
|
|
new2pgrmg wrote: i need only two columns a and b only to be imported using bulk import
You can achieve this using a Format File. See this article[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
Thanks for the reply.
I have tried it from a similar link from msdn.But i am facing a problem.
I followed this link to the tee.
But i am getting an error;I worked this way
First i created a database by the name "AdventureWorks".
Then i creted a table like ;
USE AdventureWorks;
GO
CREATE TABLE myTestSkipCol
(
Col1 smallint,
Col2 nvarchar(50) NULL,
Col3 nvarchar(50) not NULL
);
GO
I created a .dat file by the name "myTestSkipCol2.dat"
1,DataForColumn3
1,DataForColumn3
1,DataForColumn3
Then i copied the XML file by the name "myTestSkipCol2.Xml" in the C:Drive
<bcpformat xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<record>
<field id="1" xsi:type="CharTerm" terminator="," max_length="7">
<field id="2" xsi:type="CharTerm" terminator="\r\n" max_length="100" collation="SQL_Latin1_General_CP1_CI_AS">
<row>
<column source="1" name="Col1" xsi:type="SQLSMALLINT"> <column source="2" name="Col3" xsi:type="SQLNVARCHAR">
Then i executed the bulk query like;
USE AdventureWorks;
GO
INSERT INTO myTestSkipCol
(Col1,Col3)
SELECT Col1,Col3
FROM OPENROWSET(BULK 'C:\myTestSkipCol2.Dat',
FORMATFILE='C:\myTestSkipCol2.Xml'
) as t1 ;
GO
Here is the problem;I am getting an error "Msg 4820, Level 16, State 1, Line 1
Could not bulk insert. Unknown version of format file 'C:\nm.fmt'.
"
I tried different ways like giving the extension as ".XML" and ".ftm".I tried different permutations and combinations.
Need your help
Many Thanks
|
|
|
|
|
How can you get the error:
new2pgrmg wrote: Could not bulk insert. Unknown version of format file 'C:\nm.fmt'.
if your statement is:
new2pgrmg wrote: INSERT INTO myTestSkipCol
(Col1,Col3)
SELECT Col1,Col3
FROM OPENROWSET(BULK 'C:\myTestSkipCol2.Dat',
FORMATFILE='C:\myTestSkipCol2.Xml'
) as t1 ;
Your query references a format file called myTestSkipCol2.Xml. This isn't consistent with the error message you reported.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Sorry for the mistake but the basic idea is correct.As i told you i was trying different methods and when i found that the posted question had a slight mistake i tried to edit but it was not loading.
The error will be Could not bulk insert. Unknown version of format file 'C:\myTestSkipCol2.Xml'.
Sorry for the mistake
Looking for an answer.
Also can you tell me how i can find the BCP version?
Many Thanks
|
|
|
|
|
Hi all, thanks for looking
I have this 2 queries, they return the same result
I wonder, which one is faster and why?
SELECT dbo.Products.ProductName
FROM dbo.Categories INNER JOIN dbo.Products ON dbo.Categories.CategoryID = dbo.Products.CategoryID
WHERE (dbo.Categories.CategoryName = N'Beverages')
SELECT dbo.Products.ProductName
FROM dbo.Products WHERE dbo.Products.CategoryID IN (SELECT dbo.Categories.CategoryID FROM dbo.Categories WHERE dbo.Categories.CategoryName = N'Beverages')
Thanks
Alexei Rodriguez
|
|
|
|
|
As per my perception is : Inner query is always slower than the join query.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
in addition to Parwej Ahamad
You can also check Query execution plan, which gives better picture
Regards
KP
|
|
|
|
|
Joins are always faster and efficient, so use joins in place of in conditions.
Do good and have good.
|
|
|
|
|
Hi all, thanks for looking
I have this 2 queries, they return the same result
I wonder, which one is faster and why?
SELECT dbo.Products.ProductID, dbo.Products.ProductName, dbo.Categories.CategoryName
FROM dbo.Categories INNER JOIN dbo.Products ON dbo.Categories.CategoryID = dbo.Products.CategoryID
SELECT dbo.Products.ProductID, dbo.Products.ProductName, dbo.Categories.CategoryName
FROM dbo.Categories, dbo.Products
WHERE dbo.Categories.CategoryID = dbo.Products.CategoryID
Thanks
Alexei Rodriguez
modified on Tuesday, March 4, 2008 11:01 PM
|
|
|
|
|
I beleive there is almost no difference in processing speed.
I ALWAYS use the join method because it is more readable and therefore easier to support.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
