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 |
|
chili
Starting Member
5 Posts |
 Posted - 2008-07-22 : 12:48:53
|
| Greetings !I am trying unsuccessfully to link my Acess Tables into SQL 2005 so as to update the new SQL-2005 based database. My access db "dblfcp" sits on the network server "ldsql01" with user id "gamer" and password "gamer2". The server and database are setup on my machine thru the control panel as DSN "LED_ODBC". Can anyone offer help as to the correct TSQL line entries or the entries under "new linked server" under "server objects" that I need to use ? If I missed any info needed, give the instructions using generic names that I can transfer to my real names.Thank you !!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 12:55:37
|
| Did you configure linked server correctly? |
 |
|
|
chili
Starting Member
5 Posts |
Posted - 2008-07-22 : 13:26:26
|
| Yes |
|
|
|
chili
Starting Member
5 Posts |
Posted - 2008-07-22 : 13:38:18
|
| Actually...I was too fast ...I was referring to the DSN configuration. When you ask if I configured link server correctly, if you are talking about under the server-objects icon, new linked server....that's what I'm having trouble with...I must not be putting the correct values in the right place. |
|
|
|
chili
Starting Member
5 Posts |
Posted - 2008-07-22 : 13:42:51
|
| I keep getting a 7399 error. The on-line docs do not explain what the error means. If I use the same values in the tsql line entries, I am getting an access-denied/permissions error. However, on my same machine, I have a DSN set up where upon I link the access tables I'm after into a second local access database. I appear to have permission to use the info. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 13:45:44
|
| according to your error:http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=45775&enterthread=y |
|
|
|
chili
Starting Member
5 Posts |
Posted - 2008-07-22 : 14:49:30
|
| Thanx anyway...I thought someone could tell me what goes where...I've read everyone's problems with the 7399 and your "according to my error" link tells me nothing. With all due respect, I'm not trying to be ungratefull but.... I'm not having trouble with queries...I can't get that far. I'm trying to link a table so as to apply a query to it. I'll try a different venue. Ciao. |
|
|
|
|
|
|
linking access (again)