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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB & SQL Server

Status
Not open for further replies.
Ctussey

Ctussey

Programmer
Sep 17, 1999
15
US
I'm having a problem writing to SQL Server from my VB program. In one area, I can write to SQL Server on all but 3 areas, in the other area I can't write to the table at all. Does anyone have any ideas?
 
Sort by date Sort by votes
Did you check what kind of locking you are using? Make sure its not readonly
 
Upvote 0 Downvote
I found the problem, I had converted a Access Database to SQL Server and its datatypes were different from Access's so when I tried to update... it failed. Would have been easier to track down if VB had not of been giving an error that said that I was writing to a read only file.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
309
strongm
strongm
Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
266
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
539
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
VB picturebox graphics 1
Replies
1
Views
380
Andrzejek
Andrzejek
wires
  • Locked
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
642
Gabor526
G

Part and Inventory Search

Sponsor

Back
Top