Code to connect Access to SQL server

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Code to connect Access to SQL server

Author

Topic

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-06-05 : 10:09:38

I used code below to connect Access to SQL server but no luck.
What is wrong? Where to input server name?
strConnect = "ODBC;Driver={SQL Server};UID=sa;PWD=xxxxxx"

jholovacs
Posting Yak Master

163 Posts

Posted - 2009-06-05 : 14:39:07

you don't have enough info but check out site, it may give you an idea what you're looking for:

http://www.connectionstrings.com/sql-server-2005

SELECT TOP 1
w.[name]
FROM
dbo.women w
INNER JOIN
dbo.inlaws i
ON
i.inlaw_id = w.parent_id
WHERE
i.net_worth > 10000000
AND
i.status IN ('dead', 'dying')
AND
w.husband_id IS NULL
ORDER BY
w.hotness_factor DESC

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources