Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> Visual Basic >> Visual Basic General

How to connect to Server Database (Remote Acccess)

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 ...

[516 byte] By [CKS] at [2007-12-23]

«« Licensing and Scope
»» Copy and Paste an existing Ordered Tests within same Project sometimes gives error

# 1

SQL server is probably the easiest to do it with. You will need to set up the server for access from the outside world. Here is an article on how to set up sql express for network access.

KenTucker at 2007-8-30 >

top of Msdn Tech,Visual Basic,Visual Basic General...

# 2

How if i using VB6.0 and database is Mircrosoft Access that located in Server ? Thanks ... ;)

CKS at 2007-8-30 >

# 3

"Provider=sqloledb;Network Library=DBMSSOCN;Data Source=130.120.110.001,1433;Initial Catalog=MyDatabaseName;User ID=MyUsername;Password=MyPassword;"

Mr.007 at 2007-8-30 >

# 4

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 .....

CKS at 2007-8-30 >

# 5

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!

ahmedilyas at 2007-8-30 >

# 6

Yes...you can connect directly to internet. Only enter the ip address of your host...

Mr.007 at 2007-8-30 >

# 7

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 ....

CKS at 2007-8-30 >

# 8

with SQL of course you can! Just enter the IP address/domain to it.

ahmedilyas at 2007-8-30 >

# 9

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 ... ::)

CKS at 2007-8-30 >

# 10

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"

ahmedilyas at 2007-8-30 >

# 11

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 ...

CKS at 2007-8-30 >

# 12

I have a problem in connecting my application (desktop application in vb.net) with a remote database (access data base) that is in web.. Please any one have any idea can reply to me.

prasant.swain at 2007-8-30 >

# 13

you may need to enter the IP Address of the web site containing the MS Access database but remember you are recommended to use SQL instead of MS Access, since MS Access is really for "local" usage rather than web

ahmedilyas at 2007-8-30 >

# 14

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."

prasant.swain at 2007-8-30 >

Visual Basic

Visual Basic General

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'How to connect to Server Database (Remote Acccess)', No.604509,Posted by CKS

How to connect to Server Database (Remote Acccess)

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Site Classified