Database

FirstPrevNext

Use Mssql like Access Tyler4511-Mar-07 4:38 Tyler45 11-Mar-07 4:38  Hello Friends, I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible? If it is, how can it be? Thanks for your helps? Best Regards Eray Re: Use Mssql like Access Dave Kreskowiak11-Mar-07 6:40 Dave Kreskowiak 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 Re: Use Mssql like Access 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 jooooo SQL 2000 Client [modified] TheEagle10-Mar-07 0:55 TheEagle 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 Re: SQL 2000 Client Dave Kreskowiak11-Mar-07 4:28 Dave Kreskowiak 11-Mar-07 4:28  You've either got a name resolution problem or a firewall issue. Dave Kreskowiak Microsoft MVP - Visual Basic Re: SQL 2000 Client TheEagle11-Mar-07 5:51 TheEagle 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 Re: SQL 2000 Client Dave Kreskowiak11-Mar-07 6:37 Dave Kreskowiak 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 Re: SQL 2000 Client TheEagle11-Mar-07 6:16 TheEagle 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 Re: SQL 2000 Client Dave Kreskowiak11-Mar-07 14:04 Dave Kreskowiak 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 Re: SQL 2000 Client TheEagle12-Mar-07 0:07 TheEagle 12-Mar-07 0:07  Thank you very much for all these valuable informations.I have change some network settings in mcafee and install some updates then I delete the old SQL server registeration and add a new one with the same settings but with a different name and it works.May be the old name was similar to one of the SQL servers in the network and it caused some kind of conflict.But now every thing is working perfectly. Thank you for helping me all the time. I am too late but i will never give up Sql Server anishmm10-Mar-07 0:22 anishmm 10-Mar-07 0:22  Hi I have a table ID Name THEAD VAlue ------------------------- 1 Anish H1 400 2 Anish H2 300 3 Joseph H2 600 4 Joseph H1 100 5 Anish H3 50 6 Joeph H3 60 ------------------------ Can I get output as shown below Name H1 H2 H3 ---------------------- Anish 400 300 50 Joseph 600 100 60 -------------------- regards anish mm Re: Sql Server Hesham Amin10-Mar-07 3:37 Hesham Amin 10-Mar-07 3:37  You need PIVOT functionality. What database and version do you use? Hesham A. Amin blog Re: Sql Server alexrad11-Mar-07 0:35 alexrad 11-Mar-07 0:35  Ofcourse, but with some restrictions, such how many h1 h2 h3 exists bcs they will becom coulmns Perhaps there will be a temp table #T(name nvarchar(x),[h1] integer,...) and over some loop or cursor(wich is slow) u will fill the #T Re: Sql Server Harini N K11-Mar-07 18:36 Harini N K 11-Mar-07 18:36  Hi Can you send me the table structure and with same data? You need to use CrossTab SP. I will modify it based on your table structure and will mail you. Harini problems in setting up transactional replication in SQL Server 2000 Rocky#9-Mar-07 20:48 Rocky# 9-Mar-07 20:48  Hi every one, Well I’m working on this project that requires the database to be replicated on another server as well. I’m working in SQL server 2000 Enterprise Ed. And this is my first project of that sort. It also requires a little horizontal partitioning of rows of some tables. Now I’m trying to get this replication going but every time its giving me errors. I’m trying to establish transactional replication here and the servers are connected over LAN. Right now I’ve tried doin it by making a new database in the subscriber and selecting the option to ‘make new schema and data’ and already ‘existing schema’ as well. In the first case it gives me error that the ‘ALTER TABLE statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'FK_Products_Products'. The conflict occurred in database 'Server_ATech', table 'Products', column 'CatID'.’ And while I was not initializing the schema it gave me an error over the absence of a stored procedure and that one looked like something related to replication but anyway… Now I don’t have any idea what else to do… plz tell if it’s a good idea to make a single publication when ur having abt 40 tables to replicate. What should I do… or more likeably; how should I do it??? Please help me as early as you can coz I really have a very short time to complete this thing. Thanks in advance, Rocky Re: problems in setting up transactional replication in SQL Server 2000 Hesham Amin9-Mar-07 22:33 Hesham Amin 9-Mar-07 22:33  Rocky71 wrote: And while I was not initializing the schema it gave me an error over the absence of a stored procedure and that one looked like something related to replication but anyway… There is an option while creating the article that specifies whether to call stored procedures to insert,update,delete data or use queries (third tab I think, I don't have SQL 2000 now) Try to use queries not stored procedures. Also check: Setup Transactional replication: step by step guide[^] Hesham A. Amin blog Re: problems in setting up transactional replication in SQL Server 2000 alexrad10-Mar-07 22:47 alexrad 10-Mar-07 22:47  hi i'm doing somtehing like that right now, using linked servers and remote sp. Re: problems in setting up transactional replication in SQL Server 2000 Rocky#11-Mar-07 23:18 Rocky# 11-Mar-07 23:18  yea well, I've kept on trying n trying again and now the replication is working... but the changes at the subscriber are not getting updated at the publisher although I have the proopagate updates my using MSDTC checked.... ahh I'll just tri it again lets see what happens now. Rocky

Last Visit: 31-Dec-99 18:00     Last Update: 13-May-24 20:23 Refresh ᐊ Prev1...1639164016411642164316441645164616471648 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.