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 |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-03-06 : 07:19:04
|
| Salute..I appreciate ur help in advance..CAN I SELECT from a LINKED SERVER (connected to a FoxPro database) in a TRANSACTION..?cuz it is giving me an error telling me that the MSDASQL does not support distributed transactions...Thanks------------------If I am to do it,I will, and NOW .. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-06 : 07:24:35
|
| Is MSDTC (Distributed Transaction Coordinator) running? You can check it using the Service Manager in the Start:Programs:Microsoft SQL Server menu (it might also be running in the task bar, next to the clock). Did you use BEGIN DISTRIBUTED TRANSACTION instead of BEGIN TRANSACTION?You may not be able to get this work at all because of the support (or lack thereof) as far as FoxPro and ODBC are concerned. If you're just SELECTing from the FoxPro table, why not take the results and put it into a SQL table (temp table would be good) and then work on that table within the transaction? |
 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-06 : 08:00:34
|
| well THANKS ALOT..this is what i had in mind..BUT..I need to WRITE to the linked server afterwards..I need to do it in a TRANSACTION...How can I do that??..does FoxPro and ODBC supports DISTRBUTED TRANSACTION?Thanks Again Mate..------------------If I am to do it,I will, and NOW .. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-06 : 19:07:10
|
quote:
CAN I SELECT from a LINKED SERVER
andquote:
BUT..I need to WRITE to the linked server
Are you sure you know what you want to do ?Damian |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-07 : 02:33:07
|
| YES I KNOW!...It is just that I mentioned the FIRST part of my problem in my first post..and my guess was correct..that my transaction wont go through since a FOXPRO side will NOT participate in a distributed transaction. I can select into a table in SQL..but I still need to write to FOXPRO again !.I need it in a TRANSACTION..It is important..At this stage I have a G/L and FINANCE system on SQL and PERSONNEL on FOXPRO..i need to reflect transactions on both of them!Anyways..ROBVOLK...Thanks ALOT..(ALWAYS) ..Merkin....U could have asked in a better way ,mate..or did I get u the wrong way?Salute to ALL..------------------If I am to do it,I will, and NOW .. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-07 : 08:01:56
|
| It's ALWAYS better to include AS MUCH information in your original request as you can provide. Nothing is more frustrating (I'm sure you'd agree) than to invest time and effort in a solution for someone, only to be told later that, "Well, I can't change that setting because I don't have rights..." etc. I have to admit I was also a little peeved by your 1st reply, maybe not as much as Damian was.My next question is: Is it at all possible to move the FoxPro data directly over to SQL Server? I know that FoxPro can use ODBC to connect to external data. If you don't have access to the source code, can the application be configured to use another data source?Another question is, have you TRIED putting the data back into FoxPro outside of the transaction? Do you know that this operation works at all? How does this entire process behave WITHOUT using transactions? Even if you require transactions, take them out and test it. See what happens. If the process still doesn't work, then the transaction isn't the only problem. Don't get hung up on a requirement you can't meet right away, it might prevent you from exploring other methods. You can always put the transactions back in later and test to see if they work. |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-07 : 09:53:18
|
| ok..I think that U r right robvolk..I should have explained the whole case the first time..well I think that I owe Merkin an apology!.But i was a little bit frustrated from my problem!well..Rob..It works fine outside the transaction..just fine..but it seems that it can not participate in a transaction..such the error indicates!..I think I will just have to do it outside a transaction!!..Again guys..chill..i am sorry!------------------If I am to do it,I will, and NOW .. |
|
|
|
|
|
|
|
|
Important and Urgent,please!