Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BlackReefDesigns
Starting Member
27 Posts |
 Posted - 2009-01-08 : 13:50:20
|
| Hello -Some of you may have seen my other threads in here about the issues I am having with my SQL Database at a new Virtual Server I set up.Basically I am narrowing down all the issues, and at this point I am trying to focus on getting the connection string squared away.My current string looks like this:Provider=sqloledb;Data Source=(IP ADDRESS),1433;Initial Catalog=(DATABASE NAME);User Id=(USER);Password=(PASSWORD);I have a program that is set up on my server when I can actually input a string and test it to see if it connects, but I haven't found one yet. Of course my Virtual Server support basically told me I'm on my own with this, and my eCommerce Software guys basically tell me to ask my Virtual Server support for help! FYI, this is a MS SQL Database, and I will be using .ASP to connect.Any help would be greatly appreciated!Thanks |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-01-08 : 14:07:40
|
| Create a new text file and rename it to something else but with a UDL extension. OPen that and connect to your SQL DB on your virtual server. Once the connection succeeds, save it and then open this UDL file in notepad again. You will have the correct connection string there. |
 |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-08 : 14:42:15
|
| So I create file.UDL and upload it to my root directory and then go to that URL? So: www.sitename.com/File.UDL? |
|
|
|
|
|
|
Who knows about Connection Strings?