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 |
|
tombino
Starting Member
26 Posts |
 Posted - 2007-10-09 : 01:46:06
|
| Hi,I am working in a windows server 2003 machine 64 bit with sql 2005. I tryed to export some data (to access) but this is the errror that appear:===================================Could not connect source component.Error 0xc020801c: Source - sys_Type [1]: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. (SQL Server Import and Export Wizard)===================================Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)------------------------------Program Location: at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction) at Microsoft.SqlServer.Dts.DtsWizard.Execute.SetSourceConnection(Exception& ex, TransformInfo ti)I cant understand what I am doing wrong. I tryed the same thing with a client machine (32 bit with XP) and work fine.I appreciate your help.thanks tom |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-09 : 02:38:02
|
Can you post your connectionstring?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-10-09 : 03:04:11
|
| Hi Peso,Sorry for my ignorance, but where can I found the connectionstring? But the way, I connect to the database with Sql Server menagement studio, using 'sa' user name.I dont have any problem to access the database, but just I cant export anything.thanks tom |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-09 : 22:07:33
|
| How did you export data? |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-10-09 : 23:45:00
|
| with the SQL server import and export wizard |
|
|
|
|
|
|
connection problems