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

Connect to remote database

Status
Not open for further replies.
new2this2002

new2this2002

Programmer
Jun 22, 2002
67
GB
i have an access database on my webserver, all the ODBC stuff is set up and i have created an asp page to connect to it and read the contents of one of the tables in the database.

My question is how do i do this using vb? I cant get it to work.
 
Sort by date Sort by votes
Using ADO try this to connect.

Dim CONN As New ADODB.Connection
With CONN
.ConnectionString = "DSN=myodbc"
.Open
End With
Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
1K
strongm
strongm
Swi
  • Locked
  • Question
Printer.Print to PDF 1
Replies
16
Views
892
Swi
Swi
sal21
  • Question
Based the link above how to simulate click event
Replies
4
Views
278
2009luca
2009luca
sal21
  • Locked
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
249
strongm
strongm
2009luca
  • Question
possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message
Replies
5
Views
368
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top