Friday, March 23, 2012

OMG, Having so much trouble connecting my SQL database/server to Dreamweaver

I think its my server because I cant get it to link up to an Access data base
either, heres the error I get.
[DBNETLIB]ConnectionOpen (Connect()),]SQL Server does not exist or access
denied.
Im pretty sure that all the fields that I entered are correct though.
What could be the problem?What is your connection string ?
Have you configure the right network protocol in SQL Server Configuration
Manager ?
--
Jean-Pierre Riehl
http://www.blog.djeepy1.net
http://www.bewise.fr
"Qaiphyx" <u40439@.uwe> wrote in message news:7dcaeb7bf1706@.uwe...
>I think its my server because I cant get it to link up to an Access data
>base
> either, heres the error I get.
> [DBNETLIB]ConnectionOpen (Connect()),]SQL Server does not exist or access
> denied.
> Im pretty sure that all the fields that I entered are correct though.
> What could be the problem?
>|||The connection string is right I believe. How do i configure the network
protocol?
Jean-Pierre Riehl wrote:
>What is your connection string ?
>Have you configure the right network protocol in SQL Server Configuration
>Manager ?
>--
>Jean-Pierre Riehl
>http://www.blog.djeepy1.net
>http://www.bewise.fr
>>I think its my server because I cant get it to link up to an Access data
>>base
>[quoted text clipped - 6 lines]
>> What could be the problem?|||To configure your allowable network protocols...
SQL 2000 you are going to use the "Server/Client Network Utilities" located
in your program files...
http://msdn2.microsoft.com/en-us/library/aa213770(SQL.80).aspx
Basically make sure that TCIIP is in the enabled box.
In SQL 2005 you can use your "Surface Area Configuration" Tool
http://msdn2.microsoft.com/en-us/library/ms173748.aspx
thanks,
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.TechIntSolutions.com
www.RealWorldSQL.com
*/
"Qaiphyx" <u40439@.uwe> wrote in message news:7dcd267ca767e@.uwe...
> The connection string is right I believe. How do i configure the network
> protocol?
> Jean-Pierre Riehl wrote:
>>What is your connection string ?
>>Have you configure the right network protocol in SQL Server Configuration
>>Manager ?
>>--
>>Jean-Pierre Riehl
>>http://www.blog.djeepy1.net
>>http://www.bewise.fr
>>I think its my server because I cant get it to link up to an Access data
>>base
>>[quoted text clipped - 6 lines]
>> What could be the problem?
>

No comments:

Post a Comment