Connect database file in SQL

Asked By jude harris 0 points N/A Posted on - 11/30/2011

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?

• Status: Open
• Question Views: 1286
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Jackson Day

Go To Solution

Best Answer

Best Answer

Answered By Jackson Day 0 points N/A #114940

Connect database file in SQL

 

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

 

About Jackson Day

Questions
3

Answers
33

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 12/03/2011
• Question Category: MySQL Server

Answered By Lang Ruark 0 points N/A #114941

Connect database file in SQL

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.

About Lang Ruark

Questions
0

Answers
77

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 05/29/2013
• Question Category: MySQL Server