Forums

This topic is locked

DSN less connection with Microsoft SQL Server 2000

Posted 26 Jul 2006 21:36:23
1
has voted
26 Jul 2006 21:36:23 afia afia posted:
Hi all
i use windowsXP prof. and use for my site dream weaver2004 i want make data base of my site by Microsoft SQL Server 2000 - Developer Edition,i want make DSN less connection,how can i do that
thank you for your time
best regards

Replies

Replied 03 Aug 2006 15:41:48
03 Aug 2006 15:41:48 Dave Ohlemacher replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi all
i use windowsXP prof. and use for my site dream weaver2004 i want make data base of my site by Microsoft SQL Server 2000 - Developer Edition,i want make DSN less connection,how can i do that
thank you for your time
best regards
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Try this:

Make a new connection in Dreamweaver and use a custom connection string (the one below is for SQL - yours may be different - search Google for 'Connection Strings')

"Provider=SQLOLEDB;Password=pASSword;Persist Security Info=True;User ID=User1;Initial Catalog=dbName;Data Source=ServerName"

Replied 03 Aug 2006 16:51:22
03 Aug 2006 16:51:22 afia afia replied:
there message appear and say:
"invalied authorization specification"
when i install SQL Server 2005 Express Edition i choose use windows authorization,and this is my connection string:
"Provider=SQLOLEDB;Password=;Persist Security Info=True;User ID=;Initial Catalog=master;Data Source=MAH\SQLEXPRESS"
when my windows start no users accounts appear to enter windows from one of them,just me use the pc,so windows start whithout user id or password until appearing desk top.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi all
i use windowsXP prof. and use for my site dream weaver2004 i want make data base of my site by Microsoft SQL Server 2000 - Developer Edition,i want make DSN less connection,how can i do that
thank you for your time
best regards
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Try this:

Make a new connection in Dreamweaver and use a custom connection string (the one below is for SQL - yours may be different - search Google for 'Connection Strings')

"Provider=SQLOLEDB;Password=pASSword;Persist Security Info=True;User ID=User1;Initial Catalog=dbName;Data Source=ServerName"


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 03 Aug 2006 16:51:37
03 Aug 2006 16:51:37 afia afia replied:
there message appear and say:
"invalied authorization specification"
when i install SQL Server 2005 Express Edition i choose use windows authorization,and this is my connection string:
"Provider=SQLOLEDB;Password=;Persist Security Info=True;User ID=;Initial Catalog=master;Data Source=MAH\SQLEXPRESS"
when my windows start no users accounts appear to enter windows from one of them,just me use the pc,so windows start whithout user id or password until appearing desk top.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi all
i use windowsXP prof. and use for my site dream weaver2004 i want make data base of my site by Microsoft SQL Server 2000 - Developer Edition,i want make DSN less connection,how can i do that
thank you for your time
best regards
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Try this:

Make a new connection in Dreamweaver and use a custom connection string (the one below is for SQL - yours may be different - search Google for 'Connection Strings')

"Provider=SQLOLEDB;Password=pASSword;Persist Security Info=True;User ID=User1;Initial Catalog=dbName;Data Source=ServerName"


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Reply to this topic