|
| | | Forum Newbie
Group: Forum Members
Last Login: 7/1/2008 5:22:24 PM
Posts: 1, Visits: 4 |
| I am trying to connect my vB6 program to an internet database. I am using an Access database, and its uploaded on the internet. I have the site.
http://users6.nofeehost.com/SpyderZ/Db/Dbinventory.mdb
The host supports Microsoft Access databases, and I have been trying to piece together a code that allows it to connect for the login process.
The problem is, I can only get the program to work when the database is local, but when its on the internet, I can't seem to get it to connect. I need it to say connected so it can login.
Here is the code I am using:
[code]Private Sub Form_Load()
Dim strconn As String
flag = False
flag2 = False
Set conn = Server("ADODB.Connection")
strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ";Persist Security Info=False"
Server = "http://users6.nofeehost.com/SpyderZ"
Source = "/Db/Dbinventory.mdb"
conn.ConnectionString = strconn
conn.Open
End Sub[/code]
Someone please help me! |
| |
| | | 
Forum God
Group: Forum Members
Last Login: Yesterday @ 7:34:31 PM
Posts: 1,465, Visits: 3,404 |
| Welcome to A1vbcode SpyderZ.  Have a read here. 
Keith http://www.martin2k.co.uk/forums/ I've been programming with VB for 12 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning. |
| |
|
|