Database

Re: Use Mssql like Access

11-Mar-07 6:40

It's kind of possible, but the only way to make it work is if the machine has SQL Server Express installed on it. You simply cannot get around that requirement.

Dave Kreskowiak
Microsoft MVP - Visual Basic

S Douglas12-Mar-07 0:43

S Douglas

12-Mar-07 0:43

If you absolutly can't run SQL Express, have you looked at SQL Server Compact Edition[^]

http://www.microsoft.com/sql/editions/compact/default.mspx[^]

I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

Re: Use Mssql like Access

LongRange.Shooter16-Mar-07 7:38

LongRange.Shooter

16-Mar-07 7:38

The whole purpose of Sql Server is to have data developement projects move out of the amateurish world of Access. What you do is the following:

The application would go on any machine but you create a connection string
in the app.config that contains all of the connection data.

Now in your connection string you specify some url "\\DevelopmentServer" for example.
Whatever you do -- eliminate all existance of localmachine from your connections!!!

Now on the development machines you modify the hosts file as follows
your machine : DevelopmentServer 127.0.0.1
others machine: DevelopmentServer {your ip address}

The only downside to this approach is that any time your IP is reissued via DHCP you need to have the others update their hosts file. The other possibility is you have your engineers give your machine a fixed address until you can deploy a real database server with a fixed address.

storing many no. of labels n textboxes at one time

manni_n10-Mar-07 7:10

manni_n

10-Mar-07 7:10

i have 1 labels, 1 text box and one check box
suppose label contains name,
in textbox user have to enter its age
and checkbox is checkd if he is married.

i have given conneection string using oledb in access sheet
and its storing the values of label, textbox and checkbox succesfully
but nw i have problem when i have many number of labels like thereare more than one name and correspondin textboxes and checkboxes.
when i enter all the values i want them to get store on one button click in my acccess table.

m uanble to implement any logic.
can smbody help.... please tell the stored procedure
u can tell on either acces or SQL server 2000.
thanks

How to select any field that contain a certain word .. SQL server 2000

kindman_nb10-Mar-07 6:22

kindman_nb

10-Mar-07 6:22

Hi

I'm easy to me to select any field that begain with any letter or word ,,
but how can I select all fields that contain a word like "bil" ..

jooooo

Re: How to select any field that contain a certain word .. SQL server 2000

alexrad11-Mar-07 0:36

alexrad

11-Mar-07 0:36

full text index

Re: How to select any field that contain a certain word .. SQL server 2000

mghiassi11-Mar-07 0:19

mghiassi

11-Mar-07 0:19

Hi You can select these fields by LIKE operator
Example:
SELECT * FROM MyTable WHERE MyField LIKE %c "bil" c%

Re: How to select any field that contain a certain word .. SQL server 2000

mghiassi11-Mar-07 2:15

mghiassi

11-Mar-07 2:15

Hi Excuse me
Your code look like this
SELECT * FROM MyTable WHERE MyField LIKE '%bil%'

Re: How to select any field that contain a certain word .. SQL server 2000

kindman_nb11-Mar-07 5:28

kindman_nb

11-Mar-07 5:28

Thanks My friend
it's ok Rose | [Rose]

jooooo

SQL 2000 Client [modified]

TheEagle10-Mar-07 0:55

10-Mar-07 0:55

Hi..

Iam trying to connect to a host sql server 2000 using SQL enterprise manager.I made it successfully using one of my desktop computers but I could not do it using my new Laptop.When I try I get the error:specified sql server not found.I dont know what cause this problem.May be because I have Mcafee installed on this laptop But I don't know how to fix this problem?.

Please any advice could be helpful.

-- modified at 11:01 Saturday 10th March, 2007

I am too late but i will never give up

Dave Kreskowiak11-Mar-07 4:28

11-Mar-07 4:28

You've either got a name resolution problem or a firewall issue.

Dave Kreskowiak
Microsoft MVP - Visual Basic

TheEagle11-Mar-07 5:51

11-Mar-07 5:51

May you explain to me what do you mean by name resolution problem?

I am too late but i will never give up

Dave Kreskowiak11-Mar-07 6:37

11-Mar-07 6:37

Open a CMD prompt and type PING sqlServerName like it shows in your connection string. If it doesn't come back with an IP address, your machine can't resolve the name, and hence, can't find the IP address of the server.

If if CAN get the IP address, but the server doesn't respond, you either have a network routing issue or a firewall or two in the way.

Dave Kreskowiak
Microsoft MVP - Visual Basic

TheEagle11-Mar-07 6:16

11-Mar-07 6:16

It gives me the IP and other data about sent and recieved packets.

What could I do to solve this problem?

I am too late but i will never give up

Dave Kreskowiak11-Mar-07 14:04

11-Mar-07 14:04

The TCP/IP stack of the target machine responds. It didn't tell you anything about the SQL Server that's apparently either not running on it or is being blocked by a firewall.

Dave Kreskowiak
Microsoft MVP - Visual Basic

TheEagle12-Mar-07 0:07