Connect database file in SQL

Asked By 0 points N/A Posted on -
qa-featured

Is it possible to connect to the database file in SQL for running a query in Oracle Database Express Edition 10g? If so, how can I attain it?

SHARE
Best Answer by Jackson Day
Best Answer
Best Answer
Answered By 0 points N/A #114940

Connect database file in SQL

qa-featured

 

Generate Multiple Unique Articles (Premium Member only)

Therefore here's the actual answer from MSDN: 
Choos[e] "Increase Brand-completely innovative Data Supply" from your Info menu.[And follow the connectedness wizard] 
Very easy, object that I have virtually not any Data menus. If you do not use a Data food selection, perform the subsequent: 
•Click in Tools > > Connect to Repository. 
•Select "Microsoft SQL Server Databases File", take the default Data service company, as well as click OK 
•On the following screen, browse in your Database file, which will become in your VS Solution booklet framework someplace. 
Analyze the bond. It'll end up being good. If you want to increase the chain to the web.config, click the particular Advanced button, and also copy the actual Information Reorigin line (at the end from the dialogue box), and paste this into type A connectedness stringed in the suitable location inside web.config file.You'll need to add the actual "AttachDbFilename" attribute as well as benefit.Illustration: 
The actual raw text from your Advanced panel: 
Information Source=.SQLEXPRESS;Integrated Security=True;Connect Timeout=30;User Instance=True

 

Answered By 0 points N/A #114941

Connect database file in SQL

qa-featured

Hi Jude,

It is only possible to connect your database to Oracle Database Express Edition if you are using such client programs from Oracle such as SQL*Plus or SQL Developer.

I can give you specific instructions on how to connect a database on Oracle Database XE.

You just have to visit this link.

Related Questions