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 |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2007-03-22 : 07:08:30
|
| Hi,I have two server with two IP address, In one server I Installed SQL and in another server I installed IIS means all my ASP files are in this server.Now in wich server I want create ODBC. and how to connect SQL from sql installed server to IIS installed server.With regardsShaji |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-22 : 07:13:42
|
| Why ODBC? Why not OLE DB?To build proper connection string to connect to SQL Server, check this:[url]http://www.connectionstrings.com/?carrier=sqlserver2005[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2007-03-22 : 07:21:30
|
But, I need the connection with ODBC only. And My server is SQL2000.shajiquote:
Originally posted by harsh_athalye
Why ODBC? Why not OLE DB?To build proper connection string to connect to SQL Server, check this:[url]http://www.connectionstrings.com/?carrier=sqlserver2005[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
|
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-22 : 08:13:24
|
| Then why are you posting question in 2005 forum? BTW, OLEDB also works with SQL 2000. Any specific reason to use ODBC?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
ODBC With SQL