Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC vs SQLOLEDB

Status
Not open for further replies.
Olsen

Olsen

Programmer
Nov 24, 2000
1
DK
Hello.

When I try this with SQLOLEDB Provider :

UPDATE Table1 SET var=var1
SELECT MAX(Column) as MaxNumber

I get an error, but not with 'old' ODBC drivers.
Any suggestions?

Best Regards,
Olsen
 
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
638
Chris Miller
Chris Miller
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
821
Volvere
V
orch10
  • Locked
  • Question
odbc connect to sql SErver
Replies
4
Views
268
Olaf Doschke
Olaf Doschke
manalyticsdev
  • Locked
  • Question
"Restricted data type attribute violation" error and SQLS 2017, ODBC Drivers 11 & 13 f
Replies
0
Views
203
manalyticsdev
manalyticsdev
grnzbra
  • Locked
  • Question
SQL String vs Separate SELECT Statements
Replies
2
Views
186
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top