Skip to main content
juresti
juresti
Known Participant
January 12, 2010
Question

Connection String to Local Database Problem

  • January 12, 2010
  • 2 replies
  • 2382 views

I just copied a database on the development server which I am not owner of, but I have rights to the database. I copied it to my local server. Now I need to connect to the local database and I don't know how.

Dim MM_cnnName_STRING
MM_cnnName_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=DBName;Data Source=DevComputerName"

The above is what I used to connect to the development server. How can I figure out the string for my local MS SQL Server

This topic has been closed for replies.

2 replies

B
bregent
Participating Frequently
January 12, 2010

Have you created the local DSN?


juresti
jurestiAuthor
Known Participant
January 12, 2010

I dont know what that is exactly. I can see my database in ms sql server manager on my local machine. I thought I didn't need a dns connection so I didnt go that route. Hmm I am still trying to figure it out.

B
bregent
Participating Frequently
January 12, 2010

>I thought I didn't need a dns connection

You're right, you shouldn't. Is the server running on the default port?

juresti
jurestiAuthor
Known Participant
January 12, 2010

I thought I could change the Source attribute and the userame and password but that is not working.


Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices