DSN connection

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 10, 2009 at 6:23 pm

  #137922

  We have an application program from DSN uring SQL driver to connect SQL 2000 originally.

  Now we would like to connect to SQL 2005. We tried from DSN using SQL driver and SQL native driver. Both of them worked without any issue.

  However, when we used our application program to connect SQL 2005 via this DSN, we failed.

  Does it make sense? If so, is there any suggestion to fix the problem?

  Any input will be greatly appreciated.

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  August 10, 2009 at 10:00 pm

  #1037212

  Well, it really depends on what it's trying to do.

  Do you have the error message for us?

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: