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 strongm 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

Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
186
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
VB picturebox graphics 1
Replies
1
Views
130
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
VB 6 Trig functions 1
Replies
3
Views
156
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to use 2D array in vb 6? 1
Replies
10
Views
229
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
319
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top