DSUSRL option do not find my Sybase ASE server
I'm trying to connect to Sybase ASE 15 using ADO.net in a Powershell script At the beginning of the shell I got the load of the DLL :
Add-Type -AssemblyName "Sybase.AdoNet2.AseClient, Version=2.157.1330.0, Culture=neutral, PublicKeyToken=XXXXXX"
Since I have to loop over more than 15 servers each one running on a different port, I was quite satisfied of the option of specifying the DSURL option in the connection string :
$SybaseConn.ConnectionString = "DSURL='file://C:\sybase\ini\sql.ini?SQL_MIDOFF_OPC1';Data Source='TheServer';Database='master';UID='sa';PWD=’blablabla’;"
Unfortunately I'm getting the error : "Exception calling "Open" with "0" argument(s): "Cannot locate reference to the DB server specified in DSURL."
Has someone already used this option and give me a push to finish this ?
Thanks in advance !
Got it, I thought that the word "SQLMIDOFFOPC1" was part of the syntax, in fact, it was the server name, the syntax is
$SybaseConn.ConnectionString = "DSURL='file://s:\sybr\ini\sql.ini?MyServer;Database='master';User Id=sa;Password=XXXXX
Cannot connect to sybase server using ssl connection string
Hello, I am trying to connect to Sybase server using ssl enabled connection string. But I always get exception "[AseException: Could not load sybdrvssl library]0 votes0 answersChetana Gon Dec 26, 2017
Access to Sybase Anywhere 8.0 with Excel VBA
Hi! I Need make a connection to Adaptive Server Anywhere 8.0 database using Excel 2013+VBA commands, Someone who can help me0 votes0 answersMiguel CABRALon Mar 29, 2017
Connect to Sybase ASE Database with Visual Basic 2015
Hello all, my gears are grinding for some weeks now. My company uses Sybase ASE, but I can't figure out how to connect to the database with Visual Studio 2015 (Visual Basic). Where I need help with:0 votes2 answersBrian Looseon Mar 13, 2017
Invalid user name and/or password in odbc_connect command in php script
I use Eaglesoft practice management software for my practice. For the older version (16.0), I had a simple php script written to connect to its database using oddcconnect. The database is sybase (Sap) sql anywhere and the connection string used was odbcconnect("dental", "dba","sql").0 votes1 answerArnav Kumaron Sep 21, 2016
How to connect ASA8.0 database file directly in Powerbuilder 11
How to connect ASA8.0 database file directly in Powerbuilder 11? (Background: I connect to ASA11.0 with ODBC in Powerbuilder, at the same time, I need to connect to ASA8.0 database to retrieve data,0 votes0 answersRobert Xiongon Mar 23, 2016
Connect to Sybase db VB2010 ADO
I am working in Visual Basic 2010 and connecting to a Sybase 12 database on a remote server using ADO. I want to connect through code as the particular database will change.0 votes2 answersSteve Julianon Jul 31, 2014
Sybase ASE OLE DB provider for 12.5
Hi, I am working on migration from Sybase to SQL server 2005 project. I need to connect Sybase through OLE DB provider. I want to download Sybase ASE OLE DB provider for 12.5 Is there any locat1 vote2 answersChirag Patelon Nov 29, 2012
- Load more posts