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 |
|
my_xr6_turbo
Starting Member
4 Posts |
 Posted - 2012-08-10 : 22:32:57
|
| Hey guys, I'm super new to SQL. I know what I need to do but I just don't know the commands. Can someone help me with the command to connet to an DSN Source. Here is the query I have at the moment but I know it's wrong.Insert into Absences ([StdID], [Date], [Approved], [Absences])Select [stdid], [date], [approved], [absences] FROM Absences IN '' [ODBC;DSN=OldData;]; |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
my_xr6_turbo
Starting Member
4 Posts |
Posted - 2012-08-15 : 02:19:28
|
| Great I now have it working, but I'm getting a funny error. Here is the query:select * from OPENQUERY(NEXUS,'select ABS from ABS')Error:Msg 7347, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' for linked server 'NEXUS' returned data that does not match expected data length for column '[MSDASQL].ABS'. The (maximum) expected data length is 119, while the returned data length is 120. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-15 : 10:22:23
|
| are you trying to insert this somewhere?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
my_xr6_turbo
Starting Member
4 Posts |
Posted - 2012-08-15 : 17:20:09
|
| I will be inserting it into a table but at the moment I'm just trying to get the query to work. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Connecting to a DSN Source