SQL Server Native Cleint and PB

  • 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

  • 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!

  • 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

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

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