Multiple Linking database

[asterix]

Machanla mata Multple linking database gena dena ganna ona,

Meke advantages saha database kihipayak link karana widiha.

Danna kenek kiyala dennako

 

[x-pert]

Advantages wenne machang databases godak use karanna puluwan wena eka eka application ekakin.

As an example: Api ganimu University ekak.

So eeke student records (Admin DB), Financial details (Accounts DB), students results (Students DB), Class time tables (Classes DB) onna ohoma thibunoth - 1 application ekak hadanna puluwan neda okkoma details access karanna...

(Like an ERP system.)

multiple connections hadaaganna puluwani machang web.config file eka edit karala web app ekak nam.

Ube required knowledge level 1 kiyuwoth wadi wisthara kiyanna puluwan wei kiyala hithanawa (A/L?, Undergraduate?, Post Graduate?)

 

[asterix]

Re: Multiple linking Database

Macho mama NCS(IADCS) karala denata IT Company ekaka weda karanne.

mata ona VB.net walin databses kihipaya link karanne kiyala denaganna ?

 

[x-pert]

Macho mama NCS(IADCS) karala denata IT Company ekaka weda karanne.

mata ona VB.net walin databses kihipaya link karanne kiyala denaganna ?

DBMS eka mokakda machang?

Oracle or MsSQL Svr?

 

[x-pert]

Machang connection Strings walin barida wade karanna?

like:

connStr1 = "PROVIDER=Microsoft.Jet.Oledb.4.0;Data Source = C:\DatabaseA.mdb"
Dim conn1 As New OleDbConnection(connStr1)

connStr2 = "PROVIDER=Microsoft.Jet.Oledb.4.0;Data Source = C:\DatabaseB.mdb"
Dim conn2 As New OleDbConnection(connStr2)

// SQL commands waladi hariyata DBs use kalaanam meaka hari yayi kiyala hithanawa pothe hatiyata machang... karala kiyapan