Remote "oleDbConnection" Problem...... Heeeeeelllppppp !!!!!

Remote "oleDbConnection" Problem...... Heeeeeelllppppp !!!!!

Post by << g n d z k d r >> » Sun, 04 Dec 2005 21:19:52



hi everyone,

i have a project that i'm working on C#.net (and Access). There is a
textBox in the form which will has the connection with the
database(KTP.mdb). And when the form is loaded textBox's text is a
computer's ip number which is working on a LAN(local area network).

i did a connection with the database which is on another computer on
LAN using wizard and the .net produced a connection code like this..


Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking
Mode=1;Data Source=""\\Ade\c\KTP-2005\KTP-Server\KTP.mdb"";Jet
OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet
OLEDB:System database=;Jet OLEDB:SFP=False;persist security
info=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't
Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";

Please look the code above, there is Data
Source=""\\Ade\c\KTP-2005\KTP-Server\KTP.mdb"";

here : Ade is Computer's name on LAN (i did connection using the
wizard)

my Question is :

how can i do the connection using textBox's text instead of computer's
name....

send me the Data Source code which is using the textBox's text to make
connection

i hope i could explain my problem....

please help.....

thanks for now....