Solved

ODBC driver error

Posted on 2011-03-25
1
1,041 Views
Last Modified: 2012-05-11
hi,
I have created a new sybase database dbsyb.db on my server machine with sybase central 9 and its run correctly.
Now I'd like to connect at dbsyb.db from my client workstation via ODBC
SERVER SIDE:
I create a new ODBC with these parameters:
driver ODBC: Adaptive server anywhere 7.0
ODBC
Data source name: dbsyb
Description: database sybase
Checked: Microsoft applications and prevent driver.........
Describe cursor behavior: If required

LOGIN
Checked: Supply user ID and password

DATABASE
Server name: dbsyb
Start line: -p 4096 -x tcpip -d
Database name: dbsyb

NETWORK
Checked: TCP/IP

ADVANCED
CHECKED: Allow multiple record....

CLIENT SIDE:
same ODBC parameters but the driver ODBC is "Adaptive server anywhere 9.0"

dbsyb respond on the port 2638 and I tried telnet ipserver 2638 and run correctly
BUT when I try Test Connection I get error:
database server not found
The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.52

What I wrong?
0
Comment
Question by:ralph_rea
1 Comment
 
LVL 17

Accepted Solution

by:
BudDurland earned 500 total points
ID: 35221861
No real need to set up an ODBC on the server (unless you have a program running there that requires it).  My personal preference is to give the server and the database similar but different names.  Are you starting the database from the command line, or are you using Sybase Central to configure a service?

The command line parameters would look kinda like this: -n dbsybsrv -x TCPIP -p 4096 <datafile name> -n dbsyb

When configuring the client-side ODBC, on the 'database' tab, put dbsybsrv in the 'server' line and dbsyb in the 'database' line.  On the 'network' tab, check 'tcpip' and enter 'host=server address',  'server address' can be either the IP address, or a FQDN for the server hosting the database.

For testing purposes, you can put a username/password in the appropriate places on the 'login' tab, and then click 'test connection' in the 'ODBC' tab.

Hope this helps
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Join & Write a Comment

This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now