Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
February 09, 2012, 12:35:16 PM

Pages: [1]   Go Down
  Print  
Author Topic: Example database connection string  (Read 3936 times)
msteudel
Space Explorer
***
Offline Offline

Posts: 7


WWW
« on: June 19, 2009, 09:23:56 AM »

I was wondering if someone could post a example connection string to connect to my MS SQL server.

TY
Logged

---------------------------------
. : Our Work : .
http://www.mindfulinteractive.com

. : Our Play : .
http://www.steudel.org/blog
wektech
Master Jedi
*****
Offline Offline

Posts: 1031



WWW
« Reply #1 on: June 19, 2009, 09:42:01 AM »


nevermind, i thought you said MySQL
« Last Edit: June 19, 2009, 09:44:52 AM by wektech » Logged

msteudel
Space Explorer
***
Offline Offline

Posts: 7


WWW
« Reply #2 on: June 19, 2009, 04:22:55 PM »

<%
'on error resume next
' Create ADO Connection Object
Set ac = Server.CreateObject("ADODB.Connection")
' Build connection string and then Open connection
strSQL7 = "Provider=SQLOLEDB;Persist Security Info=False;" &_
               "User ID=USERNAME;Password=PASSWORD;Initial Catalog=DBNAME;" &_
               "Data Source=SERVERNAME"
ac.Open strSQL7 
%>

So I found this which seems to work, except I can't figure out what the name of my server should be. With mysql usually your default is localhost, does MS SQL have a similiar default? I tried typing int he name of the server that's listed in myLittleAdmin, butthat didn't work.

Logged

---------------------------------
. : Our Work : .
http://www.mindfulinteractive.com

. : Our Play : .
http://www.steudel.org/blog
darkwolf
Guest
« Reply #3 on: June 19, 2009, 06:13:17 PM »

Lunarpages maintains multiple mssql database servers, and the exact server should have been listed in your welcome email.

In the event its not, or you are unable to locate it, I would recommend contacting support at support.lunarpages.com (via web) or support@lunarpages.com (if by email) and we can review which server you are on and the exact server you should use for mssql.
Logged
msteudel
Space Explorer
***
Offline Offline

Posts: 7


WWW
« Reply #4 on: June 19, 2009, 10:20:21 PM »

Thanks I did eventually contact and they said to the use a particular IP address, which was not in my welcome email ... kinda wierd. Anyway I'm all connected now!
Logged

---------------------------------
. : Our Work : .
http://www.mindfulinteractive.com

. : Our Play : .
http://www.steudel.org/blog
msteudel
Space Explorer
***
Offline Offline

Posts: 7


WWW
« Reply #5 on: June 20, 2009, 09:11:00 AM »

Support showed me where the link in the kb was to this information:

https://support.lunarpages.com/knowledge_bases/article/384

Logged

---------------------------------
. : Our Work : .
http://www.mindfulinteractive.com

. : Our Play : .
http://www.steudel.org/blog
MichaelT
Support
Jabba the Hutt
*****
Offline Offline

Posts: 523



« Reply #6 on: June 21, 2009, 02:18:43 AM »

Support showed me where the link in the kb was to this information:

https://support.lunarpages.com/knowledge_bases/article/384



If your account is fairly new it is likely that the you were caught in transition and the welcome email did not include the newest SQL server connection information which is urmom.
Logged

--

Support and Assistance:
Contacting Us
Hosting Plans
Affiliate Program
Wiki and Tutorials
Pages: [1]   Go Up
  Print  
 
Jump to: