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
- registering filetypes to an app
- Proper Syntax Highlighting in VB05 IDE
- Reading a Word Table from .Net Application
- Anyone know of a tool for instant translation within an application?
- i want to open a url in a browser and i want to move cursor all over the brower???
- Sending email using vb.net
- Feature Request: Regions Allowed In Method Bodies
- VBA or .NET?
- convert VB6 code to .NET?
- ? Textbox
Visual Basic
- Getting the icon of a file.
- retrieving domain user info
- Open default email program (Outlook, for example) when pressing a link
- How to do a loop to insert string to db in everyrows(Window Application)
- Is it possible to call a .net dataset from a vb 6 app.
- Using panel in a custom control
- MDI parent form and child form
- Word.doc
- Simple Problem: Allow Only Number Input In Text Box
- How to charting in the VB 2005?
How to connect to Server Database (Remote Acccess)
Kovalev Maxim
KThelen
Fox3
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 ...
TCSC
黃泓量 Jeremy Wong
daat99
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."
Eric_Sun
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 ....
MaseYo
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 .....
su45937
bszom
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!
Rune Gulbrandsen
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 ... ::)
Mzladybug
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"
Evgeny Popov
LORDTEK