Jump to content
Sign in to follow this  
slimer

C#: koble til database på nettverket

Recommended Posts

Hei. Postet denne på et annet forum uten hell. Dermed limer jeg bare denne inn her på engelsk. Håper det er greit.

 

Hello.

 

I have read many posts and documentation on the subject but have not been able to find the answer.So I am posting here in hope that someone could give me good answer.

 

We are developing an ording system in my company and with weborderingsystem and an backoffice system. We use windows2k3 where sqlserver 2005 is installed and running with our database. Our webapplication is working with this database and is connected to it. This works fine. I am developing backofficepart whick is an C# application and point of this app is that user can check out sent orders, look up orders and customers.

 

i use C# express to develop this, and use database explorer to try to connect to my the database.

 

My machine is running WinXp pro and server is win2k3 with SQL Server 2005 on it.

 

I get this error:

 

"The file \\810....... is on a network path that is not supported for databasefiles....

 

the path is this:

 

\\810-sql2k5\allkopiprivat.test\AllkopiPrivatTest.mdf

 

 

 

Can anyone give me an answer to tell me if this is possible at all or give me an suggestion on how to go about hsi problem. I need my application to connect to another machine on the network that is running SQL server.

 

 

 

PLEASE help.

Share this post


Link to post

Tror jeg har svart tilsvarende på en annen tråd. Tror ikke .Net(?) støtter database filer som ligger på en nettverkssti. Du må aksessere databasen via sql serveren og ikke database filen på sql serveren.

Share this post


Link to post
Jeg er skremt over tilnærmingen deres. Ta et par min og les om sql server.. du skal da ikke aksessere databasefilen!!

7088601[/snapback]

 

Tror du må lese litt selv :-P

 

Med SQL Server 2005 Express kan man akksesere databasefilen nesten som man gjør med OLEDB og Access.

Share this post


Link to post
En ting er hva som er mulig, en annen ting er hva man bør gjøre. Jeg sa aldri at det var umulig, sa jeg vel?

7089307[/snapback]

 

jo :tease:

 

Isåfall bør du komme med en grunn til at du mener man ikke skal gjøre dette...

Edited by jorn79

Share this post


Link to post
for det første å aksessere en databasefil på en fileshare? Det høres ikke galt ut for deg?

7089391[/snapback]

 

Det er ikke mulig å aksessere den på en fileshare. Får exception da. Men ellers ser jeg ingen problemer.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...