|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
January 14th, 2006, 07:14 PM
|
|||
|
|||
Database on another computer
hi all,
can anybody tell me ho can i set my database property of my connection string if my database is on the other machine on my network. I am developing with c# and my connecitonstring is like this : @"User=SYSDBA;Password=masterkey;Database="+Application.StartupPath+@"\TICARI.FDB;DataSource="ERMAN";Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=0;Connection timeout=15;Pooling=True;Packet Size=8192;Server Type=0" When i show my string via messagebox it shows database property like this : \\ERMAN\dms\TICARI.FDB but it gives me I/O error for file CreateFile(open) "\dms\TICARI.FDB" error while trying to open file. it means it eats my computer name \\ERMAN How can i solve this problem? Thanks a lot.
|
|
#2
January 15th, 2006, 01:00 AM
|
|||
|
|||
|
Quote:
Database needs to be in format: ServerName:FullPathOnServer Example: If the server was ERMAN and the path (ON ERMAN) was D:\Firebird\Data\TICARI.FDB Then Database should be: Code:
ERMAN:D:\Firebird\Data\TICARI.FDB HTH Clive
|
|
#3
January 15th, 2006, 02:38 AM
|
||||
|
||||
|
Also note that you can configure aliases to avoid the remote path assle.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Database on another computer |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
