Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 10,696 through 10,710 (of 66,749 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Chad Crawford (1/20/2010)
Lynn Pettis (1/19/2010)
Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE. One of the servers needs to link to a MySQL database. Okay, no problem, download the 5.01 driver, install it, and setup the Linked Server. PeopleSoft Admin tries creating one of the views used to access data from teh MySQL Database, error....
I know very little about MySQL, but I did get a linked server up. We're on 2K5, so there will be some differences, but I can give you the settings we had to use on the linked server if that helps. I'm reading into your post a little, but it sounds like you had the LS working before and just set it up anew, so my help is probably worthless and completely unrelated, but I thought I'd offer since we just went through it a few months ago.
Chad

Have to ask, are you running SQL Server 2005 x64 or SQL Server 2005 x32? If you got the linked server to work using the x64 MySQL ODBC driver I would be very interested in what settings you used, as well as which version.

I had no problems setting up the MySQL ODBC driver and linked server using SQL Server 2005 x32.

Chad Crawford SSChampion Points: 11610 More actions · Answer 2

Lynn Pettis (1/20/2010)
Have to ask, are you running SQL Server 2005 x64 or SQL Server 2005 x32? If you got the linked server to work using the x64 MySQL ODBC driver I would be very interested in what settings you used, as well as which version.
I had no problems setting up the MySQL ODBC driver and linked server using SQL Server 2005 x32.

Both. x64 in prod, x32 in dev and we set up the linked server on both.

On x64, we're using version 5.1 of the odbc driver.

Collation Compatible False

Data Access True

RPC False

RPC Out False

Use Remote Collation True

Collation Name *blank* (the value, not the text :-))

Connection Timeout 0

Query Timeout 0

Distributor False

Publisher False

Subscriber False

Lazy Schema Validation False

And on the MSDASQL Provider:

Dynamic parameter disabled

Nested queries enabled

level zero only enabled

allow inprocess enabled

non transacted updates disabled

index as access path disabled

disallow adhoc access disabled

supports 'Like' operator enabled

On the ODBC Datasource, I have the following values set:

Page1:

Returned Matched Rows instead of affected rows

Allow big result sets

use compression

treat bigint columns as int columns

enable seafe otpoins

Page2:

Don't prompt with connecting

Page3:

Include table name in SQLDescribeCol()

Disable transaction support

--all other options blank or disabled.

I'm not the admin on the MySQL side, but I can do any other testing to see if something works here that doesn't there, I'm willing.

@jcrawf02: 😀 Thanks. It's so seldom I get to offer anything that I jump on something that even looks close.

Chad

EDITED: Added the driver version and ODBC settings

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Chad, Can you also get me the settings for the ODBC Driver?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Thinking about it, all this MySQL stuff belongs over here.

Should get this techie stuff off The Thread.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Lynn Pettis (1/20/2010)
Thinking about it, all this MySQL stuff belongs over here.
Should get this techie stuff off The Thread.

Okay Chad, copied your post to the thread I had started that is linked above.

As I said on that thread, thank you. Wish you had seen that one earlier. More details over there...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Lynn Pettis (1/20/2010)
Thinking about it, all this MySQL stuff belongs over here.
Should get this techie stuff off The Thread.

Thanks - was getting a bit of information overload. 😉

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

CirquedeSQLeil (1/20/2010)
Lynn Pettis (1/20/2010)
Thinking about it, all this MySQL stuff belongs over here.
Should get this techie stuff off The Thread.
Thanks - was getting a bit of information overload. 😉

But you learned something, right?? 😉

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Lynn Pettis (1/20/2010)
CirquedeSQLeil (1/20/2010)
Lynn Pettis (1/20/2010)
Thinking about it, all this MySQL stuff belongs over here.
Should get this techie stuff off The Thread.
Thanks - was getting a bit of information overload. 😉
But you learned something, right?? 😉

Yes, I learned that technical threads don't belong in the thread 😀

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

uhhhh, well, that does happen sometimes around the water cooler... 😉

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

oh ok, then we're all good.

Then I will have to fall back to the secondary learning point - support for MySQL is not good.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Chad Crawford SSChampion Points: 11610 More actions · Answer 11

Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up on my wall. 😛

Chad

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

Chad Crawford (1/20/2010)
Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up on my wall. 😛
Chad

Probably not, but you can add it to your resume.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Chad Crawford SSChampion Points: 11610 More actions · Answer 13

Alvin Ramard (1/20/2010)
Probably not, but you can add it to your resume.

Excellent idea!

Alright, back to the shadows behind the watercooler for me...

Chad

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

Chad Crawford (1/20/2010)
Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up on my wall. 😛
Chad

I'll see if one of my kids can make up a certificate for you. They seem better at that sort of stuff then me. 😉

tosscrosby SSCoach Points: 18045 More actions · Answer 15

Lynn Pettis (1/20/2010)
I'll see if one of my kids can make up a certificate for you. They seem better at that sort of stuff then me. 😉

Isn't that the truth. I have to have my youngest daughter change my ring tone on my phone (I know, pitiful!) as I'll inevitably screw something up and not get calls or something similar.

-- You can't be late until you show up.