Linked server sample using SQL Server 2005

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Re: Linked server sample using SQL Server 2005

Postby Moderator » Sun Sep 13, 2009 9:41 pm

Jason,
I haven't been able to reproduce the issue. Would you please also send PGNP version, OS version, MSSQL version?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 317
Joined: Wed Oct 29, 2008 11:27 pm

Re: Linked server sample using SQL Server 2005

Postby Info@consolidata.co.uk » Thu Mar 04, 2010 8:41 am

Hi This seems to work fine for me following the steps given (thanks :D )

i now have a query issue

I did a count on a table in the postgresAdmin the returned close to a million rows
the same query using open query does not run at all. the count errors

so i did a select query

query
SELECT customer_id
FROM
OPENQUERY (PG_ClientDB, 'SELECT customer_id FROM customers;
')

Error
Cannot process the object "SELECT customer_id FROM customers;
". The OLE DB provider "MSDASQL" for linked server "PG_ClientDB" indicates that either the object has no columns or the current user does not have permissions on that object.

strange error behavior from here because if i add ' LIMIT 400000' (or upto that value) This returns the select query back with the 400000 rows

any thing higher and it fails

Then wen i check the catalog folder for my pg database it has vanished 3 minutes later i then comes back ???????? :!: :cry:

is there a limitation on the odbc driver or using Open Query causing this to happen ?

Thanks in advance it would be really great to get this solved

Rgds

Dwain
Info@consolidata.co.uk
 
Posts: 4
Joined: Mon Feb 15, 2010 2:28 am

Re: Linked server sample using SQL Server 2005

Postby Moderator » Thu Mar 04, 2010 8:13 pm

It can be caused by a SQL Server buffer or smth related to the Linked Server implementation.

Could you try different syntax for the query (called 4-part identifiers):
SELECT customer_id FROM PG_ClientDB...customers

What is the customer_id type (and the table schema)? Do you run 32-bit SQL Server?
User avatar
Moderator
Site Admin
 
Posts: 317
Joined: Wed Oct 29, 2008 11:27 pm

Re: Linked server sample using SQL Server 2005

Postby Info@consolidata.co.uk » Mon Mar 08, 2010 8:34 am

HI


I tried using this 4 part but still get an error

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

This is quite frustraighting as i thought that a linkserver would be able handle this

but i actually think its a bug with the ODBC provider (driver) any queries on tables over 400,000 return an error.

(Moderator) Could you try a count or a select query and see if you have the same results

Thanks
Info@consolidata.co.uk
 
Posts: 4
Joined: Mon Feb 15, 2010 2:28 am

Re: Linked server sample using SQL Server 2005

Postby Moderator » Mon Mar 08, 2010 11:25 pm

Hi Dwain,
I have tried both 4-part identifier and OPENQUERY syntax for selecting customer_id column from my own customers test table:
SELECT * FROM OPENQUERY(PGNP_SAMPLE, 'SELECT customer_id FROM customers');
SELECT customer_id FROM PGNP_SAMPLE...customers;

And both worked well (customer_id was declared as int, and number of row was over 2 million).

Would you send customers table definition and the PGNP provider version you used?

Thank you,
Konstantin
User avatar
Moderator
Site Admin
 
Posts: 317
Joined: Wed Oct 29, 2008 11:27 pm

Re: Linked server sample using SQL Server 2005

Postby Info@consolidata.co.uk » Thu May 27, 2010 5:38 am

Hi

sorry its taken me so long to reply to this as i was just writing a blog and thought id look at the issues i had with setting up a SQL to PGSQL database

Question:
Your saying that you can do a select on a table over 400,000 records using Sql Server Linked serever to PG Database ?

I resolved this issue with doing a loop round in ssis with a offset varible as doing the same query in ssis caused it to fail

maybe it the temp db setting causing the timeout how do you configure this in Sql for linkedservers
Info@consolidata.co.uk
 
Posts: 4
Joined: Mon Feb 15, 2010 2:28 am

Re: Linked server sample using SQL Server 2005

Postby Moderator » Mon May 31, 2010 6:16 pm

Yes, it should work with 400K or more rows. Would you send the table DDL?

I was unable to reproduce the issue.
User avatar
Moderator
Site Admin
 
Posts: 317
Joined: Wed Oct 29, 2008 11:27 pm

Re: Linked server sample using SQL Server 2005

Postby Info@consolidata.co.uk » Thu Jun 03, 2010 2:47 am

Hi

do you required the DDL From PG or sql linked server setup

i know this stupid but its difficult to point point what is failing here
Info@consolidata.co.uk
 
Posts: 4
Joined: Mon Feb 15, 2010 2:28 am

Re: Linked server sample using SQL Server 2005

Postby Moderator » Thu Jun 03, 2010 8:01 am

Please send Postgres table DDL. Any additional information that will help reproduce the issue is appreciated.
User avatar
Moderator
Site Admin
 
Posts: 317
Joined: Wed Oct 29, 2008 11:27 pm

Free bonus james avery promise rings

Postby Macexek » Thu Mar 05, 2015 12:50 pm

Kanga runs faster than any of Us, even Me.
spy on whatsapp iphone how to bug a cell phone for free Bond looked into the pretty, angry little face. adware spyware removal freeware sms spy nokia e71 And she went on planning to herself how she would manage it. spy trackers cell phone spy pro apk There was one line of writing in ink: Marshall Aid.
android spy github sms spy deluxe Your wife cant like you being away so much. cell spy pro download link In the east, the sky was pearly grey and iridescent, like a toy balloon filled with cigarette smoke, and among the shrubs the mocking birds were beginning their first song. Observing him in these moods, I often dwelt meditatively upon the old philosophy of the Bi-Part Soul, and amused myself with the fancy of a double Dupin-the creative and the resolvent. spymobile review spy phone free download for iphone best free android tracking app
free mobile spy smartphone monitoring software spy sms hp java He felt fairly confident that now he wouldnt have to deal with them. download spyware terminator 2014 full husbands who cheat And that being so (if the Bees were Bears), We shouldnt have to climb up all these stairs. cell tracker reviews sms trackers This time it was a woman.
free text message tracker online how can you tell if he is cheating This is just a painted up motor car with some of Doctor Nos men in it. spyware removal free online What I have been instructed to say to you will not have come as a surprise to any of us. To which, to my astonishment, he replied, Goodbye, my dear. mobile phone spy equipment spyware removal tools freeware free real time gps cell phone tracking
live cell phone tracking android spy location For another five minutes nothing moved in the mangrove pool, then, in one corner among the roots, a thin periscope of bamboo rose slowly out of the water. cell spy software best sms tracker app for android One of her early boy-friends had said she looked like the young Greta Garbo. tracking a iphone how are cell phones tracked Would you like to come, in?
how to track a cell phone online iphone tracker apps She gestured to the chair across the table from her. spy text messages free without target phone On each side of the chest, near the top, were three rings of iron-six in all-by means of which a firm hold could be obtained by six persons. Between me and the moonlight flitted a great bat, coming and going in great whirling circles. apps to see text messages spy vs spy game android parental controls on cell phones
how to spy whatsapp conversation spyware terminator 2014 review cnet So far as his labors extended? phone tracker app life360 text spy app for iphone The captain swore polyglot, very polyglot, polyglot with bloom and blood, but he could do nothing. spyware removal free mac smartphone uberwachung The King turned pale, and shut his note-book hastily.
mac spyware removal freeware spy your android phone The lips were red, nay redder than before, and on the cheeks was a delicate bloom. best android tracking app And you can get ammunition for the Walther anywhere in the world. Strangways had never suffered the ignominy of a Blue call, let alone a Red, and was as certain as could be that he never would do so. is he cheating on you spokeo spy on iphone texts when your girlfriend is cheating
how to find if someone is cheating on you how to read deleted text messages on iphone 5c Of course I have, you said. is he cheating again or am i paranoid tracing cell phone calls Has anything unpleasant happened since I saw you? how to find out your husband is cheating sms spy in pakistan He obviously thought he was being smart enough cutting his initial in my hand.
cheaters spy gear download spyware doctor with antivirus 2014 free Poor dear, she is naturally anxious about Lucy, and she tells me that her husband, Lucys father, had the same habit, that he would get up in the night and dress himself and go out, if he were not stopped. free android spy apps cheating spouse I could have fancied, while I looked at it, that some eminent landscape-painter had built it with his brush. Although the writer admits the distinction, he yet includes them all in the same category. whatsapp spy without access to phone mobile spy software free download for pc how do you track another iphone
facebook android app spying htc wildfire spy Then she began to rub her lips as though to cleanse them from pollution. signs hes cheating on you free software for android Thus, may it please your Excellencies, I have detailed some, though by no means all, the considerations which led me to form the project of a lunar voyage. spyware for android cell phones can parents read text messages online at&t iphone Would you call up the Gleaner and ask if theyve got a photographer called Annabel Chung?
espiar por wasap spying on cell phone But it is here that the grave shock that he experienced tells upon him the most. facebook chat spy software Are we going to the top? So he turned it into a hum instead. ipad as spy cam ipad controlled spy tank how to know if husband is cheating
track an android phone workplace computer monitoring I was looking at a very beautiful girl, in a big cart-wheel hat, sitting in a victoria outside Guilianos, when I felt Jonathan clutch my arm so tight that he hurt me, and he said under his breath, My God! spy your friends phone dangers of texting and driving Our hope now is in knowing all. traqueur mobile software to monitor cell phone activity Theyre just making it look as if all their big shots were gaga.
iphone tracking software track android phones And suddenly there was a great tongue of fire and a terrible iron crash as if a battleship had run on a reef. how to track phone calls Now its going fine, except that Peru keeps most of the guano to herself, for her own agriculture. Christopher Robin was at home by this time, because it was the afternoon, and he was so glad to see them that they stayed there until very nearly tea-time, and then they had a Very Nearly tea, which is one you forget about afterwards, and hurried on to Pooh Corner, so as to see Eeyore before it was too late to have a Proper Tea with Owl. kisses cell phone spyware removal keylogging program cell phone spy android app
best mobile phone spy application how to spy on iphone free For a minute the leader stared suspiciously at Bond, wondering, trying to fathom whether perhaps Bond had got some edge on their boss. phone parental controls spy moviles I am expecting Mr Saye any minute now, she said indifferently and went out and closed the door. samsung admire spy software best cell spy software free Some trees, now growing, are partly petrified.
download spyware doctor 2014 full crack computer activity monitoring software And this job of yours stinks too. how to tell if she is cheating I see the lights scattered all over the town, sometimes in rows where the streets are, and sometimes singly. Only too glad if somebody has bought something in the country. programa para conversaciones whatsapp how to spy samsung phone best spyware removal software free
spy phone iphone cydia how to read other peoples text messages for free I laid my hand on the typewritten matter. phone tracker gps locator find anyone pro spyware doctor 2014 free download The strong air would soon restore Jonathan. best spyware for iphone como ver conversaciones de wasap He felt the dry, uncomfortable gravel under his evening shoes, the bad, harsh taste in his mouth and the slight sweat under his arms.
samsung galaxy y pro duos b5512 best cell phone tracking He smiled politely at the girl. monitoring a cell phone Think of all the possibilities, Piglet, before you settle down to enjoy yourselves. Occasionally he snarled like a wild beast. find out if boyfriend is cheating cheating spouses whatsapp spy para pc
download free whatsapp anti spy mobile pro for iphone Have you felt the Vampires lips upon your throat? kids monitoring software free cell app Bilders face doubled its natural length with surprise. spyware terminator 2014 virus mspy whatsapp The umpire shook his head, pointing at Makharovs clock, which now said three minutes to one.
how to jailbreak droid spyware removal reviews In view of such a gale the broad Atlantic becomes a mere lake. free trial anti spyware removal Our souls are knit into one, for all life and all time. Around in every direction it was still as black as pitch, but nearly overhead there burst out, all at once, a circular rift of clear sky - as clear as I ever saw - and of a deep bright blue - and through it there blazed forth the full moon with a lustre that I never before knew her to wear. skype spy recorder freeware whatsapp downlod read text messages iphone icloud
sms monitoring system mobile phone spy application But, even where an edge is presented, two thorns will be necessary, operating, the one in two distinct directions, and the other in one. identify at least three spyware removal software solutions the cost vendor crack email password The young officer answered calmly, I said a dog. spy on a mobile cell spy pro v2.rar So I contented myself with making a general statement that he appeared to be improving very rapidly, that I would have a longer chat with him in the morning, and would then see what I could do in the direction of meeting his wishes.
android ghost spy phone software review phone browser history But this feeling soon gave place to irritation. whatsapp spy blog One of his shirt sleeves hung in tatters. Ten minutes, but no more answers until you tell me who you are. track spouse can i read text messages from my phone on my computer how do you track a cell phone
spy site view someones facebook messages All of them, said Owl sulkily. spouse monitoring software spy sms mitlesen kostenlos It was soothing, somehow, to the feelings to find myself disassociated even in the mind of this poor madman from the others, but all the same I do not follow his thought. free cell spy application mac spyware removal freeware It seems theres a bird called a Roseate Spoonbill.
smart phone logs free online real time cell phone tracker It was now the opinion, or rather the wish, of the physicians, that M. hacking cell phone texts Mathis gazed at the set for a few seconds with benevolence and then turned it off and his voice was full of dismay. Well, Armourer, what do you recommend? signs my wife cheating cell phone locater whatsapp spy ya no funciona
android spy 2.51 spy sms pro reviews You have no reason for concealment. husband cheating on me free downloads for android phones Demon eyes, of a wild and ghastly vivacity, glared upon me in a thousand directions, where none had been visible before, and gleamed with the lurid lustre of a fire that I could not force my imagination to regard as unreal. how to spy on whatsapp chat cell phone tracking websites Then I grew angry and cursed, with the curse of silence, the river, and the lilies, and the wind, and the forest, and the heaven, and the thunder, and the sighs of the water-lilies.
flashlight app spying cell phone record If he lost the croupier would extract what was necessary to cover the bet, but the easy gesture conveyed that Bond didnt expect to lose and that, this was only a token display from the deep funds at Bonds disposal. g1 root Theyve got the form he filled up to get his entrance card. I did not wish, however, to lose gas at so early a period of the adventure, and so concluded to ascend for the present. anti spyware for iphone free best spy app for iphone why texting while driving is dangerousiphone 4 tracker appcall gps sms tracker apk free downloadcell spy pro downloadspyware on android phonesspyphone android chomikujwhatsapp spy para xperiaiphone spyware removal applicationcheater spyfree downloads for cell phonesspy software free download for pc
Macexek
 
Posts: 17
Joined: Mon Mar 02, 2015 6:45 am

PreviousNext

Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest

cron