all groups > sql server odbc > may 2006 >
You're in the

sql server odbc

group:

ODBC DataSource name problem


ODBC DataSource name problem Jodie
5/26/2006 9:57:01 AM
sql server odbc: Hi All
We have an application which is used the ODBC Data Source to comunicate
with the database. So during the installation of the product the
installation creating
the database name like : VAPost and server = datasource name which is 'VAPost'
not the real server name in the Microsoft SQL server DSN Configuration option.
Also the installation is created the Alias in SQL Server Client Network
Utility for
'VAPost' which has Server alias = 'VAPost', NetWork library = 'TCP/IP' and
the Connection parameters is the ip address of the server.
So my application is used the DSN name 'VAPost' to connect to the database but
there is an error message regarding "Communication Link Failure". I could
not figure out where is the problem but the same configuration it works on
other server. Any help is greatly appreciated.
Thanks,
Jodie
RE: ODBC DataSource name problem Steven
5/31/2006 4:55:01 AM
Hi Jodie,

You are using a system DSN? You should access that DSN using a ".Net
Providers\ODBC data providers" Connection. Configure it to use the DSN.
Then within the dataflow, create a DataReader data source. Set it to use the
DSN connection. You control what is being pulled by the SQLCommand on the
second tab.

-Steven

[quoted text, click to view]
AddThis Social Bookmark Button