To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME News MS SQL Oracle DB2 Access MySQL PHP Scripts Books Links DBA Talk


Go Back   Database Journal Forums > Database Discussions > MS SQL Server 7/MS SQL Server 2000

MS SQL Server 7/MS SQL Server 2000 Discuss Microsoft SQL Server 2000 and earlier in this forum

Reply Post New Thread
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 07-08-1998, 05:02 PM
FLauzer
Guest
 
Posts: n/a
MSQuery

HI all,
I`ve a problem to access SQL7 B3 from MSQuery......(simply crash)
(I`ve create DSN from Control Panel and ODBC TEST it`s OK)
Any suggestion?
Thanks
Reply With Quote
  #2  
Old 07-09-1998, 08:59 PM
Hal Berenson
Guest
 
Posts: n/a
MSQuery (reply)

On 7/8/98 5:02:55 PM, FLauzer wrote:
> HI all,
I`ve a problem to access SQL7 B3 from MSQuery......(simply
> crash)
(I`ve create DSN from Control Panel and ODBC TEST it`s OK)
Any
> suggestion?
Thanks

Some older versions of MSQuery trip up on a couple of things in 7.0. You can use the odbccmpt utility to tell the ODBC driver to always treat MSQuery as a 6.5 application, which should solve the problem.

Hal Berenson

All opinions above are mine and mine alone.
Reply With Quote
  #3  
Old 07-16-1998, 09:05 AM
Deborah
Guest
 
Posts: n/a
MSQuery (reply)

We were having problems with some things in SQL7 not working properly
also... ODBC error ... Check for the SQL ODBC in NT and make sure the
service has started ... I don`t believe you need the dsn unless you are
pulling data into excel, access ...

Deborah

On 7/9/98 8:59:21 PM, Hal Berenson wrote:
> On 7/8/98 5:02:55 PM, FLauzer wrote:
> HI all,
I`ve a problem to access
> SQL7 B3 from MSQuery......(simply
> crash)
(I`ve create DSN from Control
> Panel and ODBC TEST it`s OK)
Any
> suggestion?
Thanks

Some older
> versions of MSQuery trip up on a couple of things in 7.0. You can use the
> odbccmpt utility to tell the ODBC driver to always treat MSQuery as a 6.5
> application, which should solve the problem.

Hal Berenson

All
> opinions above are mine and mine alone.
Reply With Quote
Reply Post New Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 11:08 PM.


DatabaseJournal Recent Articles


 » Searching and Sorting Strings in Oracle

 » Preparing To Upgrade Access Tables to SQL ...

 » Sun Expands MySQL With Closed Source

 » Microsoft Demos New SQL Server Features at...

 » Wipro and Oracle Launch First Joint Innova...

Search Database Journal:
 





Acceptable Use Policy

JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Web Hosting | Newsletters | Tech Jobs | Shopping | E-mail Offers

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.