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 |
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
 Posted - 2008-04-26 : 00:35:32
|
| HI,I hope you can help me. I've installed xampp so I can tied up SQL and Dreamweaver. I tried reading all sites about connection strings but still unsuccessful. Can any one help me steps? I'm online, I appreciate we can talk there.Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-26 : 02:50:19
|
what problem are you having exactly? is there an error msg you could share?
elsasoft.org |
 |
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-04-26 : 05:12:41
|
| My first problem what connection string should I put in? |
|
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-04-26 : 05:13:16
|
| Is this correct? Driver={SQL Server};BotMXP=http://localhost/test/;Database=Bo2t;Trusted_Connection=Yes; |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-26 : 09:48:15
|
nope, that won't work. BotMXP is not a valid key in any connection string format I know of.there are lots of connection string examples here: http://www.connectionstrings.com/?carrier=sqlserver2005first you need to find out what API/library you are using to connect though. Is it ADO.NET? ODBC? OLEDB? Presumably the documentation for dreamweaver will tell you that.
elsasoft.org |
|
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-04-26 : 11:08:19
|
| I think it's OLEDB. What's next? |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-26 : 11:58:00
|
try this:Provider=SQLNCLI;Server=BotMXP;Database=Bo2t;Trusted_Connection=yes;
elsasoft.org |
|
|
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-04-26 : 12:10:52
|
| Thanks. It works using this one: Provider=SQLOLEDB;Server=BotMXP;Database=Bo2t;Trusted_Connection=yes; |
|
|
|
|
|
|
SQL Connection