How i can access my external database with Visual Basic 2010

Question

I have a external database:

Database name :db378080234

Host name :db378080234.db.1and1.com

User name :dbo378080234

Password: password

I treat to connect  using Data -> add New Data Base  -> Data Set ->  New Conecction --> (Microsoft SQL SERVER DATABASE FILE) -> Continue -- datbase name = db378080234 --> Use SQL Serve Aut. Username = dbo378080234    Password = password Enter  

Login Failed for user dbo3780802343 

I dont find any answer how i can use my external database...... 

Thanks for you healp

WMuller

 

 

Answer 1

Add new data soure  > data base - > data set - > new connection

Data source = Microsoft SQL Server (SqlClient)
Server Name = Your server name \ IP (must be IP if it is on a web server)

Use SQL Server Authentication (Set user name and password)
Browse or attach your data base.

---

Please mark those posts as answer which answers your question. Faraz

Answer 2

take a look at this standard page for connection strings 

http://www.connectionstrings.com/

Be aware on that page that asking a question about your external database is the same as telling in a garage that you have a problem with the motor of a car at phone to a garage if you don't tell the brand and type.

 

---

Success
Cor

Answer 3

Hi Walter,

Any update there?

What type of your external database is? Could you please show us the detailed error message you received?

Best Regards,

---

Kee Poppy [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.