OrthoDocSoft
Programmer
Folks,
My app had 2 MS Access DB's that I used to move around to whatever folder I wanted, while keeping track of the file path, so my app could find it. Easy breasy.
As you know, I have upgraded to MS SQL Server, and I understand that MS SQL SERVER needs to run as a service in the background "supporting" my DB's on the same server (more or less).
But if MS SQL Server is running on a server, and I move my DB's to that server, without putting the DB's in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA, how do I make MS SQL Server "see" and deal with my newly added DB's?
In other words, how do I "tell" SQL Server about the new DB's that just got put on the server with it, so it can support it?
The new MS SQL Server connect string does NOT appear to need a precise file path, but rather; only wants to know where the Data Source (ie, MS SQL Server) is. For my home computer, this was the "name" of my computer (something like "JKKUSL73")
In fact, here is the new connect string (See? no file path
Thanks,
Ortho
"you cain't fix 'stupid'...
My app had 2 MS Access DB's that I used to move around to whatever folder I wanted, while keeping track of the file path, so my app could find it. Easy breasy.
As you know, I have upgraded to MS SQL Server, and I understand that MS SQL SERVER needs to run as a service in the background "supporting" my DB's on the same server (more or less).
But if MS SQL Server is running on a server, and I move my DB's to that server, without putting the DB's in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA, how do I make MS SQL Server "see" and deal with my newly added DB's?
In other words, how do I "tell" SQL Server about the new DB's that just got put on the server with it, so it can support it?
The new MS SQL Server connect string does NOT appear to need a precise file path, but rather; only wants to know where the Data Source (ie, MS SQL Server) is. For my home computer, this was the "name" of my computer (something like "JKKUSL73")
In fact, here is the new connect string (See? no file path

Code:
strConnectString = "Provider=SQLOLEDB.1;" _
& "Integrated Security=SSPI;" _
& "Persist Security Info=False;Initial Catalog=frozens;" _
& "Data Source=JKKUSL73"
Thanks,
Ortho
![[lookaround] [lookaround] [lookaround]](/data/assets/smilies/lookaround.gif)