db_name = "DB_103922"
db_username = "virgilslist"
ddb_server = "whsql01.mesa1.secureserver.net"
db_userpassword = ""
fieldname = "branch_desc"
tablename = "branch"

connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" &
db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
 
This is per their example (took out the password)
Should work, but doesn’t....

It is set up for windows hosting

I'll figure it out tomorrow...
Just had enough for today <grin>


Virgil Bierschwale
http://www.virgilslist.com
http://www.tccutlery.com
http://www.bierschwale.com
http://www.bierschwalesolutions.com

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Kevin Cully
Sent: Monday, December 18, 2006 7:01 PM
To: profox@leafe.com
Subject: Re: [NF] godaddy.com and sql server

Hey Virgil,

I've never connected to a SQL Server on GoDaddy but I'm currently doing some
work against MySQL databases.  GoDaddy is very specific about the host name
that it is connecting to.  For the stuff that I'm doing I have to specify
"mysql255.secureserver.net" as the host name.  The number part (255) will
change based on how they set you up.  I imagine that there is a similar
naming convention for SQL Server.

You may want to confirm that the hosting plan that you have is for Windows
and it isn't on Linux, as well.

Kevin Cully
CULLY Technologies, LLC

Sponsor of Fox Forward 2006!
http://foxforward.net


Virgil Bierschwale wrote:
> I get this message..
> Makes me think it’s a password thing, but I verified the passwords...
> 
> Wish I had VFP, Foxweb or west wind and a server or two...
> Wouldn’t be messing around with a server that I can't vnc into to 
> check it out <grin>
> 
> Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
> 
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist 
> or access denied.
> 
> /vjb.asp, line 28
> 
> 
> Virgil Bierschwale
> http://www.virgilslist.com
> http://www.tccutlery.com
> http://www.bierschwale.com
> http://www.bierschwalesolutions.com
> 
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Whil Hentzen (Pro*)
> Sent: Monday, December 18, 2006 4:15 PM
> To: profox@leafe.com
> Subject: Re: [NF] godaddy.com and sql server
> 
> Virgil Bierschwale wrote:
> 
>>I've been having problems establishing a connection to my sql server 
>>database on godaddy.com using their supplied templates.
>>
>>In googling, I'm finding that apparently a lot of people are having 
>>that problem.
>>
>>Is anybody using sql server on godaddy with their web sites ?
>>
>>Not sure what the problem is just yet and yes, I have done one or two 
>>sites using ASP and SQL server, but allways with VFP (foxweb or
>>homebrew) so I don't yet have a clue what the problem is <grin>
> 
> 
> OK.....
> 
> 'what happens'?
> 
> 1. I connect and nothing happens. My browser just hangs.
> 2. I connect and I get an error message that says:
>    <fill in>
> 3. I'm connecting from VFP, and... <fill in> 4. <fill in>
> 
> Whil
> 
> 
[excessive quoting removed by server]

_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to