• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

OLE DB Connection - SQL Server

OLE DB Connection - SQL Server
0
JPTenore
Asked:
JPTenore
  • 3
  • 2
  • 2
1 Solution
 
DhaestCommented:
You can find more information about the connectionstring for sql-server at
http://connectionstrings.com/?carrier=sqlserver2005
Using connection as new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;")
     connection.Open()
     ' Use the connection
 End Using

Open in new window

0
 
JPTenoreAuthor Commented:
Can you give me an example of
Data Source=myServerAddress;Initial Catalog=myDataBase    ....   part
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Can you give me an example of
please look in the link provided. it's all there.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
DhaestCommented:

Some explanations:
myServerAddress = this is the name of your server (or ip-address) (example: Company001)
Initial Catalog = this is the name of your database (example:  OrderDb)
myUsername & myPassword: the name and password of the database user that you use to login to your database.

Using connection as new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;")
     connection.Open()
     ' Use the connection
 End Using

If you are using integrated security (your username for sql server is the same as windows, you just need this string:
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
resp... you have to know the dynamic part, ie servername, database etc...
0
 
JPTenoreAuthor Commented:
NO!  Sorry didn't mean to do this
0
 
JPTenoreAuthor Commented:
For some reason it tought I wanted to Close this Question.??????
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now