I using VB2005, and I would like to create same simple program that related to the Access or SQL database. The problem is, I want My database is store in server, and i can remote access to the server's database for Inserting, Deleting, Editing and updating the database that store in server. And i also can access the database using my VB2005 program to edit the record in the server database through Internet Connection. Can VB2005 solve above problem Can someone HELP HELP HELP me up asap. Thank Thank Thank ...
How to connect to Server Database (Remote Acccess)
Hot Topic
- Passing range objects as parameters into and out of subroutines in VB for Excel
- From .Net 2003 to VS2005
- Formatting a Cell within a GridView
- Get the latests File Created
- IO.Compression
- Move form with Custom Border
- how2 show "access key" underlined on button
- VB6 get function in VB.net
- can Serial device data be transmit to web_page.aspx directly?
- regsvr dialog confirmation
How to connect to Server Database (Remote Acccess)
MrOctree
carlop
Is there only one way to do remote access I mean only using SQL Server
How about my customer is not willingnest to expend with SQL Server I mean it is only a tiny company ...
and if there are only the way (SQL Server Solution) , Is there posible I propose them using MSDE2000.
which stand for Microsoft Desktop Engine 2000. And if possible , is there any Coding references for it ..... ;}
Thanks ....
Kirt C.
First thank you for the reply. Is it possiable to connect to the access database in web with my application. then what shoud be the connection string. i have tried ths connection string like this.
Provider=MS Remote;Remote Server=www.xyz.in;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Mydb.mdb;User Id=admin;Password=;
but while opening the connection it will not generating any error. but while executing any select statement it will generating a error
"Specified cast is not valid."
Sql4088
not really, but even if so - bad bad bad bad idea as access really is only for client purposes and the connection made to it can only be 1 (or a couple perhaps) at any time.
SQL Server is the way to go!
tkrasinger
well this is a .NET forum, VB6 is not supported now.
to connect to SQL Server, create a connection string for SqlConnection:
Dim theSQLConnection as new SqlConnection(ConnectionStringHere)
Connection strings:
trusted security:
"Server=ComputerNameHere;Database=pubs;Trusted_Connection=True;"
username/password:
"Server=ComputerNameHere;Database=pubs;User ID=UserName;Password=PassWord;Trusted_Connection=False"
Sai A
Thanks for replying .... BUT ....
I see that someone using <MS Remote> provider to doing Remote Accress in ADO connection String.
what about this Can it connect to database (Access Database ) throught Intenet Thanks .....
Tryin2Bgood
How if they use up VPN(Virture Private Network) as networking through Internet connection.
can above coding work That question also ... Is there confirmed no other way to remote access to
Mircosoft Access database using VB 6.0 I mean maybe using ADODB connection like had mention above.
(But solution mention above is for SQL database, I need Microsoft Access database) ,, "")) , Howeve
Thank You very much ... to all any related informaton provided.... Thank you ...
HKT
Jazoned
tm9t9
Mike36
vande013
Still that question ... :)
Is any way can find out the coding references , I mean Coding Sample using VB 6.0... ")
and How about the setting for that if using SQL server , because I'm very very very new to
sql Server ... Thank You ... ::)
aghiondea
pfontyn