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 |
|
coolwrld
Starting Member
10 Posts |
 Posted - 2006-03-09 : 10:22:45
|
I am using MS Access as a frontend to SQL Server tables on 2 differnt machines. One machine uses Windows Authentication so DSN connections have been no problem. The other machine is using SQL Authentication and I am having issues with DSN connections to these tables because of the User ID and password required by SQL. I use the SQLConfigDataSource function for creating the DSN but the UID an PWD parameters do not work for the SQL authentication connections. I have found that apparently these parameters are not supported by the API.At this point I have tried to figure out how to do this through a DSNless connection but am new to ADO and have really no idea how to establish the connection let alone how to link the tables through the connection. I am much more comfortable with the DSN approach but at this point I am stuck.For the sake of arguement lets say the following is the environment.Server1 (Windows Authentication) has the following tablesTable1Table2Server2 (SQL Authentication UID=user PWD=password) has the following tablesTable3Table4With this environment how do I establish DSNless connections to both servers and then make Access think that all four tables are linked tables. I want the to be treated as linked so that I can still use the design view as well as view data in the tables in Access without need to use the SQL Enterprise manager for testing purposes.Any help/guidance would be greatly appreciated . Also if this is not the appropriate venue for this question I am sorry . |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2006-03-13 : 19:54:50
|
| You may want to look up "Linked Servers" on Books Online. It is a way to establish the proper security rights between servers. Once this has been set up, one connection can be established to one of the database servers and the database objects (Tables, sprocs, etc.) of the second server are available. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-03-14 : 06:09:40
|
| >>>With this environment how do I establish DSNless connections to both servers and then make Access think that all four tables are linked tables.for DSNLess connection see www.connectionstrings.com |
|
|
|
|
|
|
DSN - DSNLess Connection Help