SQL Server Native Cleint and PB

Question

SQL Server Native Cleint and PB

adeel.imtiaz

SSCommitted

Points: 1805
More actions
May 21, 2013 at 7:52 am

#278096

Dear Gurus,
How to the apply the ‘Auto Translate’ property of the SQL Native client (OLE DB) connection string in Power Builder 12.5 ?
Thanks
Malik Adeel Imtiaz

Viewing 3 posts - 1 through 2 (of 2 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

adeel.imtiaz (5/21/2013)
Dear Gurus,
How to the apply the ‘Auto Translate’ property of the SQL Native client (OLE DB) connection string in Power Builder 12.5 ?
Thanks
Malik Adeel Imtiaz

I saw your other post on the same issue after your power builder upgrade;

it's weird, i went to connectionstrings.com and i don't see a property for Auto Translate;

http://connectionstrings.com/Articles/Show/all-sql-server-connection-string-keywords,

but i do see it here on the MS site:

http://msdn.microsoft.com/en-us/library/ms130822.aspx

so this string, without the CrLf i added for readability, would be an example?

Dim ThisConnectionString As String =

"data source=DEV223;

initial catalog=NEWGEO;

user id=MySQLUserName;

password=NotTheRealPassword;

Trusted_Connection=False;

Connect Timeout=30;

AutoTranslate=yes;

Workstation ID=GhostInTheMachine;

Application Name=HaxxorPadPlusPlus;"

does that help?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

adeel.imtiaz SSCommitted Points: 1805 More actions · Answer 2

Dear Lowell,

Yes due to some urgency i posted this also on Expert Exchange for urgent solution.

Any ways thank you for your quick reply.Please see attached document

Thanks

Malik Adeel Imtiaz