Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Connect To Remote SQL Database


I've been trying to do this, but can't seem to find anything that works - I wanna connect to a remote sql database, located on my website server.
I have the username and password, I just need to be able to connect and query the database.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Connect To Remote Database
hi... i got a problem connecting to my account on a web server which has my mysql database (version 5.0.27). i use the following connection string:


Code:
db_connection.Open "driver={MySQL Connector/ODBC v5};server=sample.orgfree.com;port=3306;database=150008;uid=150008;pwd=paswordhere;option=3;"


i have installed on my pc the mysql odbc connector... i always gets a failure connection...

what should i do to be able to connect from my vb app to my database which is located in my account on a web server?

Connect To Remote Database
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.


Connect Remote Database Via Proxy
Hi experts,
I have the following situation. I need to add/modify/delete data to my website's SQL server[IP Address known] from my office. The software will be installed on NT Server and the connection to Internet on the machine is available via Analog X Proxy[Downloadable shareware]. Can I do this? If yes how?
Thx in anticipation

Connect To A Remote MS-ACCESS Database
I have an access database that has shipping information (invoice#, customer name, USPS tracking #). I created an ASP to query the database and that works fine. On the other hand, I have a VB application that updates the tracking information (along with some other data) into my accounting software.

The point is that I would like to modify the VB (VB 6) to also update the remote database with the last invoices shipped. I've spent about 2-3 hours trying to look for the proper ado connection string, but I'm not sure I found it. Can anybody point me in the right direction? Any help would be greatly appreciated.

So far, this is what I have:
I created a sample project that connects to the database using the ADO Data Control. I was able to open the database & table (Tracking) but I get an error when I use the .AddNew method.

Is this the best way of doing, should I deal with the error or is there a better way of doing it.

How To Connect To The Remote Msaccess Database
hi

i have designed one application in that i need to connect to the remote access database by using the vb. through this i want to edit ,delete and read the records in the access database.

how to connect to it?
give me a example for better option.

Can Anyone Tell Me How To Connect To Remote Access Database
i'm using vb6 , and access databse for database ,
i want to connect to remote access database on the server
but i don't know how, i think there is some setting in odbc or what?
here is the code i use
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
.Open "Provider=MS Remote;" & _
"Remote Server=http://info;" & _
"Remote Provider=MSDASQL;" & _
"DSN=ourdatabasenew6;" & _
"Uid=admin;" & _
"Pwd="
is it correct?
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
or this is correct?
.ConnectionString = "Provider=MS Remote;Remote Server=http://myServerName;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:somepathmydb.mdb" '"admin", ""

.Open
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
i tried this 2 codes but didn't work , i think there is some problem in setting in odbc .
thank you

How To Connect Remote Access Database Through Vb
Dear All

How to connect remote ms access database through vb,

thanks in advance



Bhadresh Sangoi
Cell : +91-9892638621
email@removed
I'm careful not to confuse excellence with perfection.
Excellence, I can reach for; perfection is God's business

How To Connect To A Remote MS-Access Database?
hi friends

i am desiging one applciation in that i need to connect to my company website server in that i will have a MS-Access table.

i have created one DSN for this table in the web server (DSN=STBDSN).

think that i have a website called STB.com in that i have DSN called STBDSN this DSN points to the MS-Access file in the server.

so from VB how can i connect to that DSN..

please help for this

thanks in advance.

thanks
---------------------------------------------
Srinivas.

How To Connect To Remote Access Database Using Vb
hi friends

    how to connect to a remote MSaccess database using vb6.0.

i m having Msaccess database in the remote server i want to connect to the database and need to do operations like create edit and delete and view the recirds.
    
plz give as a possibilities to connect to a remote server

if u have a sample it will be better.

thanks
---------------------------------------------
Srinivas.

How Can We Connect A Remote Mysql Database
Hello everybody .
im murali , I have a doubt in connection strings in Vb 6.0. Im developing a vb application in tht application i have to store datas in a web database that is in MYsql server. How can i connect tht .Any body idea please tell .

im have myodbc driver for Mysql .

How To Connect To A Database On A Remote Server?
hi,

iam working in INDIA.

we had a database server which is in US.

i know how to connect to a database thorugh connection object

like
cnn.open "provider=msdaora;uid="scott";pwd="tiger";DataSource="

where cnn is the connection object

will i require any other parameter to connect to a remote database

if so what will be that parameter.

pls could any body help me...

Connect To Remote MySQL Database And Get Data
Hi,

Im using Visual Basic 6.

I own and run a website which is powered by a MySQL database. It contains tutorials and stuff like that.

Now what I want to do is to create a program which will connect to that database and will then pull data from it. The first thing I want to pull is the tutorial categories which are in a table called tutorial_cat
Id like them to then be listed in an options box or something...

How do I go about doing this?

Thanks

How To Connect Remote System Using MS Access DataBase
Hi

How to connect remote system using MS Access DataBase.

I used this connection string ,

conn = "Provider=MS Remote;Remote Server=203.88.140.242;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Inmacs.mdb;Persist Security Info=False"

conn is opening , but in login screen when i click login button i am getting this error "Can't Connect to Server"

Regards
U.Srikanth

Connect To MS Access Database On Remote Computer
Hi.......

I'm trying to connect MS Access database which is on the Remote Computer.

I've written this code. While opening connection ("No Error") but if I try to select or insert records ("Run-time error '4100' Business object cannot be created.)

Plz suggest :-


VB Code:
Dim MyConn As ADODB.Connection    Set MyConn = New ADODB.Connection     MyConn.Open "Provider=MS Remote;" & _                "Remote Server=server;" & _                "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _                "Data Source=" & App.Path & "StatusReport.mdb;" & _                "Persist Security Info=False"        MyConn.CursorLocation = adUseClient     MsgBox "Connectin OK"    SQL = "Insert Into Testing(abc) Values('Manoj')"    MyConn.Execute SQL                                        'ERROR HERE    MsgBox "Insertion OK"



ALTHOUGH THERE IS ONE MORE THING WHICH I TRY TO USE i.e.

"File Name=MyFileName;"


VB Code:
MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _                "File Name=MyFile;" & _                "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _                "Remote Server=\server;" & _                "Data Source=& App.Path & " StatusReport.mdb;" & _                "Persist Security Info=False"


I don't know how to get it done. Plz suggest a solution.

Thanks & Regards
Manoj

How To Connect Remote System Using MS Access DataBase
Hi

  How to connect remote system using MS Access DataBase.

 I used this connection string ,

    conn = "Provider=MS Remote;Remote Server=203.88.140.242;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Inmacs.mdb;Persist Security Info=False"

conn is opening , but in login screen when i click login button i am getting this error "Can't Connect to Server"

Regards
U.Srikanth

Please do not double post:PROBLEM:
You posted the same question at view topic #144723
Please read the: Posting Guidelines Item 2.
It won't increase but rather decrease your chance to get help.
If you make a mistake with your post, you can always edit it!





Edited by - rock on 5/9/2007 1:57:06 AM

How To Connect Remote System Using MS Access DataBase
Hi

  How to connect remote system using MS Access DataBase.

 I used this connection string ,

    conn = "Provider=MS Remote;Remote Server=203.88.140.242;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Inmacs.mdb;Persist Security Info=False"

conn is opening , but in login screen when i click login button i am getting this error "Can't Connect to Server"

Regards
U.Srikanth

How Do I Connect Remote Sql Server Database Through Visual Basic
I would like to update records to remote database along with my local database when i run my local vb application. i am using vb6 and sql server in my local network and i have a web server (sql server).

plz suggest me

regards
suresh

Long Time To Connect To A Remote MySQL Database - Help
what can make a connection to a remote database (mySQL) so slow?

How To Connect To Remote Server's Sqlserver Database From My Laptop
hi friends,

           My question is how to connect to remote server's sqlserver database from my laptop.This is very urgent and important to my project. Plz... any one help me.

urs
suma.n

Connect To Remote DB
Hey, I was wondering how I would go about connecting to an Access database from a vb6 program that I am trying to write. I want to check what a user puts into a username/password form against a database of users on my site so that only members can use it. I've tried using connections similar to what I would use in ASP but only using the Remote connection and I keep getting errors on the connection string.

Also, is there going to be any problems I might run into with doing this? I'm talking about distributing it to my members so I was wondering if there is any kind of driver or so that they would need to have installed for this to work.

Thanks,
Chris

How To Connect To Remote DB In VB App
Hi all

Posted this in another section of the forum but this one is probably more suited ...here goes...

Can anyone tell me how to connect to a remote DB within a VB App?

Think napster or KaZaA...that type of thing.

I wont be using it for file transfer like these apps but the idea is the same. I'll have a central database containing the content for which the VB app will connect to retrieve the info based upon user criteria.

For example: If I were creating a Trivial Persuit game....multiple choice question...the suer selects an option then clicks the 'retrieve answer' button...the VB app then connects via modem/lan whatever and retrieves the answer...tell me thats clear!

Cheers


Wayne

Remote Connect To A Db Using DAO?
Can anyone provide me an example how can i write to an access db which is located on another pc by using DAO?

thnks

How To Connect To Remote Pc Using Vb
i want to connect to server using vb program.
in server in c drive there is a folder there i want to save file. how do i do this.
i need help regarding this.

thank you
sudheer

VB6 Remote DB Connect
Whats up guys, just trying to find some information on using DAO to connect to a remote MYSQL database so I can pull some records for auditing purposes. I wonder if I am limited on certain types of databases I can interface with so, if you know something about that, that too would be helpful. thanks in advance.

EDIT: sorry, should have looked at the topic list first before posting.. MODS feel free to delete this thread.. sorry again.

Connect On A Remote DB Using DAO
Can anyone provide me an example how can i write to an access db which is located on another pc by using DAO?

thnks

Connect To Remote System
Hi,
i want to conect with other person on net through ip address how can i do it. can i send him messages
thanks

Trying To Connect VB6 To Remote MySQL
Hi,

I'm about pulling my hair out trying to perform the above. I get the error

[Microsoft][ODBC Driver Manager] Data source not found and no default driver specified

Here's the code


Code:
Private Sub Command1_Click()
conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=www.myserver.com;DATABASE=mydb;USER=a;PASSWORD=b;OPTION=3;"
conn.Open

End Sub
Real connection details obviously removed.

I have the following references enabled

VB for applications
VB runtime objects and procedures
VB objects and procedures
OLE automation
Microsoft active data objects 2.8 libray
Microsoft remove data object 2.0


Any help GREATLY appreciated!


Cheers

Connect To Remote Oracle DB
Hi,

Iam creating an ActiveX control, which will be on a ASP page that should connect to a oracle Db which is in the server. This ActiveX control should access database so that it can update or select data from it.
Can I use ADO to connect to the server? If yes what should be the connection string used for it.
Thanks in advance for your help.

Thanks,
Pres

Showing The REMOTE CONNECT Dlg Box
Do you know how can I show the "Remote Connection dialog box" ( I mean the connection to a remote computer of a LAN, with Username and Password txtBoxes) automatically from VB-code?
Thank you and "CIAO" from Italy.

How To Connect To The Dsn Of The Remote Machine
hai ,
I need to connect to the dsn of the remote machine from vb application..that dsn in remote machine will point to the databse in the other machine which is connected in lan with the remote machine..
is this possible..

thanx in advance..

Connect To The Remote Server Using VB 6.0
Connect to the remote server using VB 6.0 ...?

How To Connect To DSN On Remote Machine
Hi,

I need to connect to an Access database on a remote machine using DSN.
does anyone know the connection string for this? i tried using this:

"{Driver=Microsoft Access Driver (*.mdb)}; Server=192.168.1.104; DSN=ATGSMSGW; "

Gives no errors but doesnt seem to work either? Can someone help?





Edited by - jshree on 5/3/2004 1:22:37 AM

Best Way To Connect To Remote DB, ADO Or ODBC?
Hi all !

I need some solid advice on the best way to connect to a remote MS ACCESS 2000 DB. I have 4 a software running on different PCs and they all connect to one central DB which is located on another PC which is on the same LAN. Currently I have used ADO connection method to connect this DB in the program. Is it the best way? Is it faster than ODBC? Can you please tell what the professional would normally do. The path to this central DB is in an INI file on each PC. I know ADO support remote connection, but I'm using the following code to connect and open tables. Is this fine.

In the INI file, the DB path is defined as follows
Databasename=\192.9.205.44CTEST.MDB

[Connecting Code]
Mystr="SELECT * FROM TABLENAME;"
MyCnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & DatabaseName & ";Jet OLEDB;Database Password=" & DBPwd
MyRst.Open MyStr, MyCnn, adOpenStatic, adLockReadOnly, adCmdTableDirect

Please help ! THANK YOU !

How To Connect To Remote ACCESS DB !!
Dear Readers ,
   I am new to VB . I am doing a messaging system as my Project . The system has two parts .
The server prg and the client prg . The server and client are running on different machines .
The ACCESS DB is present in the server end . I am locating my server , and finding the server's machines IP address programmatically . But i dont know the machine name .
    
              I want my client(s) to connect to that DB and execute queries , retrive and update INFO.
Should i use DSN concept with ADODB ? if yes , how to go about ? pls help me . I am badly in need of that
for my project .I thank one and all who have taken time in reading this and replying me .
Thank u all once again .

Bye ,
Venkat .
 

 

How To Connect To Remote Sybase?
I need to create a connection to a DB server(Sybase). The db Server name is "PC03"

this is my connection string,

Code:"Driver=Adaptive Server Anywhere 6.0;DSN=PMMS;UID=dba;PWD=SQL;DatabaseFile=\Iss-pc03cPMMSPmms.db;DatabaseName=PMMS;LINKS=TCPIP{192.168.0.154}"

The error mess is : Unable to conect to the database server ; specified database is invalid.

How can i fix this error?

is there an another way to connect to the remote Sybase DB???


Thanks

Max

Connect Remote DB In VBEmbedded
Hi,
anybody knows how to connect to a remote DB using a PDA, with Windows CE, through a VB Embedded application?
 
Are there ODBC's for that kind of connection?

Remote Connect Requirement
I have a need to have a number of different people connect to a computer (not a web site) and am trying to explore the best and most cost effective method to do this

I can understand setting up a Terminal Server ability using a VPN connection, but this can become quite expensive.

A number of VNC applications exist, but these tend to be less controlable and let the person connecting see the whole desktop and cannot be channelled into a specific application (I believe)

Apart from this, can anyone suggest another way to connect remotely to a VB6 (can be VB.Net if necessary) Stock Enquiry application. (via an Internet connection)

Thanks

Connect To Remote SQL Server
Can anyone tell me how to connect a remote SQL server (through web) using VB6 on my computer.

Thanks,
Bhavesh

Connect To Remote SQL Server
How can I connect to remote SQL Server?

Cannot Connect To Remote SQL Server
Hello!!

Someone plz help me....

I want to connect to remote SQL server....i m using this connection string

DCN_M = "Provider=SQLOLEDB;Data Source=xxx.xxx.xxx.xxx;Persist Security Info=False;User ID=myid ;Password=mypwd ;Initial Catalog=mydbname;"


SQLQuery = "Select fieldname from Tablename"
Set rs = New ADODB.Recordset

rs.Open SQLQuery, DCN_M, 1, 2


but i get an error message

runtime error -2147467259(80004005)

[DBNMPNTW]Specified sql server not found



but when the same program is run on another pc in the Lan it runs fine...this pc uses windows 2000 and my pc uses win 98....but i dont think that shd make a difference...


Alpa

Connect To A Remote Computer And Zip Files
Could someone point me in the right direction on how to connect to a remote computer and then zip some files and pull them back to a server. I would like to write a small backup program for a couple of computers at work.

Connect To MSDE From Remote Location
New to this part of the tech...Have a MSDE db that I use locally. The front end of the db is a vb6 app.

I need to connect to this db from a remote location, which may vary.

Correct me if I wrong -

1 - I can connect to the db from a remote location either by a static IP or a VPN?

2 - The only code I need to change on the front end vb6 app is the connection string/path where the MSDE db exists?

INet Ftp Cant Connect To Remote Host
Why does this not work?

Private Sub Command1_Click()

ChDrive "c"
ChDir "c:"

ftp.Cancel
ftp.Protocol = icFTP
ftp.URL = "ftp.geocities.com"
'also tried geocities.com ftp://geocities.com
'ftp://ftp.geocities.com
ftp.UserName = "username"
ftp.Password = "password"
ftp.Execute , "PUT c:windowshardware.txt *.*"
End
End Sub

The error is "Unable to connect to remote host

Unable To Connect To Remote System
I've written a code to access an image from a folder on another machine :

Private Sub cmdURL1_Click()
CamImage1.URL= "http:\192.168.9.70NewFolderInetpubamit.jpg"
CamImage1.Stretch = True
CamImage1.Display = True
MsgBox ("lk")
End Sub

But i'm getting an error because this particular image is in c: , so how will the compiler recognize in which drive the particular image is present without mentioning it the drive in the code.

please help!!!!

How To Connect To Remote Server From My Laptop
hi friends,

           can any one explain me, "how can i connect to remote server and get its ip address and host name from my laptop" through vb code. Its very important to me .plz.... help me.

            awaiting ur reply.

urs
suma.n

Using Winsock To Connect To Remote Server
hai


In my project i sholud connect with the remore server(https://ssl.bizhostnet.com/mysql) and access the database from it.For this i decided to use winsock control but i dont know how to connect using it.if anybody know please help me

Thanks
Ramya

Cannot Connect To Remote Server Using DCOM
I created a DCOM Client/Server Application using Visual Basic as instructed in the following link http://support.microsoft.com/kb/266717/EN-US/. When both the client and server are on the same computer, it works just fine. It fails when the server is run on a remote computer. I'm a little confused as to how the client knows to reference the server when it's located on the remote computer. When client and server are on the same computer, the references is made locally but on a remote server, how can you set the reference? I keep getting the Runtime error '462', "The remote server machine does not work or is unavailable." The client/server settings for DCOMCNFG are correct and I'm able to ping the server from the client and vice versa. Any help is much appreciated.

Connect Access On Remote Server Using ADO
Hi All,

I am using VB6 and access 7.What will be connection string if i want to connect access database which is not on the local pc but at remote server using IP Address of that server with out using DSN.

Thanks in advance.

Jignesh

Promlem: Connect To Remote SQL Server
I have a big problem about connecting to a remote SQL server.
I have do all the settings in the "Client Network Utility". In which I provide the path of the SQL server and then go back to
"Enterprise Manager" ---> "SQL Server Group" ---> Start "New SQL Server Registration" --->..... and finally I got the message:
"Werg --SQL Server does not exist or access denied.

I have tried many times, but it still got that message. I'm sure that the path of that server is correct.

Do anyone get any idea what is wrong in my connecting to that server ?

Please help me !!!!!

Copyright 2005-08 www.BigResource.com, All rights reserved