Snitz Forums 2000 - I want to create a database sql shared between 2 o

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS SQL Server

I want to create a database sql shared between 2 o

New Topic

Printer Friendly

Author

Topic

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 09 May 2013 : 09:37:15

I want to create a database sql shared between 2 or more computers
I use a local server asp
And Microsoft SQL Server 2005

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 09 May 2013 : 22:11:57

That's easy enough. Create the database, then with your second computer, access it using the IP address of the first computer, something like this:

strConnString = "Provider=SQLOLEDB;Data Source=192.168.1.108;database=DBName;uid=UName;pwd=PWord;"

Edited by - Carefree on 09 May 2013 22:44:51

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 10 May 2013 : 18:13:55

Tried and did not succeed

strConnString = "Driver = {SQL Server}; Server = 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 244434535;"

Did not recognize the database and receive this message

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

/5000/conn.asp, line 14

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 11 May 2013 : 04:50:55

Try changing the provider to SQLOLEDB

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 11 May 2013 : 06:10:14

is it sql 2005 or 2005 express database?
have you got it set up to use SQL logins?

MVC .net dev/test site | MVC .net running on Raspberry Pi

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 11 May 2013 : 10:24:25

quote:
Originally posted by Carefree

Try changing the provider to SQLOLEDB

Professor Carefree same error when you change to SQLOLEDB

Professor Carefree same error when you change to SQLOLEDB

'strConnString = "Driver = {SQL Server}; Server = 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 5555555;"
'Provider = SQLNCLI10; Server = tcp: 192.168.1.2; Database = ahmed; UID =ahmed; PWD = 5555555;
'Conn.Open "Provider = SQLNCLI10; Server = tcp: 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 55555555;"
'Conn.Open "Provider = SQLOLEDB; Data Source = 192.168.1.2; database = ahmed; uid = ahmed; pwd = 5555555;"

'Conn.Open "Driver = {SQL Server}; Server = 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 5555555;"

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 11 May 2013 : 10:26:40

Professor HuwR the
Use

microsoft sql server management studio express

Doug G
Support Moderator

USA
6493 Posts

Posted - 11 May 2013 : 18:44:53

You may need to open the SQL server TCP/IP port 1433 and maybe 445 in any firewalls, and/or forward these ports through any routers between your client and server.

======
Doug G
======
Computer history and help at www.dougscode.com

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 15 May 2013 : 06:17:02

Ejrebit did not succeed Professor
Doug G

AHMEDHHH1
Junior Member

Egypt
105 Posts

Posted - 15 May 2013 : 06:36:48

I wanted to try my idea to do a shared database

To do the map network drive or sharing
And summoned the database file from the program
sql server software but does not show the files on the network

You can modify the program settings to access the files in a computer network?

Edited by - AHMEDHHH1 on 15 May 2013 06:39:48

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 15 May 2013 : 08:03:08

Of course, that's what the connection string should accomplish.

Topic

New Topic

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.16 seconds.