Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Connecting ADo with ASA


Message #1 by Hendry Rayau <hendry_rayau@y...> on Tue, 22 Jan 2002 11:18:12 +0700
This is a multi-part message in MIME format.



--Boundary_(ID_efjEBsV1OXlczQYw7/rV4A)

Content-type: text/plain; charset=iso-8859-1

Content-transfer-encoding: 7BIT



Please Help.....



I have tried to access my Sybase (SQL Anywhere) database with ADO, but I have no idea what should i wrote on my script to create
connection. Specially on :

 

    objConn.Open "Provider=.....". 



Could someone tell me what is OLEDB provider for Adaptive Server Anywhere. Thank's.  






Message #2 by "Dallas Martin" <dmartin@z...> on Mon, 21 Jan 2002 09:42:11 -0500
This is a multi-part message in MIME format.



------=_NextPart_000_0023_01C1A25F.E6B8D430

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



From the Pages of Able Consulting 

(http://www.able-consulting.com/ado_conn.htm)



ODBC Driver for Sybase SQL Anywhere

  oConn.Open "ODBC; Driver=3DSybase SQL Anywhere 5.0;" & _

                     "DefaultDir=3Dc:\dbpath\;" & _

                     "Dbf=3Dc:\sqlany50\mydb.db;" & _

                     "Uid=3DmyUsername;" & _

                     "Pwd=3DmyPassword;" & _

                     "Dsn=3D"""";"



  Dallas







  ----- Original Message -----



  From: Hendry Rayau

  To: ASP Databases

  Sent: Monday, January 21, 2002 11:18 PM

  Subject: [asp_databases] Connecting ADo with ASA





  Please Help.....



  I have tried to access my Sybase (SQL Anywhere) database with ADO, but 

I have no idea what should i wrote on my script to create connection. 

Specially on :

  

      objConn.Open "Provider=3D.....".



  Could someone tell me what is OLEDB provider for Adaptive Server 

Anywhere. Thank's. 






$subst('Email.Unsub').






Message #3 by Thomas Bellavia <TBellavia@V...> on Wed, 23 Jan 2002 09:25:58 -0500
This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C1A419.E04301F0

Content-Type: text/plain;

	charset="iso-8859-1"



Ask Sybase?



-----Original Message-----

From: Hendry Rayau [mailto:hendry_rayau@y...]

Sent: Monday, January 21, 2002 11:18 PM

To: ASP Databases

Subject: [asp_databases] Connecting ADo with ASA









Please Help.....

 

I have tried to access my Sybase (SQL Anywhere) database with ADO, but I

have no idea what should i wrote on my script to create connection.

Specially on :

 

    objConn.Open "Provider=.....". 

 

Could someone tell me what is OLEDB provider for Adaptive Server Anywhere.

Thank's.  

 




$subst('Email.Unsub'). 






Message #4 by "Steven Broos" <steven.broos@s...> on Wed, 23 Jan 2002 16:24:19 +0100
This is a multi-part message in MIME format.



------=_NextPart_000_0013_01C1A42A.6869F240

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: 7bit



http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForSybaseSQLAnywhere



Check out this URL

All kinds of connection strings.



Maybe i can advice you a very good search engine: google.com :p



Greetz,

Steven

  -----Original Message-----

  From: Thomas Bellavia [mailto:TBellavia@V...]

  Sent: woensdag 23 januari 2002 15:26

  To: ASP Databases

  Subject: [asp_databases] RE: Connecting ADo with ASA





  Ask Sybase?

    -----Original Message-----

    From: Hendry Rayau [mailto:hendry_rayau@y...]

    Sent: Monday, January 21, 2002 11:18 PM

    To: ASP Databases

    Subject: [asp_databases] Connecting ADo with ASA





    Please Help.....



    I have tried to access my Sybase (SQL Anywhere) database with ADO, but I

have no idea what should i wrote on my script to create connection.

Specially on :



        objConn.Open "Provider=.....".



    Could someone tell me what is OLEDB provider for Adaptive Server

Anywhere. Thank's.






$subst('Email.Unsub').




$subst('Email.Unsub').







  Return to Index