Hello,

I started my new job last last and i am tasked to retrieve data from Voyager Billing System ( which is based on SYBASE database).

I tried this code:

Code:
<%
	Dim strSQL
	Set rsObj = Server.CreateObject("ADODB.Recordset")
	Set MdConnection = Server.CreateObject("ADODB.Connection")
	
	'On Error Resume Next
	MdConnection.Open "Driver={SYBASE ASE ODBC Driver};" & _
           "Srvr=XXXXXX;" & _
           "Uid=XXXXXXXXX;" & _
           "Pwd=XXXXXXXXX"
    
	strSQL = " SELECT MarketId,AccountNumber,LastName,FirstName FROM ACCOUNT_MASTER "

	rsObj.Open strSQL, MdConnection

%>
but i am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


so from the error we can that i have no Drivers specified...

1. can someone help me setting up the drivers...
2. presently i dont even no the name of the server, username and password...do i need to get that information from the vendor or can i find it in any other way...

But i think FIRST i need to set up the drivers...someone please help me out...

Thanks in advance