Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC driver error

Posted on 2011-03-25
1
Medium Priority
?
1,066 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 17

Accepted Solution

by:
BudDurland earned 2000 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

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Suggested Courses

609 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