Jump to content

ADOConnection to SQL Anywhere 11

Recommended Posts

I'm attempting to connect to SQL Anywhere 11 DB. I received the connection string, minus the Driver, from the application, but can't find the proper Driver syntax/values. I look for older post and saw things like: Driver={SQL Anywhere 11} or {SYBASE SYSTEM 11}

I tried it all (with and without curly brakets), no go. Any ideas?

$oADOConnection = ObjCreate ( "ADODB.Connection" )

$oADOConnection.Open("Driver=SQL Anywhere 11;UID=$user;PWD=$pwd;ENG=$server;DBN=$db;LINKS=ALL")

The following is always retruned (running in SciTE):

(line of the .Open command): The requested action with this object has failed.:

$oADOConnection.Open("Driver={SYBASE SYSTEM 11};UID=***;PWD=***;ENG=***;DBN=***;LINKS=ALL")

$oADOConnection.Open("Driver={SYBASE SYSTEM 11};UID=***;PWD=***;ENG=***;DBN=***;LINKS=ALL")^ ERROR

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...